Home » SQL & PL/SQL » SQL & PL/SQL » how to get the sample table? (ora10g)
how to get the sample table? [message #333509] Sat, 12 July 2008 00:27 Go to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member


Hi
I have 10g, i want to sample table like employee,customer etc., which available in Scott/tiger.

What should i want to run.

kanish
Re: how to get the sample table? [message #333511 is a reply to message #333509] Sat, 12 July 2008 00:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated above


>I have 10g, i want to sample table like employee,customer etc., which available in Scott/tiger.
>What should i want to run.

How would an independent observer know the correct answer?
Re: how to get the sample table? [message #333513 is a reply to message #333509] Sat, 12 July 2008 00:34 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

I feel which are all sample table and provided by oracle.

That i need in my user.


kanish
Re: how to get the sample table? [message #333514 is a reply to message #333513] Sat, 12 July 2008 00:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
mm_kanish05 wrote on Fri, 11 July 2008 22:34
I feel which are all sample table and provided by oracle.

That i need in my user.


kanish

Congratulations. Do so.
Re: how to get the sample table? [message #333516 is a reply to message #333509] Sat, 12 July 2008 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Creation script is $ORACLE_HOME/rdbms/admin/scott.sql or $ORACLE_HOME/sqlplus/demo/demobld.sql

Others in Database Sample Schemas

Regards
Michel
Re: how to get the sample table? [message #333522 is a reply to message #333509] Sat, 12 July 2008 03:11 Go to previous message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Thank Michal Nice help

Inform Mr.anacedent

kanish
Previous Topic: Decrypt PDF file
Next Topic: Decode Function Help
Goto Forum:
  


Current Time: Sun Nov 10 05:28:46 CST 2024