Pages

Friday 2 May 2014

HOW TO CREATE DEMO TABLES IN ORACLE OR HOW TO CREATE TABLES THAT ARE PRESENTED IN SATHISH YELLANKI SIR SYSTEM

How to create demo tables.
actually its a script that is save as .sql extension just use the @(special character for running script from specific location in your system using sqlplus).

First what you need is the demo script.
Download it from this below link........

demobld.sql

after downloading save it in your drive.
ok now we will execute this script using oracle.
first copy this script in a folder and always care the folder name or path name don't have any space otherwise oracle will not read your script from your specific location.
now open sqlplus or on cmd prompt type sqlplus
give username and password
now write like this
SQL >@path_of_file_with_name
for example
SQL >@D:\oracle\sql\demobld.sql and hit Enter key
if every thing goes well your database is ready with these tables.

SQL> SELECT Tname FROM TAB;

TNAME
----------------
DUMMY
DEPT
EMP
BONUS
SALGRADE
CUSTOMER
ORD
ITEM
PRODUCT
PRICE

3 comments: