-
-
Is it possible that we can make a query to search the data
Umair Tariq">Hello,I need some info, that is it possible to find or make query ,that if we know the data stored in a table but don't know the field name in which the required data is stored.ExampleTable having fields like columnA, columnB, columnC, columnD,..........columnN and all have the same dataType. and you dont know in which field your data exists.suppose some data like e.g. "BackMan" exists in any Field of the table but we don't know in which Field this information is store.Is it possible that we can make a query to search the dataUmair Tariq
-
-
row level,statement level,before,after,insert,update,delete 3*2*2 total 12 types.
and can i even mention instead of triggers,database trigger and schema triggers">If anyone asks in interviews, about "what are the types of triggers" then my ans is likerow level,statement level,before,after,insert,update,delete 3*2*2 total 12 types.and can i even mention instead of triggers,database trigger and schema triggers
-
-
Dear friend, my question is assume that we have created on table,on that table we are creating one view and one synonym know i have drop the table then status of view is invalid but status of synonym is not invalid pls give me the answer
gangadharam.p
- Jan 6th, 2007
hi, when u do so the view gets error and synonym becomes invalid. If u create a table again with same name but with different cols the synonym will work but view wont.bcz view is the stored...
raghgu
- Nov 16th, 2006
Hi friend, As per RDBMS rule we cannot have invalid synoym, but we can have a invalid view.
-
How to handle exception in Bulk collector?
mariashylaja
- Aug 12th, 2006
During bulk collect you can save the exception and then you can process the exception.Look at the below given example:DECLARE TYPE NumList IS TABLE OF NUMBER; num_tab NumList := NumList(10,0,11,1...
mariashylaja
- Aug 12th, 2006
DECLARE TYPE NumList IS TABLE OF NUMBER; num_tab NumList := NumList(10,0,11,12,30,0,20,199,2,0,9,1); errors NUMBER;BEGIN FORALL i IN num_tab.FIRST..num_tab.LAST SAVE EXCEPTIONS DELETE *...
PL/SQL Interview Questions
Ans