On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Wednesday, October 22, 2008

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;

No comments:

Post a Comment