Home » SQL & PL/SQL » SQL & PL/SQL » Basic scripts for select statement
icon7.gif  Basic scripts for select statement [message #230166] Wed, 11 April 2007 02:15 Go to next message
Messages: 31
Registered: March 2007
Location: Pune,India

Ive just started learning sql for practice i installed oracle my database is ready but there are no data (tables,coulms etc) is there any site from where i get scripts for practice of basic select statement.

thanks in advance

Re: Basic scripts for select statement [message #230169 is a reply to message #230166] Wed, 11 April 2007 02:19 Go to previous message
Michel Cadot
Messages: 65138
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In your ORACLE_HOME/rdbms/admin directory you have a scott.sql file to create the basic SCOTT schema.
You also have demobld.sql in ORACLE_HOME/sqlplus/demo.

And a whole application (referenced everywhere in Oracle documentation) in ORACLE_HOME/demo/schema. Read the readme.txt file and go.


Previous Topic: Need help in writing pl/sql query
Next Topic: can i find nth row for particular table
Goto Forum:

Current Time: Thu Aug 17 16:40:33 CDT 2017

Total time taken to generate the page: 0.16744 seconds