Home » SQL & PL/SQL » SQL & PL/SQL » Queries and tables
Queries and tables [message #185911] Fri, 04 August 2006 04:08 Go to next message
Messages: 39
Registered: August 2006
Hello all,

I need to have some dummy tables (in many) and the required complex queries for that to practice, as that keeps me good in writing the queries. Where can i have that?. If i use default tables like EMP and DEPT i dont get the correct requirements. Please do help me.

Re: Queries and tables [message #186089 is a reply to message #185911] Sat, 05 August 2006 12:53 Go to previous message
Messages: 50
Registered: November 2004
Location: New Delhi

If u r new in Oracle then try with HR schema. Firstly it is a locked user. so u have to do .
login as system
conn system/manager@orcl as sysdba ;
alter user hr identified by hr account unlock;
then login to hr and try the queries with city, department, employees table
Previous Topic: creating batch file along with date
Next Topic: Using %ROWTYPE in a Function with a cursor
Goto Forum:

Current Time: Thu Jul 27 19:48:20 CDT 2017

Total time taken to generate the page: 0.07821 seconds