Can we create trigger on view in oracle?
Answer / kamala k n
yes , we can create triggers on views like instead of triggers
Is This Answer Correct ? | 0 Yes | 0 No |
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
what is the difference between oracle enterprise edition and oracle express edition?
What is set verify off in oracle?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
How to install oracle odbc drivers?
How to unlock the sample user account in oracle?
how to join query for one source type is oracle another source type is sql server ?
What is tns service name?
How to pass a parameter to a cursor in oracle?
How many types of cluster table in Oracle?
What is ADDM Advisor in Oracle?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit