Home » Other » General » EMP table
EMP table [message #144340] Wed, 26 October 2005 01:57 Go to next message
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.
Re: EMP table [message #144369 is a reply to message #144340] Wed, 26 October 2005 04:52 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.


Re: EMP table [message #381720 is a reply to message #144340] Mon, 19 January 2009 07:27 Go to previous message
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
Previous Topic: Need oracle 11g data base features (merged)
Next Topic: location of datafile
Goto Forum:
  


Current Time: Fri Mar 29 03:34:58 CDT 2024