Usually if a large amount of data entry/updation/deletion is to be done, the index is dropped and re-created after the data entry/updation/deletion is finished, Why?
Latest Answer: Hi taraldesai! Y Not?Here is the example Try thisALTER TABLE table_nameADD (column datatype DEFAULT expr);(or)ALTER TABEL table_nameMODIFY (column datatype DEFAULT expr) ...
What is the difference between the three User Defined Functions - Scalar functions, Inline table-valued functions, Multistatement table-valued functions
Latest Answer: You write a trigger on some table and in that trigger code if you access the same table, then it generate this error. To avoide, use views or call procedure from trigger.. bcoz your table is in between modification mode (mutating mode) and you are accessing ...
Latest Answer: used to avoide parsing three mode shared, exclusive and similarcursor_sharing=need to set this parameter on session or system level. this can also affect bind picking ...
Is there any limit on like this number of parameters should be passed into a function? Or can we pass any number of arguments into a function?
Latest Answer: Hi shravanam,Wht is this u r wrong?Non-Euqijoin : Join more than one table with other than equlity operator (i.e. BETWEEN ... AND....) ...
means i have 150 tables in one system, i want to copy those tables into another system.
Latest Answer: using import/export ...
How to insert more then one record from one table to another table in oracle,in some specific colums
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
