The Oracle/PLSQL ROWNUM function returns a number that represents the order that a row is selected by Oracle from a table or joined tables.
Example
select * from all_objects where rownum < 2
Oracle Tutorial, We have covered all Oracle articles which includes Oracle Database, Application, Framework, Oracle HRM, ADF Training and Financial Training. Further more we have queries and scripts for Oracle EBS Modules.
Saturday 18 April 2020
Thursday 9 April 2020
BIP 11g: Template Builder replaces with
XML-22008: (Error) Namespace prefix ‘ref’ used but not declared
By Default MSWord user form field help text as <?ref:xdo00003?> and when we configrute this rtf file in Oracle EBS. so it generate error or Dont show proper format. So need to change this text <?ref:xdo00003?> to it's data tag.
Solution:
choose tab "Build" and select radio button "Backward compatible" then re-create fields.
after this setting ms word will add <?ColumnTag?> instead of <?ref:xdo000x?>.
Tuesday 31 March 2020
Compute and Set Interactive Grid Column Value Oracle Apex
Set / Get Interactive Grid Column Value Master Detail Form Oracle Apex 1) Assign Static Id to Column (that will be update by command) and use it's id in following commands. in my example P4_ITEM_VALUE is Static Id of Item Value Column.
2) Write Dynamic action and call this JavaScript apex.item( "P4_ITEM_VALUE").setValue(apex.item('P4_RATE').getValue()*apex.item('P4_QUANTITY').getValue());
2) Write Dynamic action and call this JavaScript apex.item( "P4_ITEM_VALUE").setValue(apex.item('P4_RATE').getValue()*apex.item('P4_QUANTITY').getValue());
Set / Get Interactive Grid Column Value Master Detail Form Oracle Apex
1) Assign Static Id to Column (that will be update by command) and use it's id in following commands.
in my example P4_ITEM_VALUE is Static Id of Item Value Column.
2) Write Dynamic action and call this JavaScript
var salary = apex.item( "P4_ITEM_VALUE");
salary.setValue(100);
or
apex.item( "P4_ITEM_VALUE").setValue(10);
Oracle DDL with EXECUTE IMMEDIATE -- Drop Multiple Object at once
If You want to Drop Multiple Object at once use this script. Please
using
This script check cursor query and take update of your database
/* Formatted on 3/31/2020 1:40:01 am (QP5 v5.139.911.3011)
*/
DECLARE
CURSOR OBJECTLIST
IS
SELECT 'Drop
'
|| OBJECT_TYPE
|| ' '
|| OWNER
|| '.'
|| OBJECT_NAME
|| ''
DROPCOMMAND
FROM ALL_OBJECTS
WHERE OWNER = 'APPS' AND OBJECT_NAME LIKE 'EBA%';
BEGIN
FOR LDX IN OBJECTLIST
LOOP
DBMS_OUTPUT.PUT_LINE
(TO_CHAR (LDX.DROPCOMMAND));
BEGIN
EXECUTE IMMEDIATE
LDX.DROPCOMMAND;
DBMS_OUTPUT.PUT_LINE ('Object has been dropped.');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.
PUT_LINE (
SQLERRM
|| ' While performing this Command,'
|| TO_CHAR
(LDX.DROPCOMMAND));
END;
END LOOP;
END;
select 'Drop '||OBJECT_TYPE||' '||OWNER||'.'||OBJECT_NAME||';'
from all_objects
where owner='APPS'
AND OBJECT_NAME LIKE 'EBA%'
Wednesday 25 March 2020
Import DMP file from one schema to another
imp FILE=D:\dmpFile.dmp FULL=N fromuser=fromUser touser=ToUser LOG=D:\LOG.TXT
imp FILE=D:\25mar2020.dmp FULL=N fromuser=apps touser=pos LOG=D:\LOG.TXT
imp FILE=D:\25mar2020.dmp FULL=N fromuser=apps touser=pos LOG=D:\LOG.TXT
change tablespace of table Oracle
Runtime this Query and Move one table space to other.
SELECT 'ALTER TABLE <SCHEMA>.' || TABLE_NAME ||' MOVE TABLESPACE '||' <TABLESPACE_NAME> ' FROM dba_tables WHERE OWNER = '<SCHEMA>' AND TABLESPACE_NAME <> '<TABLESPACE_NAME>'
SELECT 'ALTER TABLE POS.' || TABLE_NAME ||' MOVE TABLESPACE '||' POS ' FROM dba_tables WHERE OWNER = 'POS'
Command :
ALTER TABLE POS.APPS_CATALOG_HEADER MOVE TABLESPACE POS
Subscribe to:
Posts (Atom)
OADBTransactionImpl in Oracle Application Framework (OAF)
OADBTransactionImpl is a class in Oracle Application Framework (OAF), which is a framework for building Oracle E-Business Suite applications...
-
Create Type Loop_Type is table of Varchar2(400) Create or Replace Function Find_Loop_F (P_End_loop in NUmber Default 10) Return Loop_Typ...
-
//import oracle.cabo.ui.validate.Formatter; important Class for Formatting // Set Number fields Format public void se...
-
We can Get current Row Using findRowByRef method of ApplicationModule. Here Example Code. Code of my AM UploadFileAMImpl am = (Upload...