Reserved Words

[A] All Alter And Any As Asc [B] Between By [C] Char Check Cluster Compress Connect Create

[D] Date Decimal Default Delete Desc Distinct Drop [E] Else Exclusive Exists [F] Float For From

[G] Grant Group [H] Having [I] Identified In Index Insert Integer Intersect Into Is

[L] Like Lock Long [M] Minus Mode [N] Nocompress Not Nowait Null Number

[O] Of On Option Or Order [P] Pctfree Prior Public [R] Raw Rename Resource Revoke

[S] Select Set Share Size Smallint Start Synonym [T] Table Then To Trigger

[U] Union Unique Update [V] Values Varchar Varchar2 View [W] Where With

This is a list of all the reserved words in v$Reserved_Words. The above report was generated as one long list. I took it into a word processor to put it in columns.

To get a heading like '[A]':

• Use a 'Prompt' for your title
• Use TTitle for your subtitle.
• Substring to get the first character.
• Break on that first character and skip a page
• Use the variable created with the New_Value in the title, but do not put in the ampersand.

Break On Char1 Skip Page
Prompt Reserved Words
Ttitle Left '[' TitleChar ']'
Set Heading Off
Column Char1 New_Value TitleChar

Select Substr(Keyword,1,1) Char1,
      Initcap(Keyword)
 From V$Reserved_Words
 Where Reserved = 'Y'
   And Substr(Keyword,1,1) Between 'A' And 'Z'
 Order By Char1, Keyword;