Home » Other » Training & Certification » sql /pl sql practice
sql /pl sql practice [message #265879] Fri, 07 September 2007 13:42 Go to next message
ashish2345
Messages: 50
Registered: September 2007
Member
Dear all ..
I am giving my first exam in SQL and pl sql.using Oracle 9i
My sql exam will cover following topics
1 co related subquery
2. decode
3. index/ view
4. case statement
5.joins between 3/4 tables
6. inner view/ self join
7. sub queries nested

can anyone provide me the questions and table script for practise any number of questions are accepted.
If no script i have emp,dept tables in scott user. can give questions regarding that too
Thanks a lot
.******************
my pl/sql exam will cover follwing topics
1. package creatiion with validations like insert only when the combination not prsent etc etc dept in unique..

its major weightage question
2. next is trigger
3. nested table/ varray
any no of of questions are welcome
waiting for reply

warm regards
Ashish

[mod-edit] removed illiterate IM speak and all calls for urgency.

[Updated on: Fri, 07 September 2007 13:49] by Moderator

Report message to a moderator

Re: sql /pl sql practice [message #265884 is a reply to message #265879] Fri, 07 September 2007 13:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PLease post in the appropriate forum: "Homework, Training & Certification" this is the third topic you create today and all are moved to this forum, so do it yourself.

Read PL/SQL User's Guide and Reference and SQL Reference

Regards
Michel

[Updated on: Fri, 07 September 2007 13:48]

Report message to a moderator

Re: sql /pl sql practice [message #265888 is a reply to message #265879] Fri, 07 September 2007 13:58 Go to previous messageGo to next message
ashish2345
Messages: 50
Registered: September 2007
Member
dear sir,

I am new in this field.I am trying to learn and referring the manuals but need some tables and questions for practise.
sorry for posting at wrong place.PLZ ignore citing me as a new member
thanks

other users plz help
regards
Ashish
Re: sql /pl sql practice [message #265893 is a reply to message #265888] Fri, 07 September 2007 14:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ok, now read and follow OraFAQ Forum Guide, especially section talking about IM speak.

Standard demo tables are all what you need to learn and there are many examples using them in the manuals. (see in your ORACLE_HOME/demo/schema directory)

Regards
Michel
Re: sql /pl sql practice [message #265922 is a reply to message #265879] Fri, 07 September 2007 21:50 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Learn about Sample Schema Read
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96539/toc.htm
Re: sql /pl sql practice [message #265991 is a reply to message #265922] Sat, 08 September 2007 09:36 Go to previous message
ashish2345
Messages: 50
Registered: September 2007
Member
muzahidul islam wrote on Fri, 07 September 2007 21:50
Learn about Sample Schema Read
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96539/toc.htm


thanks alot
regards
ashish
Previous Topic: what is better for me oracle 9i or 10g
Next Topic: how to allow full access/control to a Oracle user?
Goto Forum:
  


Current Time: Fri Dec 09 19:51:25 CST 2016

Total time taken to generate the page: 0.17686 seconds