I am new to Oracle. I want to practice more sql query and pl/sql program. I want sample database like northwind, inventory database so that I can practice on that database. Also with list of exercise from this database to practice. In short, i want particlular database with numbers of exercise to solve particular query. Please give me link. thanks in advance
Reported for forum change/homework/spam.
Want lots of practice? Design and build your own Oracle database, from scratch, to be a more-or-less clone of Northwind, then import Northwind into that. You could do just some important pieces of it for starters.
You’re suggesting he code his own RDBMS just to practice some SQL? Man, you are tough on the IT newbs. 
You don’t expect them to learn both Oracle and the internet at the same time, do you?
Or dump the northwind as a script and edit it to load into Oracle.
But Oracle does have their own equiv of Northwind , a demo schema used in the material…
and
http://docs.oracle.com/cd/B28359_01/server.111/b28328/scripts.htm#Cihijfgh
The desktop version of Oracle (free) came with several sample tables, as I recall. The interface to edit the data isn’t the best - it’s been a while since I worked with it - but it’s something especially if you don’t have access to a server-based version.
Lots of Oracle textbooks have sample databases available to download - the DDL that is.
Failing that, come up with some simple tool that makes sense in your life. Say, a household inventory: you need a table for things, a table for rooms they belong in, a table for people who own them, a table for addresses of houses, and so on. Make up a household, and play around with producing reports.
??? Uh, what? Northwind is a well-known (in some circles, anyway) sample database, not a RDMBS. He could study the structure and design of that database, and then write his own SQL code to build and populate something similar, then write more of his own SQL to do reports and updates or whatever.
New to Oracle? You Know SQL already? RDBS theory?
Just curious. You want to practice PL/SQL? I don’t think anyone ever wrote any PL/SQL for fun, if you want to learn enough to get paid for it I suggest getting yourself on a proper course. If you just want to learn SQL use something much more light-weight (and free) like MySql.
S. Clanger. Recovering Oracle programmer.
Isn’t Northwind the sample database in Microsoft Access? Does Oracle use the same fictional company name, or is the same sample database also used by Oracle?
That poster was stating that the OP could take MS’s Northwind DB and re-create it in Oracle via SQL stmts.
Debaser
Cool.