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

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 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 create a 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 © 2019 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki