Amazon

11 Apr 2013

How to apply for OCP card after exams?



How to apply for OCP card after exam?

Before taking the OCP  exams you  have to get registered with Oracle Corp. once registered and given all the exams successfully then within 2-3 months you will received the OCP certification + OCP card by courier at provided address during registration.
If then also you didn’t received the OCP certificate and card then contact to the authorized center from where you have taken the exams.

Rest the information one can get from https://blogs.oracle.com/certification/entry/0478

10 Apr 2013

EXECUTE IMMEDIATE and DBMS_SQL



DYNAMIC SQL 

Dynamic SQL is a SQL statement that contains variables that can change during runtime.Is written using either DBMS_SQL or native dynamic SQL (Execute Immediate).

EXECUTE IMMEDIATE: The Execute Immediate statement can perform dynamic single-row queries. Also, this is used for functionality such as objects and collections, which are not supported by DBMS_SQL. If the statement is a multi-row SELECT statement you use OPEN-FOR, FETCH and CLOSE statements.

DBMS_SQL: The DBMS_SQL is used to perform dynamically multi-row query. DBMS_SQL package is used to write dynamic SQL in stored procedures and to parse DDL statements. Some of the procedures and functions of the package include:
1)      OPEN_CURSOR: Opens a new cursor and assigns a cursor ID number.
2)      PARSE: Every SQL statement must be parsed. Parsing the statement includes checking the statements syntax and validating the statement , ensuring that all references to objects are correct and ensuring that the relevant privileges to those objects exist.
3)      BIND_VARIABLES: Binds the given value to the variable identified by its name in the parsed statement in the given cursor.
4)      EXECUTE: Executes the SQL statement and returns the number of row processed.
5)      FETCH_ROWS: Retrieves a row for the specified cursor (for multiple rows, call in a loop)
6)      CLOSE_CURSOR: Closes the specified cursor.
 
­­You can use the INTO clause for a single-row query, but you must use OPEN-FOR, FETCH and CLOSE for a multi row query.

Dynamic SQL supports all the SQL data types but does not supports PL/SQL specific types except PL/SQL record.

DBMS_JOB: Enables the scheduling and execution of PL/SQL programs.

1 Apr 2013

System Variables

System Variables:
System variables are oracle form variables that is used to control the way an application behaves.

List of system Variables:

1)      System.Form_Status
2)      System.Block_Status
3)      System.Record_Status
4)      System.Coordination_Operation
5)      System.Master_Block
6)      System.Current_Block
7)      System.Current_Form
8)      System.Current_Item
9)      System.Current_Value
10)  System.Cursor_Block
11)  System.Cursor_Record
12)  System.Cursor_Item
13)  System.Cursor_Value
14)  System.Last_Form
15)  System.Last_Record
16)  System.Last_Query
17)  System.Message_Level
18)  System.Suppress_Working
19)  System.Mode

Synchronize Built-in

SYNCHRONIZE built-in:
SYNCHRONIZE built-in is used to synchronize the Terminal Screen with the internal state of the form.
SYNCHRONIZE update the screen display to reflect the information that Form Bulder has its internal representation of the screen.
Example:
                        BEGIN
FOR J IN 1..1000 LOOP
:Control.Id:=J;
SYNCHRONIZE;
Process_Element(J);
END LOOP;
END;

29 Mar 2013

Open_Form, Call_Form and New_Form

Multiple Forms can be invoked in an application through three built-in:

1)      OPEN_FORM
2)      CALL_FORM
3)      NEW_FORM

OPEN_FORM:

OPEN_FORM opens another form in a modeless window. The user can work on Multiple forms concurrently. The user can navigate within multiple forms.
With the OPEN_FORM the user can call another form in a different database session.
Syntax: OPEN_FORM (‘form_name’, active_mode, session_mode, data_mode, paramlist);   Default:   activate and no session mode.
OPEN_FORM is a restricted procedure and cannot be called in the Enter-Query mode.


CALL_FORM:

CALL_FORM calls another form in a Modal window. The user cannot navigate within different Forms. Requires to exit the called form before navigating back to the calling form. Forms are called in the same session.

NEW_FORM:

NEW_FORM exits the current form and opens the new form as a parent window.
NEW_FORM releases the memory by exiting the current form.

Benefits of Multiple form Applications are:

Easier to debug small form.
Flexibility between forms.
Easy to maintain.
Modularity.
Data can be exchanged between forms.