| Queries and tables [message #185911] |
Fri, 04 August 2006 04:08  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
