| empty field in oracle [message #113909] |
Sat, 03 May 2003 19:31  |
ibbrahim
Messages: 3
Registered: February 2003
|
Junior Member |
|
|
i need a empty colomn in oracle
In sql i know i can use SELECT '' ) AS Advocate_Name1, but in oracle it giving from keyword is missing help me
thanx
ibbrahim
|
|
|
|
| Re: empty field in oracle [message #113921 is a reply to message #113909] |
Wed, 11 June 2003 11:08  |
Jim Gillespie
Messages: 23
Registered: January 2001
|
Junior Member |
|
|
: i need a empty colomn in oracle
: In sql i know i can use SELECT '' ) AS Advocate_Name1, but in oracle it giving from keyword is missing help me
: thanx
: ibbrahim
Ibbrahim,
Oracle always requires a from clause with a select. However, Oracle has a one row table called sys.dual.
You could write a select like this.
SELECT ' ' FROM DUAL; This will return on row of an empty column.
Jim Gillespie
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
