Results for >>::: PL/SQL

Ref Cursor

P Baniya • 10:00 AM

REF CURSORS is the powerful, flexible, and scale-able ways to return query results from Oracle database to application. It is a PL/SQL data ...Read More

Explicit Cursor

P Baniya • 11:15 AM

A Cursor is a work area or a section of memory in which SQL statements are processed in the Oracle server. A cursor is a pointer to a privat...Read More

NO_DATA_FOUND Vs %NOTFOUND

P Baniya • 9:05 AM

To see what is out in the market, you must make your resume current and apply even if you don't intent to change the job. Why would you...Read More

LISTAGG Exception

P Baniya • 8:45 AM

Based on Oracle, LISTAGG orders data with each group specified in the ORDER BY clause and then concatenates the values of the measure colu...Read More

IF EXISTS Equivalent

P Baniya • 8:40 AM

DROP TABLE baniya.emp; What is one problem you can think of when using a DROP statement inside a SQL script? The drop command drops tabl...Read More

Using %TYPE, %ROWTYPE, & %RECORD Attributes

P Baniya • 11:24 PM

The %TYPE attribute lets you set a constant variable, field and parameter of the same data type declared previously. Changing the referenc...Read More

Oracle Stored Procedure With Examples

P Baniya • 12:40 PM

Learning PL/SQL Procedure with examples is the best way to learn Stored Procedure. You may be new to PL/SQL Procedure but you may have used...Read More

User Defined PL/SQL Function

P Baniya • 8:33 AM

You might be new to PL/SQL Functions but you are not new to Functions if you have used SQL before. Function is a subprogram that computes a...Read More

Pragma Autonomous Transaction

P Baniya • 9:15 PM

According to Oracle document, the AUTONOMOUS TRANSACTION changes the way a subprogram works within a transaction. A subprogram marked with ...Read More

DBMS_OUTPUT Package

P Baniya • 8:19 PM

DBMS_OUTPUT is a Oracle built in package that lets you send messages from stored procedures, packages and triggers. The package is helpful d...Read More

Exception Handling

P Baniya • 3:30 PM

An exception handler is a process of trapping an error that occurs while processing a PL/SQL code. Run time error may occur for various reas...Read More

Implicit Cursor

P Baniya • 11:01 AM

A cursor is a work area or a section of memory in which SQL statements are processed in the Oracle server. A cursor is a pointer to a privat...Read More

Subscribe to: Posts ( Atom )

Ref Cursor

Explicit Cursor

NO_DATA_FOUND Vs %NOTFOUND

LISTAGG Exception

IF EXISTS Equivalent

Using %TYPE, %ROWTYPE, & %RECORD Attributes

Oracle Stored Procedure With Examples

User Defined PL/SQL Function

Pragma Autonomous Transaction

DBMS_OUTPUT Package

Exception Handling

Implicit Cursor

Subscribe

Archive

Certification

Facebook

Categories

Database Career Tips

Popular Topics