1
  • 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.

    Bigsammy2925 pointsBadges:
  • 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.

    Ammu35 pointsBadges:
  • 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 that table using...

    Rithunsi5 pointsBadges:
  • 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

    Deb4u50 pointsBadges:
  • 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.  

    Syirah5 pointsBadges:
  • 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...

    RizwanSharief30 pointsBadges:
  • 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...

    Techguys90 pointsBadges:
  • 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...

    RizwanSharief30 pointsBadges:
  • 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

    Inprise610 pointsBadges:
  • 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

    RajeshITK65 pointsBadges:
  • 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

    SantoshGampa15 pointsBadges:
  • 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.

    Ardianta5 pointsBadges:
  • 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 do it using a query or to create a...

    Dug50 pointsBadges:
  • 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 save it as an .sql file. If I select multiple...

    ADMIntegrated5 pointsBadges:
  • 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 occurs.

    Ms123115 pointsBadges:
  • 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.

    Itsee10 pointsBadges:
  • 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.????

    Vikas5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following