-
I have begun training for 8i OCP certification but I lack any real world professional experience. To attempt to partially counteract this I want to play around with some test databases to apply my new learnings. Anyone have any links for downloading/purchasing simple databases? Or would it be better to create my own?
Thanks in advance
L-Carvone
-
There is a demo schema that comes with oracle. Check out your $ORACLE_HOME/sqlplus/demo/demobld.sql script...
Jeff Hunter
-
Thanks Jeff...I have identified that schema as a start but am curious if multiple schema of different types (i.e financial, HR, manufacturing) would give me a more rounded understanding of the capabilities as well as make me more rounded as far as job possibilities down the road??.....
All thoughts appreciated
L-Carvone
-
Try to get oracle 9i. With 9i, there are a couple of sample schemas. One example from HR schema:
SQL> select table_name from user_tables;
TABLE_NAME
------------------------------
COUNTRIES
DEPARTMENTS
EMPLOYEES
JOBS
JOB_HISTORY
LOCATIONS
REGIONS
7 rows selected.
Each table has more than 100 rows. It is good for studying database desgine too.
-
I have found the demobld.sql and the demodrop.sql scripts for my 9i for win98... how do i run these? thanks for any help, kyle
-
hi
You can run it easily from sql plus.with @demo.sql
regards
Hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|