| training or student database? [message #239] |
Thu, 31 January 2002 10:54  |
Derek
Messages: 3
Registered: November 2000
|
Junior Member |
|
|
Does anyone know a script or something I could use to create and populate a database with some data like you use in the oracle certification classes? You know tables like Empno, Emp, Salary, etc, with actual data in them. This would be very helpful to use when going through books, etc on SQL and PL/SQL.
Thanks!
Derek
|
|
|
|
| Re: training or student database? [message #240 is a reply to message #239] |
Thu, 31 January 2002 11:52  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi
The Scott/tiger schema will be created automatically with the default database while oracle installation.
so from sqlplus
try to log in as scott/tiger and see those tables
SQL> connect scott/tiger@db1
if you don't have scott schema
or you want to create those demo tables(emp, dept)in your existing schema...
then you can run
ORACLE_HOMESQLPLUSDEMOdemobld.sql
which will create those tables....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
