Latest Answer: LOB datatypes can be used to store blocks of unstructured data like graphic images, video, audio, etc ...
Latest Answer: Historically database columns which hold alphanumeric data have been defined using the number of bytes they store. This approach was fine as the number of bytes equated to the number of characters when using single-byte character sets. With the increasing ...
What are the Limitations of Packages,views,procedures?What is the maximum number of subprograms inside a package?
Latest Answer: Order of triggre firing :::::::Before Statement levelBefore Row levelAfter Row levelAfter Statement level ...
Can we have same trigger with different names for a table?eg: create trigger trig1after insert on tab1;andeg: create trigger trig2after insert on tab1;If yes,which trigger executes first.
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: First execute "Set Timing on" Cammand on SQL Prompt and after that SQL> SET TIMING ON Execute the SQL Cammand on SQL PromptSelect * from Emp; You will get the time displayed. Like This-SQL> SELECT * FROM EMP; ...
View page << Previous 6 7 8 9 [10] 11 12 13 14 15 Next >>
Go Top
