This discussion is archived
2 Replies Latest reply: Apr 8, 2013 9:38 AM by rp0428 RSS

paspersist the case of table and col in sql devloper

947771 Newbie
Currently Being Moderated
when i see my tablename col names in sql devloper it shows in capital letter, how can i show them in Pascale case.

yours sincerly.

Edited by: 944768 on Apr 7, 2013 8:35 AM
  • 1. Re: paspersist the case of table and col in sql devloper
    Marwim Expert
    Currently Being Moderated
    Hello,

    column names are usually not case sensitive and stored in uppercase in the data dictionary.
    You can enforce camelcase when you create a table by putting doublequotes around the column name
    CREATE TABLE "CamelCase" (
    "ColumnName" VARCHAR2(1)
    );
    SELECT * FROM user_tab_cols WHERE table_name LIKE 'C%'
    
    TABLE_NAME  COLUMN_NAME DATA_TYPE 
    ----------  ----------- ---------
    CamelCase   ColumnName  VARCHAR2
    Though usually it is not a good idea to use case sensitive names, because you have to use the doublequotes every time when you reference the table/column.

    Regards
    Marcus
  • 2. Re: paspersist the case of table and col in sql devloper
    rp0428 Guru
    Currently Being Moderated
    >
    when i see my tablename col names in sql devloper it shows in capital letter
    >
    Sql Developer shows the names EXACTLY as they are.
    create table "aBcDe" (col1 number)
    
    aBcDe
    If your table names are displaying in upper case that is because those tables names are ALL UPPER CASE.
    >
    how can i show them in Pascale case.
    >
    You can't - why would you want to display a name that isn't correct?

    If sql developer displayed the sample table name above ("aBcDe") using some other case how would anyone ever know what the table name really is?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points