Tech Snippets!!

Topics related to SQL,PL/SQL and Oracle Applications.

Pages

Home
SQL
PL/SQL
Apps

Saturday, March 2, 2013

Global Local Public Private terminology in a pl/sql Package

Posted by Nagarjuna Nudurupati at 6:32 PM No comments:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Newer Posts Older Posts Home

Subscribe to: Posts (Atom)

Search This Blog

About Me

Nagarjuna Nudurupati: I am a Software Engineer. I'll post all my technical snippets with clear working examples.

View my complete profile

Blog Archive

▼ 2013 (25)
- ► May (1)
  - ► May 02 (1)
- ► April (1)
  - ► Apr 30 (1)
- ▼ March (8)
  - ► Mar 30 (4)
  - ► Mar 22 (1)
  - ► Mar 04 (1)
  - ▼ Mar 02 (1)
    - Global Local Public Private terminology in a pl/sq...
  - ► Mar 01 (1)
- ► February (15)
  - ► Feb 26 (1)
  - ► Feb 23 (2)
  - ► Feb 20 (1)
  - ► Feb 19 (1)
  - ► Feb 15 (1)
  - ► Feb 14 (1)
  - ► Feb 12 (1)
  - ► Feb 11 (1)
  - ► Feb 09 (3)
  - ► Feb 07 (1)
  - ► Feb 05 (1)
  - ► Feb 03 (1)

Popular Posts

Workflow Query : To get Action History details

Workflow Query to get action history details: Inputs Needed : WF Item Type Ex : 'POAPPR','PABUDWF' etc., WF Item Ke...
Upload Data into Table using SQL*Loader in Oracle Apps

Upload Data into Table using SQL*Loader in Oracle Apps For SQL*Loader we need control file badfile discardfile and a dat...
Creating Public and Private subprograms in a PL/SQL Package

Package : Is a schema object that logically groups related pl/sql types,variables and subprograms. Subprograms defined in package spec bec...
Add responsibility through pl/sql

PL/SQL block to add responsibility We have an API to do this : fnd_user_pkg.addresp procedure AddResp(username varchar2, ...
PL/SQL Exception Handling -II (Pragma Excpetion_init)

PL/SQL Exception Handling - II : Pragma Excpetion_init usage Internally defined exceptions(ORA-n errors). These are raised implicitly. Ho...
Query to get all responsibilities to which a concurrent program is attached

Query to get all responsibilities to which a concurrent program is attached Input : Program Name select distinct frl.responsibility_name ...
Limitations in calling a Stored Function

To invoke/call a function from SQL statements/subprograms it should obey : 1. When called from a SELECT statement,function cannot modify...
Load Data into more than one table using SQl*Loader

Load Data into more than one table using SQl*Loader Assume this is the format of the 2 tables Table 1 : CREATE TABLE XX_EMP ( r...
PL/SQL Exception Handling - I

PL/SQL Exception Handling - I What is an exception : In PL/SQL, an error condition is called an exception. What happens if an exception rai...
Oracle Joins : Traditional Syntax

Oracle Joins : 1. Traditional Syntax 2. ANSI standard since Oracle 9i Types of Joins : 1. Self Join 2. Inner/Simple Join 3. Outer Join ...

Followers

Total Pageviews

Picture Window theme. Powered by Blogger.