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
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..


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


materialized view vs view

static and dynamic cursor

pl/sql tables

bulk collect in pl/sql




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

Current Time: Wed Oct 26 02:52:36 CDT 2016

Total time taken to generate the page: 0.06546 seconds