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: 7901
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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
subquery_factoring_clause

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


Current Time: Sat Feb 15 13:26:46 CST 2025