top of page
"All truths are easy to understand once they are discovered; the point is to discover them."
Galileo Galilei
RMAXOneNote covers a wide range of programming languages and technologies (Oracle PL/SQL, C#, Java, etc.), code examples, and solutions related to IFS ERP. The purpose of this blog is to share knowledge among developers about the problems they encounter daily.
PL/SQL Solutions
Rumesh Aponso (RMAX)
Nov 19, 20241 min read
How to select Users in Oracle
SELECT * FROM dba_users t
2 views0 comments
Rumesh Aponso (RMAX)
Nov 19, 20241 min read
How to select Tablespaces in Oracle
SELECT t.* FROM user_tablespaces t; SELECT t.* FROM dba_tablespaces t;
1 view0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
CONSTANT in PLSQL
DECLARE HUNDRED_ CONSTANT VARCHAR2(15) := 'hundred'; HUNDRED_NUM_ CONSTANT NUMBER := 100; BEGIN Dbms_Output.Put_Line(HUNDRED_);...
2 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Convert text to CamelCase
SELECT INITCAP('hello world 2rmaxonenote rmaxonenote') FROM DUAL;
1 view0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
How to use Conditional Compilation in a VIEW [Dynamic Calls]
Dynamic Calls to Optional Components Example1: @Override VIEW Part_Catalog IS Â Â type_desc.Flags = 'A-IUL' Â Â type_desc.Datatype =...
14 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Conditional Compilation [Dynamic Calls]
Dynamic Calls to Optional Components $IF (Component_COMPONENT_SYS.INSTALLED) $THEN -- TODO : $ELSE NULL; $END Example: $IF...
6 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Remove Debug Information from All Debug Complied Packages
DECLARE error_count_ NUMBER:=0; row_count_ NUMBER:=0; CURSOR get_debug_compiled_objects IS SELECT name, 'alter package ' || name || '...
2 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Profile in PLSQL
DECLARE file_name_ VARCHAR2(1000); result_ NUMBER; trace_name_ VARCHAR2(1000) := 'my_trace'; filename_ VARCHAR2(1000) :=...
7 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
List Tablespaces
SELECT * FROM user_tablespaces;
1 view0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
List Sessions
SELECT osuser, machine, program, status FROM v$session WHERE username=USER;
1 view0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
List Invalid Objects
SELECT object_name, object_type FROM all_objects WHERE status='INVALID' AND owner = USER;
1 view0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
List Packages Compiled with Debug Information
SELECT owner, name, type FROM all_plsql_object_settings WHERE PLSQL_DEBUG='TRUE';
0 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Grant IFSWEBCONFIG
BEGIN Installation_SYS.Grant_Ifswebconfig(true); END; /
0 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Debug Compile Package
ALTER PACKAGE &PACKAGE_NAME COMPILE DEBUG;
0 views0 comments
Rumesh Aponso (RMAX)
Nov 15, 20241 min read
Compile Invalid Objects
DECLARE error_count_ NUMBER:=0; row_count_ NUMBER:=0; CURSOR get_invalid_objects IS SELECT * FROM ( SELECT object_name, object_type,...
0 views0 comments
Rumesh Aponso (RMAX)
Nov 13, 20241 min read
How to check value is a Number in PLSQL
Use TO_NUMBER function in PL/SQL. Example: DECLARE value_ VARCHAR2(100); n_value_ NUMBER; CURSOR get_str_value IS SELECT...
4 views0 comments
Rumesh Aponso (RMAX)
Nov 13, 20241 min read
Get Oracle Version
SELECT * FROM v$version; SELECT * FROM v$version WHERE banner LIKE 'Oracle%';
1 view0 comments
Rumesh Aponso (RMAX)
Nov 13, 20241 min read
View with WITH | How to access data Select within a Select | How to define common Select and Use it in main Select statement
WITH cust_info AS (SELECT co.order_no FROM customer_order_tab co) SELECT t1.* FROM cust_info t1 UNION SELECT t2.* FROM cust_info t2;
1 view0 comments
Rumesh Aponso (RMAX)
Nov 13, 20241 min read
How to Search Code in PLSQL [Source Search in PLSQL]
SELECT t.* FROMÂ Â all_source t WHEREÂ UPPER(t.text) LIKE UPPER('% search string %')
8 views0 comments
Rumesh Aponso (RMAX)
Nov 13, 20241 min read
Format SQLERRM
DBMS_UTILITY.format_error_backtrace; DBMS_UTILITY.format_error_stack; Error_SYS.Is_Foundation_Error;
0 views0 comments
bottom of page