Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    25

    Unanswered: Double words in the table name

    In SQL Server, when you have a table name which have two or more words, you need to use double quota in the SQL statement:
    Select * from "table 123"

    is it same in Oracle? or Oracle don't permit have two or more words in the table name or field name?

  2. #2
    Join Date
    Oct 2002
    Location
    Plymouth UK
    Posts
    116
    Separate doubles names with an underscore not a space.

    Enclosing table and column names within double quotes makes them case specific, with implications for your users and devolopers.

  3. #3
    Join Date
    Jan 2003
    Location
    Dordrecht, The Netherlands
    Posts
    95

    Re: Double words in the table name

    It's the same in Oracle.

Posting Permissions

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