Home » SQL & PL/SQL » SQL & PL/SQL » With after cursor name
With after cursor name [message #266723] Tue, 11 September 2007 08:51 Go to next message
priyanka.d
Messages: 20
Registered: May 2007
Junior Member
What does WITH specify along with a cursor name?
Eg.

CURSOR cursor_name
IS
WITH xyz
Re: With after cursor name [message #266726 is a reply to message #266723] Tue, 11 September 2007 08:54 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
It's called a factoring clause. It names part of the query, so it can be reused later in the query (in an efficient way!).
It's not part of the PL/SQL "cursor is" syntax, but SQL
Re: With after cursor name [message #266727 is a reply to message #266723] Tue, 11 September 2007 08:55 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
subquery_factoring_clause

Regards
Michel
Previous Topic: inconsistent datatypes
Next Topic: Aggregate Count From Two Tables
Goto Forum:
  


Current Time: Sun Dec 04 18:35:45 CST 2016

Total time taken to generate the page: 0.07199 seconds