Home » SQL & PL/SQL » SQL & PL/SQL » training or student database?
training or student database? [message #239] Thu, 31 January 2002 10:54 Go to next message
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 Go to previous message
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....
Previous Topic: Using Hints in View Definitions - Not woking
Next Topic: How do I convert the difference between two dates into a date format
Goto Forum:
  


Current Time: Thu Jul 02 11:45:56 CDT 2020