Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL Table
PL/SQL Table [message #441330] Sat, 30 January 2010 23:03 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi All,

When use PL/SQL tables.I studied about the PL/SQL and i understand it improves the performance.

But how it improves the performance i haven't understand.

Please give me one real time scenario when with example about PL/SQL table.

Please help i am struggling with this.

Thanks in advance.
Ramesh
Re: PL/SQL Table [message #441331 is a reply to message #441330] Sat, 30 January 2010 23:09 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>When use PL/SQL tables.I studied about the PL/SQL and i understand it improves the performance.

Please provide URL that supports this claim.

Improves performance when compared to what; the speed at which glaciers move?
Re: PL/SQL Table [message #441355 is a reply to message #441330] Sun, 31 January 2010 00:25 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database PL/SQL User's Guide and Reference
Chapter 1 Overview of PL/SQL
Section Advantages of PL/SQL
Paragraph Better Performance

Regards
Michel
Re: PL/SQL Table [message #441474 is a reply to message #441330] Mon, 01 February 2010 05:05 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I have to say, I'm quite amused by these two sentences:Quote:

When use PL/SQL tables.I studied about the PL/SQL and i understand it improves the performance.

But how it improves the performance i haven't understand.
Re: PL/SQL Table [message #441702 is a reply to message #441330] Tue, 02 February 2010 16:00 Go to previous messageGo to next message
wakula
Messages: 150
Registered: February 2008
Location: Poland
Senior Member
Is that English or some other language?

PL/SQL can be run on the server thus no data needs to be downloaded from the database to your application for the processing. Then you send only the result of this processing which should be smaller that the whole dataset.
You can read this in the Oracle documentation - read any of the basic introductions into PL/SQL - it should be there.
Re: PL/SQL Table [message #441703 is a reply to message #441702] Tue, 02 February 2010 16:09 Go to previous message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
You can read this in the Oracle documentation - read any of the basic introductions into PL/SQL - it should be there.

Sure, it is in the link I provided.

Regards
Michel
Previous Topic: Passing variable values within a CASE statement
Next Topic: Extracting numbers - Query
Goto Forum:
  


Current Time: Thu Sep 29 14:08:06 CDT 2016

Total time taken to generate the page: 0.15862 seconds