Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

RESULT:  Oracle produces the relevant required data, Here, we have added the clause as "where" and followed with column-name to be referred 1 checked in the table, " " sign has been used for comparison 1 evaluation,

11.06   How do we make conditional display with partial given data?

11.07      How to use "% "symbol

11.08      How to use equal (=)

operator in condition?

We had a vague memory that portion of the data can be given for comparison 1 evaluation; the left data portion may be replaced by "% "symbol,

SYNTAX:  Select * from raak-ledger-master  where

ledger_name 'cash%';

RESULT: no data found

It is surprised that we have data but it does not return the value. We just made one mistake. Our column_name ledge_name is varchar2 and we have to use 'LIKE' operator instead of "= "symbol.