OraFAQ Forum: SQL & PL/SQL » how to get the sample table?

Home » SQL & PL/SQL » SQL & PL/SQL » how to get the sample table? (ora10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to get the sample table? [message #333509]

Sat, 12 July 2008 00:27

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

Report message to a moderator

Re: how to get the sample table? [message #333511 is a reply to message #333509]

Sat, 12 July 2008 00:31

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?

Report message to a moderator

Re: how to get the sample table? [message #333513 is a reply to message #333509]

Sat, 12 July 2008 00:34

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

Report message to a moderator

Re: how to get the sample table? [message #333514 is a reply to message #333513]

Sat, 12 July 2008 00:37

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.

Report message to a moderator

Re: how to get the sample table? [message #333516 is a reply to message #333509]

Sat, 12 July 2008 01:04

Michel Cadot
Messages: 68770
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

Report message to a moderator

Re: how to get the sample table? [message #333522 is a reply to message #333509]

Sat, 12 July 2008 03:11

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Thank Michal Nice help

Inform Mr.anacedent

kanish

Report message to a moderator

Previous Topic:	Decrypt PDF file
Next Topic:	Decode Function Help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 17 21:50:40 CST 2025