CASE inside a Oracle Store procedure (SP)

ORACLE is a Object Relational Database Language and vastly using in large amount of data handling companies.
This shows how to add a CASE funcation at a ORACLE Store Procedure.

This is how to write a CASE in a oracle store procedure ...

CASE TRIM(TableName.ColumnName) WHEN ''1'' THEN ''Yes'' ELSE ''No'' END as MyParameterName

Comments

Popular Posts