11.09 How to use like operator
SYNTAX: Select * from raak-ledger-master where
ledger_name like 'cash%';
RESULT:
RECORD-ID LEDIGER-CODE LEDGER-NAME REPORT-TYPE
1 BS-0001-00 CASH ACCOUNT BS
Hence we shall understand "LIKE" is another string
comparison operator as equal sign exists,
A function in oracle behaves and produces many results in a way pre-written codes accepting few parameters and producing one return values, Every function has got sets of parenthesis where in user pass the parameters 1 options required, The functions which are handling string, character type of data, produces two types of the results, String Function may change the original text information 1 data, or tells about the properties of the data, Some functions will convert all the text characters in terms of upper case letters and some functions may produce length of the data, different form of presentation etc, etc,