OraFAQ Forum: General

Home » Other » General » EMP table

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

EMP table [message #144340]

Wed, 26 October 2005 01:57

kiran
Messages: 503
Registered: July 2000

Senior Member

All:

Can some body post the data that we have in EMP , DEPT (in Scott/Tiger) tables.

--Kiran.

Report message to a moderator

Re: EMP table [message #144369 is a reply to message #144340]

Wed, 26 October 2005 04:52

Maaher
Messages: 7065
Registered: December 2001

Senior Member

See the creation (demobld.sql) and removal (demodrop.sql) scripts in attach.

They include:

Tables: emp, dept, bonus, salgrade and dummy
Data for the given tables

MHE

[edit]demobld.sql is apparently copyrighted, but you can take it off the Oracle website: link.

[Updated on: Mon, 17 December 2007 05:36]

Report message to a moderator

Re: EMP table [message #144382 is a reply to message #144369]

Wed, 26 October 2005 05:38

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Just to add,

Run scott.sql script, you can find it at $ORACLE_HOME/rdbms/admin on your machine.

[Updated on: Wed, 26 October 2005 05:38]

Report message to a moderator

Re: EMP table [message #144389 is a reply to message #144340]

Wed, 26 October 2005 06:05

kiran
Messages: 503
Registered: July 2000

Senior Member

@Tarun : I have got Oracle 9i,But as you said i do not have scott.sql in "C:\oracle\ora92\rdbms\admin" path.

But any how using the scripts i could able to create.

Thanks Maheer.

--Kiran.

Report message to a moderator

Re: EMP table [message #381720 is a reply to message #144340]

Mon, 19 January 2009 07:27

parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune

Senior Member

Thanks a lot for the information. It is useful to me as well.
I would like to add something to this.

Table creation script for employees, departments table is hr_cre.sql: creates table
hr_popul.sql contains data for these tables.

Regards,
Parag

Report message to a moderator

Previous Topic:	Need oracle 11g data base features (merged)
Next Topic:	location of datafile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 05:49:26 CST 2024