Skip to Main Content
Forums

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!

decode? replace?

611331Jan 24 2008 — edited Jan 25 2008
In the current SQL i have:

select schema_name, created_time,
case when
server_name||'_'||db_name='GBCCCL15/16_CSAHEPA'
then DB_PATCH_NUMBER||'v'||VERSION_NUMBER else null end GBCCCL1516_CSAHEPA,

I have created another column called Application_Version. I currently have the DB_Patch_Number and the version_number displaying. I would like to condition the SQL so if both DB_Patch number and version_number are missing then it displays Application_Version instead!.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2008
Added on Jan 24 2008
13 comments
589 views