Its a very good attemp. I hav also got the solution but longer in the lines. But after having a look on your script, its really impressive.
Type: Posts; User: satya_vinayan; Keyword(s):
Its a very good attemp. I hav also got the solution but longer in the lines. But after having a look on your script, its really impressive.
The Best example you can see while running a procedure, when oracle stops after giving u the message "ORA-12170: TNS:Connect timeout occurred".
That procedure should contain the
Exception
...
I think this could be the short and simple answer :
select * from emp where trunc(dob)=trunc(sysdate)
In any case u will have to perform the full refresh for reflecting those record. Moreover you can use the fast refresh.;
Re: materialized view
DBMS_MVIEW is the package which is used to refresh the materilized view.
e.g
Excecute DBMS_MVIEW.refresh(MVIEW_name, Type of refresh)
also,
Hi Krishna,
Probably you will have to commit the transaction (the Insert statement) for the table Pay_test and then try to delete from the same. This normally happens when a procedure is...