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

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

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.