column name length Alias [message #276760] |
Fri, 26 October 2007 05:12 |
srinivas.k2005
Messages: 404 Registered: August 2006
|
Senior Member |
|
|
Hi,
I have a requirement where i should give a column name more than 30 characters.
Example:
SQL> select cust_code from ar_cust where rownum<=1;
CUST_CODE
----------
03004009
SQL> select cust_code abcdefghijklmnopqrstuvwxyz1234 from ar_cust where rownum<=1;
ABCDEFGHIJ
----------
03004009
SQL> select cust_code abcdefghijklmnopqrstuvwxyz12345 from ar_cust where rownum<=1;
select cust_code abcdefghijklmnopqrstuvwxyz12345 from ar_cust where rownum<=1
*
ERROR at line 1:
ORA-00972: identifier is too long
SQL> select cust_code as abcdefghijklmnopqrstuvwxyz12345 from ar_cust where rownum<=1;
select cust_code as abcdefghijklmnopqrstuvwxyz12345 from ar_cust where rownum<=1
*
ERROR at line 1:
ORA-00972: identifier is too long
is there any way i can do this.
please guide me.
[Updated on: Fri, 26 October 2007 06:22] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: column name length Alias [message #276842 is a reply to message #276788] |
Fri, 26 October 2007 07:46 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Maaher | What is it with people these days? This is thread N from someone who just won't listen.
|
Well, there's that ignore all messages by this user link. Perhaps they ("someone") pressed it frequently in the past, but they've chosen wrong people to ignore. Now they see only a few posts, written by other users (who are still not on their ignore list), but that confuses the rest of you.
Or is this just another conspiracy theory? "No message body"? Who deleted my body? OraFAQ did!
[Updated on: Fri, 26 October 2007 07:48] Report message to a moderator
|
|
|