SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

displaying query output with constant value

615488Sep 16 2009 — edited Sep 16 2009

Hi,

I am new to oracle i need to have oracle function which displays constant output for particular coulmn.

SQL> select ENO, CITY from prakash;

       ENO CITY
---------- --------------------------------------------------
         2 surat
         2 bangalore
         2 chicago
         2 ittige

i need in city column as ittige for select ENO, CITY from prakash(for all eno it should display ittige)

Thanks

Prakash GR

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2009

Added on Sep 16 2009

3 comments

932 views