Technical Blog

Insert into ( select S_DESIGNATION, S_DESCRIPTIONDESG from designation_mast where N_DESGCODE=2) values ( 'tttttttttt','ere...

Difference between Long Transaction (Oracle WorkSpace) and Short Transaction (Normal ) Long Transactions ----------------------- Comp...

SELECT TRUNC( sd + rn ) time_id, TO_CHAR( sd + rn, 'fmDay' ) day_name, TO_CHAR( sd + rn, 'D' ) day_number_in_week, TO_CHA...

To get decimals points and vicevers SELECT REGEXP_REPLACE('18.01', '(\d+)\.(\d+)', '\1') FROM dual; SELECT REGE...

ORA-00932: inconsistent datatypes: expected - got CLOB WHY THIS ERROR OCCURRING ? WHEN WE EXECUTE THIS QUERY IT RESULTS TO AN ERROR (IE :...