Home » Infrastructure » Other Operating Systems » empty field in oracle
empty field in oracle [message #113909] Sat, 03 May 2003 19:31 Go to next message
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 Go to previous message
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
Previous Topic: Oracle 9.2.0.2 CICS Compile JCL
Next Topic: Do use persistent connections or new connections to Oracle for DB calls
Goto Forum:
  


Current Time: Fri Mar 29 10:08:32 CDT 2024