Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

timestamp keyword or reserved keyword

ZpuitJul 5 2012 — edited Jul 6 2012
This is actualy a definition question...

consider a table having a timestamp column named timestamp and the v$reserved_words view in oracle 10.
 
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

CREATE TABLE TF
(timestamp timestamp);
(timestamp is a keyword according to the v$reserved_words_view)
and a procedure to delete data from it
BEGIN
DELETE TF;
END; 
/
produces this output
delete tf;
       *
ERROR at line 2:
ORA-06550: line 2, column 8:
PL/SQL: ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-320: the declaration of the type of this expression is
incomplete or malformed
ORA-06550: line 2, column 1:
PL/SQL: SQL Statement ignored
This fails to compile.... I would think timestamp is a reserved keyword instead of a normal keyword.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 3 2012
Added on Jul 5 2012
9 comments
1,278 views