Ref Cursor
DBARepublic.com • 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
Results for >>:::
PL/SQL
Explicit Cursor
DBARepublic.com • 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
DBARepublic.com • 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
DBARepublic.com • 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
DBARepublic.com • 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
DBARepublic.com • 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
DBARepublic.com • 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
DBARepublic.com • 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
DBARepublic.com • 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
DBARepublic.com • 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
DBARepublic.com • 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
DBARepublic.com • 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
)
