Home » SQL & PL/SQL » SQL & PL/SQL » Newbie help,where can i download extra tables (oracle 9i isql *plus)
Newbie help,where can i download extra tables [message #284415] Thu, 29 November 2007 10:48 Go to next message
sqlstar_student
Messages: 42
Registered: November 2007
Member
Iam using oracle 9i isql , by default it has only 4 tables for me to work with iam currently learning joints in sql so i need more tables with good info like dept_id,location ,where can i download extra tables like departments,locations,employees,stuff like that so that i can load and use it in my computer for study purpose.
Re: Newbie help,where can i download extra tables [message #284418 is a reply to message #284415] Thu, 29 November 2007 10:53 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

In oracle 9i...you can sql two sql script they create all tables like employees,departments,locations etc.
located: %ORACLE_HOME%/demo/hr_cre.sql
                            hr_popul.sql
Re: Newbie help,where can i download extra tables [message #284420 is a reply to message #284415] Thu, 29 November 2007 10:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is a demo or samples directory under your Oracle home.

Regards
Michel
Re: Newbie help,where can i download extra tables [message #284556 is a reply to message #284420] Fri, 30 November 2007 01:17 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I've once posted the EMP schema scripts. Here they are: link

MHE
Re: Newbie help,where can i download extra tables [message #284564 is a reply to message #284556] Fri, 30 November 2007 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems that OP already had the 4 scott tables and is not satisfied:
Quote:

by default it has only 4 tables for me to work with iam currently learning joints in sql so i need more tables


Regards
Michel
Re: Newbie help,where can i download extra tables [message #284569 is a reply to message #284564] Fri, 30 November 2007 01:50 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Ok, I missed that. the HR_CRE script can be found through Google.

MHE
Re: Newbie help,where can i download extra tables [message #284816 is a reply to message #284415] Sat, 01 December 2007 08:26 Go to previous message
sqlstar_student
Messages: 42
Registered: November 2007
Member
Thanks for the help
Previous Topic: Unwanted "object owner" in procedure causing ORA-04052 error
Next Topic: triger
Goto Forum:
  


Current Time: Sun Dec 04 06:56:51 CST 2016

Total time taken to generate the page: 0.06202 seconds