Search:

realy.its a truth of life

:) good one

your attemption may fail,but never fail to make an attemp

with case its not upadted only 3 row ,updated all the row ,n except then 3 which we update as our wish all other have null if we did't give anythg.So the prob is dis we have to mention updated...

how can it possible.any simple way to make understand me

u should try this
SQL>select to_date(sysdate)+3,to_date(sysdate)-3 from dual;

its a good ans

if u want fetch only new or changed row.it can be possible with search condition,
like
SQL>select * from emp where ename='johns';

For add new col you need alter command
SQL>alter table emp add (email varchar2(30));
For insert the value in this col according condition
SQL>update emp set email='gmail' where name='scott';

Oracle allow cols to be added only at the end of the existing table,bt some database allow cols to be added in middle of cols.for ex. In MYSQL following syntex is valid
[alter table table_name add...