Geek Answers Handbook

An example database schema for Oracle

Are there examples of databases for Oracle, such as AdventureWorks for MS SQL? I searched the Oracle site but did not find a trial database.

+6
oracle sample
source share
3 answers

Installing an Oracle database includes scripts for installing sampling schemes. More details

Many online examples use extremely simple EMP and DEPT tables. These tables are not part of the documented schemes listed above. Finding a script for your favorite SCOTT / TIGER scheme is harder than you think. demobld.sql used under the sqlplus subdirectory. Then at 10g (I think) they transferred the schema to $ORACLE_HOME/admin/rdbms/scott.sql . In 11gR2, it again moves to $ORACLE_HOME/admin/rdbms/utlsampl.sql .

+8
source share

This question may be helpful (?).

Good databases with sample data

+5
source share

You can run Oracle Live SQL online without Oracle installed. The menu contains:

  • SQL worksheet
  • My session
  • Scheme. Includes Scott, HR, Order Entry (OE) and others.
  • Fast SQL
  • My scripts
  • Code library

Contains search function, scripts and tutorials.

0
source share

More articles:


All Articles