Results 1 to 2 of 2

Thread: Oracle column names with space

  1. #1
    Member
    Join Date
    Sep 2012
    Posts
    1,147

    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?

  2. #2
    Senior Member
    Join Date
    Jul 2012
    Posts
    9,482
    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;

Similar Threads

  1. Get table column names in mysql?
    By Oracleguy in forum Oracle
    Replies: 0
    Last Post: 12-15-2012, 10:03 AM
  2. Replies: 0
    Last Post: 12-13-2012, 09:47 PM
  3. Joining column names to column values
    By Oracleguy in forum Oracle
    Replies: 0
    Last Post: 12-11-2012, 09:23 PM

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
  •