⟩ What is the difference between Power Center & Power Mart?
PowerCenter - ability to organize repositiries into a data mart domain and share metadata across repositiries.
PowerMart - only local repositiry can be created.
PowerCenter - ability to organize repositiries into a data mart domain and share metadata across repositiries.
PowerMart - only local repositiry can be created.
What is difference between % ROWTYPE and TYPE RECORD?
What will the Output for this Coding> Declare Cursor c1 is select * from emp FORUPDATE; Z c1%rowtype; Begin Open C1; Fetch c1 into Z; Commit; Fetch c1 in to Z; end;
What are the Restrictions on Cursor Variables?
Can we declare a column having number data type and its scale is larger than pricesion ex column_name NUMBER(10,100), column_name NUMBAER(10,-84)
What will happen after commit statement?
Explain the usage of WHERE CURRENT OF clause in cursors?
What is a database trigger? Name some usages of database trigger?
How many types of database triggers can be specified on a table? What are they?
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger? Why?
What are two virtual tables available during database trigger execution?