This section would have Advance Concept of PL/SQL.
AUTHID DEFINER V/S AUTHID CURRENT_USER
How to Select the Nth highest / lowest value from a table
Duplicate rows in the table
Display the number value in Words
Pragma
NOCOPY
DYNAMIC SQL
BULK COLLECT
FORALL
skip to main |
skip to sidebar
I would like to share some of my design & development work with Oracle Applications community. I will keep adding more information to this page on ongoing basis. My blog will be most useful to those who are new to oracle technology. Do not forget giving your comments. I appreciate your comments or suggestions. This will help making blog best. Learning and Practice Oracle APPS or Oracle Cloud ERP for FREE ---> http://www.grokonline.com/vision-instance/
You are Visitor
Followers (Don't be WILD to WILDLIFE. SAVE TIGERS. Only 1411 left to save.)
Labels
- Download links (1)
- Forms (1)
- Issues and Solution (1)
- IZ0-451 Oracle SOA Foundation Practitioner (1)
- Oracle Applications (1)
- Oracle Training Videos (1)
- PL/SQL Advance (1)
- Ready Scripts (1)
- Release 12 New Features (1)
- SQL LOADER Tutorial (1)
- Unix Commands (1)
- User Guide (1)
- WorkFlow (1)
Blog Archive
-
▼
2008
(121)
-
▼
August
(76)
- AP Module
- Detail Hold information of the Invoice
- Summary Hold information based on the Invoice Number
- Introduction of DYNAMIC SQL
- DBMS_SQL
- EXECUTE IMMEDIATE
- Dynamic SQL
- AP Module 12 Release New Features
- Multiple Organizations Access Control
- Integration with Oracle E-Business Tax
- Integration with Oracle Subledger Accounting
- Payment Configuration Controlled by Global Descrip...
- Integration with Oracle Payments for Funds Disburs...
- Document Sequencing of Payments
- Centralized Banks and Bank Account Definitions in ...
- Invoice Lines
- Suppliers Added to Trading Community Architecture
- Introduction
- Release 12 New Features
- GL Module 12 Release New Features
- Statistical Report-Level Currency for Financial St...
- Revaluation
- Period Rates
- Global Accounting Engine Integration
- Multiple Reporting Currency Changes
- Sets-of-Books Changes
- Accounting Setup
- Changes in Terminology
- OM Module
- Order Line is Invoiced or not
- SQL LOADER Q & A
- Demo fixed script
- Demo Variable script
- Fixed record format
- Variable record format
- SQL LOADER Tutorial
- Introduction of SQL LOADER
- Oracle Application Story
- Know who all users are using the E-Business suite
- Get Report With Parameters list
- Get the user’s status in the ICX_SESSIONS table
- Advance Shipment Notice
- Audit the changes in Profile Options in given numb...
- Get detail of Locks with Object Locked
- P2P Query based on the Purchase Order Number
- PO Module
- Get the Shipment Number based on the po header id ...
- WorkFlow
- Query find Implementation
- PL/SQL Advance
- Oracle Applications Concepts
- Chart of Accounts Structure Overview
- Chart of Account Segment Hierarchy Ranges
- Operating Unit and Legal Entity Configuration
- Summary Account Template definition review script
- Set of Books Configuration Overview
- Segment Value Listing
- Period Status script
- Mass Allocation Formula review script
- Journal Lines With AP Source Reference Fields
- Journal Line Based Trial Balance Report
- Journal Header Summary
- Interface Summary
- Interface Details
- FSG Report and Components Overview
- Flexfield Security Rule Definitions
- Flexfield Security Rule Assignments
- CVR Cross Validation Rule Overview
- CVR Cross Validation Rule Detail Listing
- Code Combinations CCID
- GL Modules
- Ready Scripts
- General/AOL Module scripts
- Balances and Movements
- Autopost Definitions
- ADI Journal Balances
-
▼
August
(76)
Phani profile
- phani
- Hyderabad, AP, India
- Hi, I am Techno-functional Consultant. I got around 8 years experience in Oracle Application and SOA suite.
2 comments:
explain me how to call this function
create or replace function updnval(
tab in varchar2,
col in varchar2,
val in number,
whr in varchar2 := null,
sch in varchar2 := null)
return integer is
begin
execute immediate
'update'||nvl(sch,user)||','||tab||
'set'||col||'=:the_value where'||
nvl(whr,'1=1') using val;
return sql%rowcount;
end;
/
Hi Shaikh,
After creating the function in the database.
Use the following.
Declare
xx NUMBER;
begin
xx := updnval(tab => ___
,col => ___
,val => ___
,whr => ___
,sch => ___
);
dbms_output.put_line(xx);
end;
Post a Comment