Results 1 to 2 of 2

Thread: Oracle column names with space

  1. 12-10-2012, 08:41 AM #1
    Oracleguy
    Oracleguy is offline
    Member
    Join Date
    Sep 2012
    Posts
    90

    Lightbulb Oracle column names with space

    Can we create column names containing spaces in oracle table? Is it possible? If so how can we create?
    Reply With Quote Reply With Quote
  2. 12-10-2012, 10:32 AM #2
    yoursswathi
    yoursswathi is offline
    Member
    Join Date
    Jul 2012
    Posts
    46
    Yes, you an create columns which contains space. Just include those column names in double quotes.

    Example which shows querying:

    Code:
    select employee_id, "first name" from employees;
    Reply With Quote Reply With Quote
« Difference between Varchar(n char) and Varchar(n byte) | Problem using SQL case statement - oracle »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules