Home > SQL, Technical > simple but weird SQL i came across today

simple but weird SQL i came across today

August 1, 2012

I really feel shame that i didnt know the answer for this simple sql.

1.select to_char(add_months(trunc(to_date(’10-05-10′,’RR-MM-DD’),’YY’),-1),’Q’) from dual;

2.update (select * from orders_karu) set order_date=sysdatewhere order_id=1

Advertisements
Categories: SQL, Technical
%d bloggers like this: