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

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.

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;

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.