Understanding About Object Creation with same name | Object Overloading in PLSQL

 
-- FIRST Session  ===================================


XXSD_TEST_FUN(PAR_1)

XXSD_TEST_FUN(PAR_1,PAR_2)

XXSD_TEST_FUN(PAR_1,PAR_1_2,PAR_3)


--=======================================
can we create DB Object with same name  ? 
how to use whenever it is required ?
--=======================================

---======  TABLE --==========

select * from XXMK_TEST

create table XXMK_TEST ( EMPID NUMBER, EMPNAME VARCHAR2(100) )

create table XXSD.XXMK_TEST ( EMPID NUMBER, EMPNAME VARCHAR2(100) )


create table XXMK_TEST ( EMPID NUMBER )

create table XXSD.XXMK_TEST ( EMPID NUMBER )

select * from all_objects 
where object_name = 'XXMK_TEST' 

edit  XXMK_TEST

select * from XXMK_TEST

edit  XXSD.XXMK_TEST

select * from XXSD.XXMK_TEST


---======  VIEW--==========


create or replace view  XXMK_TEST as 
select * from  APPS.XXMK_TEST

create or replace view  XXSD.XXMK_TEST as 
select * from  APPS.XXMK_TEST

create or replace view  XXMK_TEST_V as 
select * from  APPS.XXMK_TEST

--drop view XXSD.XXMK_TEST

select * from all_objects 
where object_name like 'XXMK_TEST%'

select * from XXMK_TEST_V


---======  SUB Program  Function -==========


create or replace function XXMK_TEST RETURN NUMBER  
AS
V_NUM NUMBER;
BEGIN

select 1 INTO V_NUM from dual;
RETURN V_NUM;

END;



--drop function XXMK_TEST1

select * from all_objects 
where object_name = 'XXMK_TEST'

---======  SUB Program  Procedure -==========

create or replace procedure XXMK_TEST
AS
V_NUM NUMBER;
BEGIN

select 1 INTO V_NUM from dual;
dbms_output.put_line (V_NUM);

END;


--drop procedure XXMK_TEST1 

select * from all_objects 
where object_name = 'XXMK_TEST'



--=================  between Function and Procedure --===============

create or replace procedure XXMK_TEST_SUBPROGRAM 
AS
V_NUM NUMBER;
BEGIN

select 1 INTO V_NUM from dual;
dbms_output.put_line (V_NUM);

END;



create or replace function XXMK_TEST_SUBPROGRAM RETURN NUMBER 
AS
V_NUM NUMBER;
BEGIN

select 1 INTO V_NUM from dual;
dbms_output.put_line (V_NUM);

return V_NUM;

END;


--======================================
But when we change schema 
--======================================


create or replace function XXSD.XXMK_TEST_SUBPROGRAM RETURN NUMBER 
AS
V_NUM NUMBER;
BEGIN

select 1 INTO V_NUM from dual;
dbms_output.put_line (V_NUM);

return V_NUM;

END;



select * from all_objects 
where object_name = 'XXMK_TEST_SUBPROGRAM' 


--=========================================
can we create same subprogram with different -2 parameter  same as
--=========================================


create or replace function XXMK_SUBPROGRAM ( P_PARA_1 NUMBER) RETURN NUMBER 
AS

BEGIN

return P_PARA_1;

END;

create or replace function XXMK_SUBPROGRAM ( P_PARA_1 NUMBER, P_PARA_2 NUMBER) RETURN NUMBER 
AS

BEGIN

return P_PARA_2;

END;


create or replace function XXMK_SUBPROGRAM ( P_PARA_1 NUMBER, P_PARA_2 NUMBER, P_PARA_3 NUMBER) RETURN NUMBER 
AS

BEGIN

return P_PARA_3;

END;

---  How to use ablove all

select XXMK_SUBPROGRAM(1,2,3)  from dual


select * from all_objects 
where object_name = 'XXMK_SUBPROGRAM'

--=======================================
--yes we can create a function with same name in differnet schema
--=======================================

create  function XXMK_SUBPROGRAM_N ( P_PARA_1 NUMBER) RETURN NUMBER 
AS

BEGIN

return P_PARA_1;

END;



create  function XXSD.XXMK_SUBPROGRAM_N ( P_PARA_1 NUMBER, P_PARA_2 NUMBER) RETURN NUMBER 
AS

BEGIN

return P_PARA_2;

END;




--==========================================
--can we create procedure with same name or different schema
--==========================================

create or replace procedure XXMK_TEST_SUBPROGRAM ( P_PARA_1 IN NUMBER)  
AS

BEGIN

dbms_output.put_line (P_PARA_1);

END;

create or replace procedure XXMK_TEST_SUBPROGRAM ( P_PARA_1 IN NUMBER, P_PARA_2 IN NUMBER)  
AS

BEGIN

dbms_output.put_line (P_PARA_2);

END;


create or replace procedure XXSD.XXMK_TEST_SUBPROGRAM ( P_PARA_1 IN NUMBER, P_PARA_2 IN NUMBER,P_PARA_3 IN NUMBER)  
AS

BEGIN

dbms_output.put_line (P_PARA_3);

END;

--========================================
can we create same in different schema -- NO
--========================================

Comments

Post a Comment

Popular posts from this blog

E-Text Report In Fusion | Types of E-Text reports

 WHAT IS Oracle Fusion E-Text Report ? An eText template is an RTF-based template that is used to generate text output  for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). How it generate the output for User or Bank? At runtime, BI Publisher applies this template to an input XML data file to create an output text file. that can be transmitted to a bank or other customer.  Because the output is intended for electronic communication, the eText templates must follow very specific format instructions for exact placement of data. Example :- Bank payment file , Bank MT940 File .. etc what is look and feel of this file ? Note:  There are two types of eText templates:  1. fixed-position based (EFT templates)  2. Delimiter-based (EDI templates) What IS EFT File? An EFT is an electronic transmission of financial data and payments to banks in a specific fixed-position format flat file (text). Link for download:- EFT :-  https://docs.google.com/document/d/14xAYceq2hx8WIy3Iux
Read more

Supplier API's

API's for Create Supplier, Create Supplier Site, Create Supplier Site Contacts --======================================================================= -------------Supplier API ------------- 1. First Write a CURSOR for Required Data 2. FND_GLOBAL.APPS_INITIALIZE 3. Pass required Values in Proper way. 4. API :- For Supplier Create (pos_vendor_pub_pkg.create_vendor)    API :- For Supplier Site Create (pos_vendor_pub_pkg.create_vendor_site)    API :- For Supplier Create Contact (ap_vendor_pub_pkg.create_vendor_contact) 5. Run API 6. Checking ------------------------------  Query For APPS_INITIALIZE   --------------------------------------------- select 'USER_ID' REMARKS , user_name NAME, user_id ID from fnd_user where user_name like 'DEVELOPER' union select 'RESPONSIBILITY_ID' NAME, responsibility_name , RESPONSIBILITY_ID from fnd_responsibility_tl where responsibility_name like 'Payables Manager' union s
Read more

How to pass default Parameter in cursor

--==================================================== --Parameterized Cursors /* Syntax of Parameterized Cursor :- CURSOR cur _ name (parameter list may be one, two, or more or Default ) IS SELECT statement; OPEN cur _ name (Parameter value) */ EMPNO ENAME HIREDATE DOB GENDER SAL DEPTNO COMM 1000 Sachin 11-Sep-85 01-Mar-20 M 25000 20 1002 Rena 01-Aug-82 11-Mar-20 F 125000 20 1008 Sonu 11-Sep-85 01-Mar-20 M 2500 10 100 1003 Chavi 25-Mar-81 15-Feb-20 F 5000 20 1006 Ravi 11-Sep-89 01-Mar-19 M 2500 10 100 1005 Vinod 18-Sep-86 01-Mar-20
Read more