Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    29

    Unanswered: check if columns in my database are named with oracle reserved keywords

    Pls ii need a query on how to check if any column(s) in my database tables are named using an oracle reserved keyword.
    also what are the implications and how do i resolve it.
    reply ASAP
    thanks
    'soga

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4

  3. #3
    Join Date
    Nov 2007
    Posts
    29

    Question reserved

    yes i have looked up the reserved key words.
    what i really want is to check my own tables and columns to see if i have any named with a reserved keyword so i can change them. my database is large with many tables and coulmns. isn't there a query that can solve this?
    thanks a lot
    Rgds

  4. #4
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Try this
    Code:
    select c.table_name, c.column_name
    from all_tab_columns c, v$reserved_words r
    where c.column_name = r.keyword
    and r.reserved = 'Y'
    although I don't know how complete the list of reserved words in that view is.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •