Top "Toad" questions

ORA-12170: TNS:Connect timeout occurred

I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having …

oracle toad ora-12170

How can I solve ORA-00911: invalid character error?

I tried to execute an SQL INSERT with Toad for oracle: INSERT INTO GRAT_ACTIVITY (UUID, IP_ADRESS, SEND_MAIL, …

sql oracle toad

Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?

Is there a workaround for 'ORA-01795: maximum number of expressions in a list is 1000 error' I have a query and …

sql toad

SQL query for extracting year from a date

I am trying to create a query that gets only the year from selected dates. I.e. select ASOFDATE from …

sql oracle toad peoplesoft

How can I get all sequences in an Oracle database?

Is there any command that I can run so that I can get all the sequences? I am using Oracle 11…

sql database oracle sequence toad

Using IF ELSE in Oracle

As a web developer, I know how to use the IF ELSE in multiple languages. However, I am learning how …

sql oracle toad

Searching for Text within Oracle Stored Procedures

I need to search through all of the stored procedures in an Oracle database using TOAD. I am looking for …

sql oracle stored-procedures full-text-search toad

Toad for Oracle..How to execute multiple statements?

I have some 800-1200 INSERT statements generated from an excel sheet. I want to run these in TOAD - Oracle …

oracle toad

Why does Oracle not find oci.dll?

I use TOAD 10.2.1.3 under Windows7 and get the following error: Cannot find OCI DLL: C:\Oracle\Product\11.2.0\oci.dll that …

database oracle toad

How to debug a stored procedure in Toad?

I have Oracle 10g installed and there is a package which has a number of cursors and procedures, how do …

oracle debugging stored-procedures toad