Oracle Forum - Oracle - Toad World

Oracle Forum

Oracle Community

Community Discussion

MalcolmMarais
Follow / 24 Aug 2016 at 1:06pm / Oracle

Training on using Toad for Oracle as a data query tool

Expand content
Please team. I head up a team of COBOL developers who are new to Oracle and need to use TOAD for Oracle to query data during testing and for data calls from management. Looking at this page http://www...

Please team.  I head up a team of COBOL developers who are new to Oracle and need to use TOAD for Oracle to query data during testing and for data calls from management.  Looking at this page http://www.toadworld.com/p/toad-education, its not clear to me which of the course would cover querying.  Any ideas please?

44 0 / Create an account to join the discussion.
yinhai_yang
Follow / 11 Aug 2016 at 6:09pm / Oracle

trying to compare same schemas in two 12.2.0.2 databases for constraints...

Expand content
clarity schemas fo eddwprd and edwdev. Compare only constraints (no check constraint, but including FK, unique index and primary key) generated error is: list of index out of bounds(0). When I compare...

clarity schemas fo eddwprd and edwdev. Compare only constraints (no check constraint, but including FK, unique index and primary key)

generated error is: list of index out of bounds(0).

When I compare schemas of entire schema objects, it went farther, eventually generated more than 1000 differences and failed.

I used utility\copy user setting to reset customerized config (I did not have any because this is a new laptop and a new install), but that did not help with the error.

I need to compare different object types of the schema to sync the newly refreshed clarity schema in the second database.

Please help.

Thanks.

Yinhai

92 0 / Create an account to join the discussion.
jollydoe
Follow / 25 Jun 2016 at 9:02am / Oracle
Latest post by on 9 Aug 2016 at 7:53pm

Percentage

Expand content
Greetings! I have a query that gives me correct answer but I can't figure out how to get percentage. What I have tried so far is as follows: ......................................................

Greetings!

I have a query that gives me correct answer but I can't figure out how to get percentage. What I have tried so far is as follows:

.............................................................................................................................................................................................

select SHRTCKN_CRN CRN, count (distinct (SHRTCKN_PIDM)) PIDM, SHRTCKG_GRDE_CODE_FINAL GR

/*round((((count(SHRTCKG_GRDE_CODE_FINAL))/count (distinct (SHRTCKN_PIDM)))*100), 2) Perc*/ 

from SHRTCKN, SHRTCKG 

where SHRTCKN_TERM_CODE =: p_term
and SHRTCKN_PIDM = SHRTCKG_PIDM
and SHRTCKN_TERM_CODE = SHRTCKG_TERM_CODE
and SHRTCKN_SEQ_NO = SHRTCKG_TCKN_SEQ_NO
and SHRTCKG_GRDE_CODE_FINAL in ('A', 'B+', 'B', 'C+', 'C', 'D+', 'D', 'F', 'FA', 'GR', 'W', 'WF', 'I')
group by SHRTCKN_CRN, SHRTCKG_GRDE_CODE_FINAL

.............................................................................................................................................................................................

Result of my query is as follows:

CRN     PIDM GR

20001     4     A
20001     4     B
20001     4     B+
20001     2     C
20001     7     C+
20001     7     D
20001     2     D+
20001     3     F
20002     8     A
20002    14   B
20002    11   B+
20002    2     C
20002    7     C+
20002    2     D+
20002    1     W

.............................................................................................................................................................................................

I am trying to find percentage of GR per CRN i.e count of PIDM per GR per CRN divided by total count of PIDM per CRN. As you will notice from the commented area of my select statement, my attempts have not been successful.

Any assistance provided would be appreciated.

Unanswered 226 1 / Create an account to join the discussion.
david.tin
Follow / 2 Aug 2016 at 12:16pm / Oracle

Data Modeler Reverse Engineering of Ingres DB and generate Oracle...

Expand content
Hi All, I need to know if Data Modeler can reverse engineering an Ingres DB (9/10) ? If yes, can I generate the DDL for Oracle database, I need to migrate Ingres DB to Oracle and need a tool to generate...

Hi All,

I need to know if Data Modeler can reverse engineering an Ingres DB (9/10) ? If yes, can I generate the DDL for Oracle database, I need to migrate Ingres DB to Oracle and need a tool to generate DDL  for Oracle DB.

Thank you,

David

61 0 / Create an account to join the discussion.
gselvam
Follow / 27 Jul 2016 at 2:19pm / Oracle

Window 8.1 Pro 64 Bit - Need Toad Version

Expand content
HI All, My laptop is Windows 8.1 Pro -64 bits. I would like to install TOAD to connect Oracle 11g (Apps DB). Please advice which version of TOAD we should install. Thanks for your timing and...

HI  All,

 

My laptop is Windows 8.1 Pro -64 bits. I would like to install TOAD to connect  Oracle 11g  (Apps DB).

Please advice which version of  TOAD we should install.

Thanks for your timing and helping me.

77 0 / Create an account to join the discussion.
hxi
Follow / 1 Jul 2016 at 8:11pm / Oracle
Latest post by on 12 Jul 2016 at 5:52pm

Using BULK COLLECT INTO

Expand content
Hi, I am trying to use BULK COLLECT INTO with LIMIT clause in a stored procedure. I am using a cursor to get data (500k rows) from a remote database (a table in Teradata), then insert these records to...

Hi, I am trying to use BULK COLLECT INTO with LIMIT clause in a stored procedure. I am using a cursor to get data (500k rows) from a remote database (a table in Teradata), then insert these records to a table in Oracle. After I run the procedure, the table in Oracle only has 1000 rows. Just wondering why not all the 500k rows were being inserted. Here is what the code looks like:

CREATE OR REPLACE PROCEDURE P_TEST

 

   AS

      v_msg_proc_name varchar2(30) := ‘P_TEST’;

      

       g_err_code VARCHAR2(10);

       g_err_msg VARCHAR2(400);

       g_err_msg_log VARCHAR2(4000);

 

       -- Create a record set for bulk insert

       CURSOR c_test_rec

       IS

       (

       select a.*

       from a table in Teradata@dblink a -- a table in Teradata that has 500k rows and 50 columns

         );

 

       TYPE c_test_table IS TABLE OF c_test_rec%ROWTYPE;  

       c_test_table_ins c_test_table := c_test_table();    

 

   BEGIN

 

       EXECUTE IMMEDIATE 'TRUNCATE TABLE TEST';

 

       OPEN c_test_rec;

           LOOP

               FETCH c_test_rec

                   BULK COLLECT INTO c_test_table_ins LIMIT 1000;

                   EXIT WHEN c_test_table_ins.COUNT = 0;

 

               FORALL i IN 1 .. c_test_table_ins.COUNT

                   INSERT /*+ APPEND_VALUES */ INTO test VALUES c_test_table_ins(i);

               COMMIT;

           END LOOP;

       CLOSE c_test_rec;

 

       COMMIT;

      

   EXCEPTION

       WHEN OTHERS THEN

               g_err_code := SQLCODE;

               g_err_msg := substr(SQLERRM, 1, 200);

              g_err_msg_log := g_err_msg_log || v_msg_proc_name || ': ' || g_err_code ||' - ' || g_err_msg || chr(13);

 

               IF c_test_rec%ISOPEN

               THEN

                 CLOSE c_test_rec;

               END IF;

 

   END P_TEST;

Answered 199 2 / Create an account to join the discussion.
Daniel Norwood
Follow / 15 Jun 2006 at 7:36pm / Oracle
Latest post by on 14 Jun 2016 at 9:09am

ORA-12638: Credential retrieval failed

Expand content
I encountered this error this morning and found the following info helpful (original post found here: http://www.easywebtech.com/oracle_ORA-12638.html): ORA-12 638: Credential retrieval failed If you get...

I encountered this error this morning and found the following info helpful (original post found here: http://www.easywebtech.com/oracle_ORA-12638.html):

ORA-12638: Credential retrieval failed

If you get this error first you need to check the SQLNET.ORA file. This file is located in [Oracle_Home]/NETWORK/ADMIN/SQLNET.ORA

if you see SQLNET.AUTHENTICATION_SERVICES= (NTS)

this needs to change to SQLNET.AUTHENTICATION_SERVICES= (NONE)

after that try to login to the database

5040 4 / Create an account to join the discussion.
capjlp
Follow / 13 Jun 2016 at 2:57pm / Oracle
Latest post by on 13 Jun 2016 at 9:31pm

Inserting a text field that has the date and time from staging table...

Expand content
Hi I am trying to create a sql script that inserts data from a staging table to the main table and in the staging table I have a column called datetime that is a varchar field. I am inserting all columns...

Hi I am trying to create a sql script that inserts data from a staging table to the main table and in the staging table I have a column called datetime that is a varchar field.

I am inserting all columns plus converting the datetime field to the field in the main table that has a datatype of time stamp.

Data in im DateTime staging table looks like this.

'10-JUN-16 12:00 AM'

I tried this below and it didn't work.  I got an error message saying. a non-numeric character was found where numeric was expected. My assumption is the AM is or the JUN is throwing it off.

INSERT INTO meterdatarows
SELECT 'HardCodedField',
meterid,
TO_TIMESTAMP (datetime, 'yyyy/mm/dd hh24:mi:ss'),
value
FROM meterdatarowsstaging commit;

Thanks for the help.

314 5 / Create an account to join the discussion.
t.cristel
Follow / 12 May 2016 at 6:56pm / Oracle

Export data to excel 2007 (xlsx)

Expand content
Hi Since 2 days when I am exporting the result of a query to excel 2007, I am receiving this error message "toad error tag stack not empty worksheet sheetdata row c" There is about 120...

Hi

Since 2 days when I am exporting the result of a query to excel 2007, I am receiving this error message

"toad error tag stack not empty worksheet sheetdata row c"

There is about 120 000 rows. Sometimes It works perfect sometime no.

Can any body help?

TOAD FOR ORACLE 12.1.0.22

Thank you.

Unanswered 549 0 / Create an account to join the discussion.
Lina Sengupta
Follow / 21 Apr 2016 at 9:02pm / Oracle
Latest post by on 5 May 2016 at 2:21pm

Mapping of US States with the two character State ID

Expand content
Is there any pre existing table for Mapping of US States with the two character State ID? I am parsing user entry for US states and would like to get the two character State ID. Are there any recommendations...

Is there any pre existing table for Mapping of US States with the two character State ID?

I am parsing user entry for US states and would like to get the two character State ID.

Are there any recommendations?

375 5 / Create an account to join the discussion.
Lina Sengupta
Follow / 19 Apr 2016 at 5:17pm / Oracle

TOAD for Oracle 12.6.0.53 -Package Body does not exist or you do not...

Expand content
I am a new user of Toad. I created a package then was able to compile and run it. When it came to trying some changes, these changes were not saved successfully. Next I deleted the package and tried...

I am a new user of Toad.

I created a package then was able to compile and run it.

When it came to trying some changes, these changes were not saved successfully.

Next I deleted the package and tried to create a new package and I got the Warning"

"Package Body does not exist or you do not have the necessary privilege to access it"

If this is a privilege issue?

Any help will be appreciated. Let me know if I need to give more information.

219 0 / Create an account to join the discussion.
tpetchel
Follow / 8 Apr 2016 at 7:21pm / Oracle
Latest post by on 11 Apr 2016 at 1:21pm

Create Team Project

Expand content
I have not been able to set up a team coding project using a third party VCS. I have tried with SVN TortoiseSVN and Git. I get to the same place. After successfully configuring everything up to clicking...

I have not been able to set up a team coding project using a third party VCS. I have tried with SVN TortoiseSVN and Git. I get to the same place. After successfully configuring everything up to clicking the OK button on the Create Team Project window I get the same log message: hh:mm:ss Output: VCS Provider is not set. I am running  Toad 12.7.1.11 Xpert Edition, Toad Development Suite for Oracle. My Git for Windows is v2.8.1. Any help would be much appreciated.

thanks,

Timothy Petchel

tpetchel@caci.com

293 2 / Create an account to join the discussion.
w.delange
Follow / 5 Apr 2016 at 12:22pm / Oracle
Latest post by on 5 Apr 2016 at 3:51pm

Change Oracle password using a website.

Expand content
Currently we have an application in which under certain conditions you are not able to change the Oracle password due to limitations created by the developer of the application. We are discussing with...

Currently we have an application in which under certain conditions you are not able to change the Oracle password due to limitations created by the developer of the application.

We are discussing with the developer to change that, but that will take some time, because we are on an older version and don't want to upgrade on this moment.

My question is now, has someone ever created a website/webservice, so that users can change their password?

Unanswered 397 4 / Create an account to join the discussion.
PaulZip
Follow / 29 Mar 2016 at 10:33am / Oracle
Latest post by on 29 Mar 2016 at 12:28pm

Script Output Text Colour

Expand content
I use a dark background as my default in TOAD, but this seems to cause problems with Script Output / Output tab. Unless I am missing something, there seems to be no way to change the text colour to anything...

I use a dark background as my default in TOAD, but this seems to cause problems with Script Output / Output tab. Unless I am missing something, there seems to be no way to change the text colour to anything but black, which makes the output unreadable.  See below (see image).  Can you add an option somewhere please?

208 2 / Create an account to join the discussion.
mopar969
Follow / 24 Mar 2016 at 2:02pm / Oracle
Latest post by on 26 Mar 2016 at 2:56pm

Import Multiple Data Tables t Toad Oracle at Once

Expand content
How can I import multiple data tables from an access database at once in toad oracle. Right now I have a query that I run that drops yesterdays tables and then I create new tables. Then I go into import...

How can I import multiple data tables from an access database at once in toad oracle.

Right now I have a query that I run that drops yesterdays tables and then I create new tables. Then I go into import, table data and I have to select each table from my database manually. This is time consuming, is there anyway to import all tables at once? Thanks

207 1 / Create an account to join the discussion.
Guritijo
Follow / 9 Mar 2016 at 9:36am / Oracle
Latest post by on 18 Mar 2016 at 8:45am

Access violations

Expand content
Hi, Trying to make the big step from 9.7 to 12. I installed the trial and wanted to test it in a real situation. But without knowing what I'm doing wrong I get frequently an access violation. For...

Hi,

Trying to make the big step from 9.7 to 12. I installed the trial and wanted to test it in a real situation. But without knowing what I'm doing wrong I get frequently an access violation. For the old version I have a oracle 32bits client installed. But I've also a 64bits client installed. Do I have a kind of conflict? Is it better to install 32bits of Toad? Is there a checklist with possible causes and/or solutions.

Best Regards,

Guus Goossens.

344 4 / Create an account to join the discussion.
Jian.qin
Follow / 16 Mar 2016 at 5:04pm / Oracle

Is it possible to create subfolder under View to differentiate from...

Expand content
As subject, I'd like to know if it's possible to build subfolder under View to differentiate from current views? I don't see a simple way to do that in SQL Developer, wonder if Toad for Oracle...

As subject, I'd like to know if it's possible to build subfolder under View to differentiate from current views?   I don't see a simple way to do that in SQL Developer, wonder if Toad for Oracle can offer the feature.  Thanks very much!

192 0 / Create an account to join the discussion.
student2016
Follow / 1 Feb 2016 at 1:26pm / Oracle
Latest post by on 24 Feb 2016 at 7:27am

Error ORA-06502 and ORA-06512

Expand content
Hi, i added my own "ruleset" in toad 12.8. then i clicked "save results in db" and executed the code analyzis. now I get the errors Ora-06502 and ora-06512. could anybody tell...

Hi,

i added my own "ruleset" in toad 12.8. then i clicked "save results in db" and executed the code analyzis.
now I get the errors Ora-06502 and ora-06512. could anybody tell me please why I get them?

best regards,

student2016

Unanswered 455 1 / Create an account to join the discussion.
gr_tb
Follow / 16 Feb 2016 at 9:48am / Oracle

Long live Oracle Forms/EBS + Chrome - A new Chrome Plugin for Oracle...

Expand content
Hi, thought that may be useful for some... Oracle Forms and Oracle EBS on Chrome is still alive - with SSO, Cookie and JS, and no NPAPI needed > Chrome Extension for Oracle Forms and Oracle EBS...

Hi, thought that may be useful for some...

Oracle Forms and Oracle EBS on Chrome is still alive - with SSO, Cookie and JS, and no NPAPI needed

> Chrome Extension for Oracle Forms and Oracle EBS - NPAPI-less

chrome.google.com/.../nmjefghbgfcpoobigfbalocpncklkjhk

That will shake things up :)

445 0 / Create an account to join the discussion.
aditya_kommu
Follow / 7 Feb 2016 at 9:07pm / Oracle

Scheduler Not Working(Automatic Designer )

Expand content
Hi All, My task is to excute a custom sql and export the result to excel . I have toad for oracle I have followed: https://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/09/21/task...

Hi All,

My task is to excute a custom sql and export the result to excel . I have toad for oracle

I have followed:

https://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/09/21/task-automation-in-toad-174-saving-you-hours.

I have wen to automated designer and right clicked  on Action and said schedule and scheduled for a time, it is showing up in Scheduled items , but  task will not excute , Can some one tell me Do I need to do anything else.?

300 0 / Create an account to join the discussion.