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 sel