Saturday, July 23, 2011

I need a sample schema please help!!!!

I need a sample schema for my database with tables, indexes, sequences etc. all queries in it in .txt(.doc,.pdf etc.). Can you help? Thank you.

The easiest way to get a sample schema is to download and install Oracle Express Edition from the Oracle Technology Network. Oracle XE is a small footprint database that is free to use and more importantly comes with a database populated with a sample schema (HR) which contains (almost) a full set of objects with tables, indexes, sequences, procedures, functions, triggers etc.

As for queries, you really have to write your own to learn and it obviously depends on what you what questions you want to ask (about your data), but a few simple queries to start with could be:
SELECT * FROM employees;
SELECT * FROM departments;
SELECT city FROM locations;
SELECT state_province,country_id FROM locations;
SELECT job_title,max_salary FROM jobs;
SELECT first_name||last_name FROM employees;

0 comments:

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Deep's | Bloggerized by Deep - Deep's Templates | ElearSQL-Server