CodesJava

Easy learning with example program codes

How to close a cursor?

Cursor: A cursor is a pointer to context area i.e. Context area is controlled by the cursor. It is used to fetch and manipulate the data returned… Read More

How to fetch a cursor?

Cursor: A cursor is a pointer to context area i.e. Context area is controlled by the cursor. It is used to fetch and manipulate the data returned… Read More

How to declare a cursor?

Cursor: A cursor is a pointer to context area i.e. Context area is controlled by the cursor. It is used to fetch and manipulate the data returned… Read More

How to use explicit cursor?

1. DECLARE the cursor for initialization in the declaration section. 2. OPEN the cursor for memory allocation in the execution section. 3. FETCH the cursor for retrieving… Read More

What is Context area in plsql?

When processing an SQL statement, Oracle creates a temporary work area in the system memory which contains all the information needed for processing the statement known as… Read More

How to drop a function in plsql?

Pl sql function: The pl sql function is a named PL/SQL block which performs one or more specific tasks and must returns a value. create or replace… Read More

How to execute a function in plsql?

Pl sql function: The pl sql function is a named PL/SQL block which performs one or more specific tasks and must returns a value. create or replace… Read More

how to create a function in plsql?

Pl sql function: The pl sql function is a named PL/SQL block which performs one or more specific tasks and must returns a value. create or replace… Read More

How to drop stored procedure?

Pl sql stored procedure: The pl sql stored procedure is a named PL/SQL block which performs one or more specific tasks. A pl sql stored procedure can… Read More

How to execute stored procedure?

Pl sql stored procedure: The pl sql stored procedure is a named PL/SQL block which performs one or more specific tasks. A pl sql stored procedure can… Read More


Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap