I've got an SQL-table with some million entries and I tried to query how much entries are older than 60 days (Oracle 11.2.0.1.0). For this experiment I used 3 different versions of the select-stat...

Toad for Oracle has an autocomplete feature.. you type SELECT * FROM USER. and then press Ctrl+. and a drop down appears where you can choose from the objects available to you. This functionality ...

I want to create some tables in our database from some queries I have developed. I used the code below and it created the table and it works great. The issue I am having is apparently it created ...

If I have a table sch1.tab1 is it possible to call it from schema/user sch2 just with select * from tab1 (assume that we have all the privilegies)? I am aware that in postgresql you can set the s...

Can somebody tell me how to extract my table definitions using SQL? I want to extract the datatypes of all my tables and other information from my Oracle schema. I have about 100 tables. I need th...

I have a query that I'm trying to aggregate data based on hours between two unix timestamps in Oracle. Hardest part is that I get error'd out with "ORA-00936: missing expression" error even I don't...

Executing the following statement in Oracle Toad exec plsql_procedure(select 'somestring' from dual); trhows the following exception: ORA-06550: line 1, column 33: PLS-00103: Encountered the s...

As a web developer, I know how to use the IF ELSE in multiple languages. However, I am learning how to write reports using TOAD for Oracle. My question is, how do I properly add an IF ELSE stateme...

Please i need help. (I SEARCHED A lot and get more confused . ) I use Toad 9.7.25 and i made this procedure (in a package) PROCEDURE ReportaCC(pfcorte IN DATE, lcursor IN OUT SYS_REFCURSOR) IS B...

In the Toad editor, I've got this SQL: SELECT INTERLOPERABCID,AVAILABLEDATE, AVAILABLEQHR,CARPHONEID, TRUNC((AVAILABLEQHR-1)/12) "COL", MOD(AVAILABLEQHR-1,12) "ROW" FROM ABC.INTERLOPERAVAILABILITY...

When I started up my MySQL server today and try to do some changes using Toad for Mysql, I get this message: MySQL Database Error Binary logging not possible. Message: Transaction level 'REA...

I am trying to display the RowID alongside all columns from a Select * statement. I am using Oracle with Toad to run the SQL statement. I have two tables that I need to compare, but I do not have...

I'm confused about Materialized views. Either it is the Toad IDE that I am using that is confusing me, or its that I don't understand MVs enough. I created a materialized view in Oracle by someth...

I am running an SQL (Oracle) statement like that select * from table where table_id in ('265&310', '266&320') While running through TOAD, it consider & as some variable placeholder ...

I have been using Oracle(10g.2) as a PHP programmer for almost 3 years, but when I gave an assignment, I have tried to use the ref cursors and collection types for the first time. And I 've searche...

Does SQLDeveloper have a Toad-like tool to copy/clone an Oracle database user? If not, I'll resort to: How to Clone a User in Oracle

Using Toad 9.7.2 against a network Oracle DB (10g) I can't see any objects in the schema browser using the account information provided to me by my DBA. Using Oracle 10g installed locally, I see al...

Im sure this is pretty simple but I just cant seem to find the option. My Toad MySql install only seems to allow me to have one "Viewer" window open and hence its impossible to view multiple tables...