Access violation at address 00F03267 in module ‘Toad.exe’.
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
Oracle, TOAD

get the value from XML in a sql table
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

To increase number and combine data using sql
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

Display date in Oracle 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

hi can anybody tell me how to combine these two queries
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

Large number rounding in Oracle 10g
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

Inserting parent and child tables at a time
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

Oracle-developers
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?
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

retrive data from 3 tables
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

Color coding of Toad for Oracle-
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

Crystal Reports Cannot query View
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

Oracle PL/SQL Toad for Oracle-How to make editor generate a script for tables,views,packages so that the script can be searched
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

Database report output shows multiple pages
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

Multiple Tables to Bulk Import .sql script
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

connect sys as sysdba
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
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
Database, TOAD