Home » SQL & PL/SQL » SQL & PL/SQL » Interesting Questions
icon12.gif  Interesting Questions [message #234144] Mon, 30 April 2007 02:56 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hi friends,

I preparing oracle9i interview view.
I ask some questions .Any one send further reply?
Interview questions:
1) what is dynamic cursor? difference between static and
dynamic sursor.
2) what is materialized view? what's use?diff between view and materialized view?

3) what is pl/sql table?
4) what is bulk collect in pl/sql?
5) why use ref cursor in pl/sql ? diff between cursor and
ref cursor?

I expecting answers..

Arun








Re: Interesting Questions [message #234151 is a reply to message #234144] Mon, 30 April 2007 03:59 Go to previous message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

materialized view vs view

static and dynamic cursor

pl/sql tables

bulk collect in pl/sql


refcursor


difference

regards
shanth





Previous Topic: Duplicate Empid
Next Topic: Needed query
Goto Forum:
  


Current Time: Fri Dec 09 06:00:04 CST 2016

Total time taken to generate the page: 0.28574 seconds