This is an issue when connecting to a database; access violation at address 00F03267 in module ‘Toad.exe’. what can I do to resolve this error? Thanks in advance.
Answer Question | November 21, 2012 2:02 PM
i created a table which contains many columns. out of that one column is having xml codings which are saved as xml info. We are having number of parameters in one row data of that xml info. Like this we are having multiple rows. I want to select the value from the xml column of [...]
Answer Question | February 28, 2012 10:17 AM
SQL Developer, TOAD
hi, I want to create a sql that generate a number of 4 digits with combination of character input.The number will increase if it is new record. for example : category = ‘P’ so the output will be : P-0001 for the next record the output will be : P-0002 any ideas? thanks.
Answer Question | September 22, 2010 3:39 AM
Oracle, SQL, SQL Data Set, TOAD
how to display all the months between two dates.my fromdate format is ‘mon-yyyy’ and todate format is ‘dd-mon-yyyy’.plz sugest
Answer Question | August 9, 2011 3:07 AM
Oracle, Oracle Database, TOAD, Toad Data Modeler
1. SELECT count(*) AS Cnt1 FROM tsau_pre_msges WHERE ( (EXTRACT (DAY FROM Jms_timestamp)-EXTRACT (DAY FROM ins_time))*24*60 + (EXTRACT (HOUR FROM Jms_timestamp)-EXTRACT (HOUR FROM ins_time))*60 + EXTRACT (MINUTE FROM Jms_timestamp)-EXTRACT (MINUTE FROM ins_time) ) BETWEEN 1 AND 5 It will count messages from total in the next query it vl give percentage from count value to [...]
Answer Question | July 26, 2010 11:32 AM
Oracle, Oracle queries, Oracle Query, TOAD
Oracle 10g database table with a column having data type Number(20) stores 18 digits organization code. When this data is retrieved in SQL*Plus or Toad it is displayed in scientific notation format. The display format can be changed from scientific notation format to number format. But, for some reason the number rounds up. For example if the [...]
Answer Question | July 19, 2010 8:27 PM
Oracle 10g administration, Oracle 10g Database, Oracle database administration, SQL Plus, TOAD
Is there any way to insert parent and child tables data with select statement? On record in parent table and n number of records in child table. Please let me know if possible.
Answer Question | February 22, 2013 6:41 AM
Oracle Database, Oracle Statements, TOAD
WHILE ASSIGNING A VALUE TO PROCESSED_TIME=:NEW.JMS_TIMESTAMP-:NEW.INS_TIME (All are timestamp type ) how to subtract that one. CREATE OR REPLACE TRIGGER SAUUSER.TRG_MSGES_STATISTICS AFTER UPDATE OR UPDATE ON SAUUSER.TSAU_PRE_MSGES REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE BEGIN IF INSERTING THEN INSERT INTO TSAU_MSGES_STATISTICS(PORTCODE,MSG_ID,DOCTYPE,MSGTYPE,SUBMISSION_TIME) VALUES(:NEW.PORTCODE, :NEW.MSG_ID, :NEW.DOCTYPE, :NEW.MSGTYPE, :NEW.INS_TIME ); END IF; IF UPDATING [...]
Answer Question | July 7, 2010 11:50 AM
Oracle applications, Oracle developers, Timestamp, TOAD
Which tool is best in all aspects – speed, performance, user friendly, to do all activities etc - PL/SQL Developer or SQL Developer or TOAD
Answer Question | May 20, 2010 6:38 AM
Oracle, PL/SQL Developer, SQL Developer, TOAD
HI i need to retrieve data of 3 tables using one more master table wat are the possible options Union,Joins anything else? with good performance please guide for considering the performance as the retrival count is huge in my case
Answer Question | May 21, 2010 8:31 AM
Oracle, SQL, TOAD
Hello all, I am working with Toad, please help me in understanding colors used fo display in SQL Editor of Toad for Oracle. Like what color is used to represent a variable, table, conditions ….. – Thanks
Answer Question | December 2, 2009 9:28 AM
Oracle, SQL Editor, TOAD
I cannot query result from my custom Database View created from TOAD SQL, anyone knows why? I have granted access for the user.
Answer Question | October 20, 2009 3:16 AM
Crystal Reports, Crystal Reports Viewer, TOAD
Hello, I am using “Toad for Oracle” and i am trying to find a way to search for certain words and numbers in the comments in scripts. I know you could use the create a script button and then control f to search for the words in the script. But is their a way to [...]
Answer Question | July 21, 2009 7:40 PM
Oracle, Oracle PL/SQL, PL/SQL, TOAD
When I run a report, I see multiple pages, but running the query directly on the database using TOAD gives me only one record. How do I find why the query gives multiple pages? I can ofcourse set printing option as “First Page” for all the fields, but I need to know why the duplication [...]
Answer Question | March 11, 2009 9:08 AM
Database administration, Database reporting, TOAD
I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then [...]
Answer Question | April 22, 2009 9:30 PM
Oracle, Oracle import/export, Oracle Table Export, SQL, Sql Script, TOAD
how to connect sys as sysdba in toad software and in isqlplus. When i tried in isqlplus and in toad by connecting as “sys as sysdba” i got the error. please give me a solution.
Answer Question | April 25, 2008 4:00 PM
connect sys as sysdba, iSQL*Plus, SYSDBA, TOAD
I’m not able to use hints in my tables. TOAD is treating it as comment I think. Do I need to do some setting.????
Answer Question | January 28, 2008 11:34 AM