- Hubs »
- tagged plsql
1-10 of 20 Hubssort by Hot Best Latest
70How to convert between DBMS_SQL and Native Dynamic SQL in Oracle 11g
This Article is intended for plsql programmer, who may not be aware of the new features of Oracle 11g.One of those new features is to switch between dynamic SQL and DBMS_SQL. You may asking why to switch to DBMS_SQL while native dynamic SQL(NDS) is...
0 comments63sql pl/sql USE AND NEED OF PACKAGES WITH PRIVATE FUNCTIONS
SOMETIMES WE NEED TO DEFINE FUNCTIONS ACCESSIBLE TO US ONLY AND FOR THAT PROCEDURE WITHIN THE PACKAGE ONLY. PACKAGES WITH PRIVATE FUNCTIONS ARE USED FOR THE SAME TO PROVIDE INCREASED SECURITY.
0 comments60FINDING SALGRADE THROUGH PROCEDURE WHICH INTURNS CALLS FUNCTION USING PL/SQL
THIS PROGRAM GIVES IDEAS HOW TO LINK TWO OR MORE TABLES EFFCIENTLY. ALSO EXPLAINS USE OF EXCEPTIONS. HERE WE ARE FIRST WRITING A FUNCTION WHICH RETURNS A VALUE. THE VALUE IS PROCESSED IN A PROCEDURE. THE PROCEDURE IS CALLED BY A BLOCK.
0 comments
59BEST EXAMPLE OF PACKAGES WITH PROCEDURES AND PRIVATE FUNCTIONS SELECT IN
THE BEST PART OF PACKAGES WITH PROCEDURES, FUNCTIONS CAN BE DELIEVERED WHEN THEY ARE PROVIDED WITHOUT ANY PARAMETERS.
0 comments61Embedding function in a procedure
this explains how to embed function in a procedure. function can return only 1 value.procedures can return many values.
0 comments56use of packages in pl/sql
A PACKAGE is a PL/SQL construct that allows related objects to be stored together.
1 comment
59VIEWS IN PL/SQL
A view is an object that contains no data of its own.Views are easy to use and implement as they are not tables. View definition is stored in data dictionary. Hence the changes are automatically reflected in the views.
0 comments
56How to Optimize Database Code
I believe that you are not among the people who think money is for free. The reason for saying this is because you are probably aware that financial costs are much higher if your source code is already...
0 comments
78Practice PL/SQL Examples - Part 1
DECLARE PROCEDURE print_number( n1 NUMBER) IS tot NUMBER := n1 ; BEGIN FOR i IN 1 .. 10 LOOP dbms_output.put_line(tot); tot := tot + 1; ...
6 comments
44Oracle Exceptions - User Defined and Oracle Defined
http://forums.oraclepassport.com 1. What are exceptions in Oracle? Exceptions are the ways in which Oracle could handle runtime errors in a PL/SQL block. Exceptions are always useful to debug the code as...
