Answer Posted / akn
Triggers are basically used to implement business rules.
Triggers are also similar to stored procedures.The
difference is that it can be activated when data is added
or edited or deleted from a table in a database.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what are archived logs?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What types of joins are used in writing subqueries?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is sequence?
what is a Nested Loop join?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to define a data source name (dsn) in odbc manager?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is execute immediate in oracle?
What is the difference between sharding and partitioning?
What is the difference between post-database commit and post-form commit?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to select some rows from a table in oracle?