What will happen to an anonymus block,if there is no statement inside the block?eg:-declarebeginend;
Latest Answer: cursor is basically a pointer as it's like a address of virtual memory which is being used storage related to sql query & is made free after the values from this memory is being used. ...
What happens when commit is given in executable section and an error occurs ?please tell me what happens if exception block is committed at the last?
Latest Answer: You can avoid mutating trigger by using autonomous transaction. ...
Latest Answer: Set Timing onSelect * from Emp;You will get the time displayed. ...
Latest Answer: Owner of a table is the schema name which holds the table. To change the owner just recreate the table in the new schema and drop the previous table ...
Latest Answer: Materialized views are schema objects that can be used to summarize, precompute, replicate, and distribute data. E.g. to construct a data warehouse. ...
Latest Answer: Autonomous transactions are independent transactions that can be called from within another transaction. An autonomous transaction lets you leave the context of the calling transaction, perform some SQL operations, commit or undo those operations, and ...
Latest Answer: haiwhy equality condition does'nt work with rownum, i'm giving my explanation herethe query select * from emp where rownum=25;it fetches first record makes it rownum 1 as it does'nt match the where criteria, the record discardedit fetches 2nd record makes ...
Latest Answer: Can u please give more explanation on this NOCOPY parameter ...
View page << Previous 6 7 8 9 [10] 11 12 13 14 15 Next >>

Go Top