[purnarao80]

select strreplace('This is a beautiful day!', 'beautiful', 'horrible')
from dual

The given query selects the string 'This is a horrible day!'. The string 'beautiful' is replaced by 'horrible'. Write the function strreplace.



There is table itemfile.

ITEMCODE VARCHAR2(7)
ITEMDESC VARCHAR2(6)

Write three queries:

* Select Rows, which have only numbers in ITEMCODE field.

* Select Rows, which have only chars in ITEMCODE field.

* Select Rows, which have only chars & numbers both in ITEMCODE field.