sql /pl sql practice [message #265879] |
Fri, 07 September 2007 13:42  |
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 #265888 is a reply to message #265879] |
Fri, 07 September 2007 13:58   |
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
|
|
|
|
|
|