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
sumedh7
Messages: 31
Registered: March 2007
Location: Pune,India
Member
Hi,

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

Regards
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: 64151
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.

Regards
Michel


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


Current Time: Fri Dec 09 19:41:45 CST 2016

Total time taken to generate the page: 0.09356 seconds