Posts

Showing posts from December, 2011

Oracle Apps Technical Interview Questions

SQL & PL/SQL : 1) How to Come out from a pl/sql Procedure execution Explicitly based on a condition ? 2) What are The Collection Types in pl/sql ? 3) Tell me the pl/sql table predecates ? 4) Can we declare package body without specification ? 5) How to handle the exceptions that fire while using Bulk Collect ? 6) Name the pl/sql Packages given by oracle other than DBMS_OUTPUT ?     Ans:  dbms_sql ,dbms_utility, dbms_random REPORTS 6i: 1) How we can use the Confine Mode in Reports ? 2) Can we assign multiple templates to a single Report ? 3) Req: My Report need to show the number of records displayed out of all records like             10 Of 1000 Records in each page how to implement ? BI Publisher : 1) How to make the RTF report to display header and footer only in First page ? FORMS 6i: 1) Which trigger first fire when we open the form ? 2) At last which trigger fire when we close the form? 3) Tell me the Sequence of Triggers That fire When we move

Dynamic SQL

Dyanmic SQL: Dynamic SQL is a programming methodology for generating and running SQL statements at run time. It is useful when writing general-purpose and flexible programs like ad hoc query systems, when writing programs that must run database definition language (DDL) statements, or when you do not know at compilation time the full text of a SQL statement or the number or data types of its input and output variables. PL/SQL provides two ways to write dynamic SQL: Native dynamic SQL, a PL/SQL language (that is, native) feature for building  and running dynamic SQL statements DBMS_SQL  package, an API for building, running, and describing dynamic SQL statements Native dynamic SQL code is easier to read and write than equivalent code that uses the  DBMS_SQL  package, and runs noticeably faster (especially when it can be optimized by the compiler). However, to write native dynamic SQL code, you must know at compile time the number and data types of the input and output v