Oracle SQL standard tables information to practice at Home

After installing oracle 9i/10g at your home PC standard oracle tables information will not available to practice as per Oracle standard SQL material.

Eg: after installing try to run this query

select * from employees;

it won't fetch any records because these tables inforamtion not created in home data base.

Solution:

Please follow the below steps to get standard data in your home data base...

1. Download the files attached below and save it in your PC

2. Login to SQL * Plus (login should have DDL and DML privilages to create tables and update)

3. Execute downloaded files in SQL * Plus using below commands

@pathname ( if you placed files in 'C' drive path name will be 'c:\SQL_Practice_TAB.sql')

and press 'Enter'.

4. Verify the tables information whether it got created or not

Note: In below attachment two files will be there execute first 'SQL_Practice_TAB.sql' and after that next one. Do let me know if you have any issues... :)

Files to Download

http://www.4shared.com/file/105876646/633c86d6/SQL_Tables.html