1. Programming Oracle: PL/SQL is the language used for programming SQL Server: T-SQL is the language used for programming 2. ROWID Oracle: ROWID NumID AAAJWTAAWAAB+BiAAA 10 AAAJWTAAWAAB+BiAAB 20 SQL Server: Output %%physloc%% File:Page:Slot NUM 0x2926020001000000 (1:108786:0) 10 0x2926020001000100 (1:108786:1) 20 3. Dual Oracle: Dual Table is made available by default. SQL Server: Dual table canContinue reading “Comparison of Oracle & SQL Server”
Category Archives: PL/SQL Programming
Triggers
Q1. Explain two virtual tables available at the time of database trigger execution. Answer. :OLD and :NEW are the 2 virtual tables available at the time of database trigger execution. The table columns are referred as :OLD.column_name and :NEW.column_name. Trigger Event Availability of values in :NEW.column_name :OLD.column_name Insert Available Not Available Update Available Available DeleteContinue reading “Triggers”
Functions, Procedures & Packages
Q1. What are the various types of parameter modes in a procedure / function? Answer. IN, OUT AND INOUT. Q2. What is a transaction? Answer. A transaction is a set of SQL statements between any two COMMIT and ROLLBACK statements. Q3. What is Sysdate? A function or A pseudo column or A system defined variable?Continue reading “Functions, Procedures & Packages”
TechOraFAQ 