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
yashora
Messages: 39
Registered: August 2006
Member
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.

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

Hello,
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 Dec 08 18:29:59 CST 2016

Total time taken to generate the page: 0.18210 seconds