# Blog - Link: https://ultimasolution.pl/blog/ - Published: 2023-10-29T16:57:40+01:00 - Author: Karol Preiskorn # Engineering Notes & Tutorials Practical notes from hands-on work with Oracle and PL/SQL, SAP ABAP, and database- backed applications, alongside occasional personal essays. * [All](https://ultimasolution.pl/blog/#) * [abap](https://ultimasolution.pl/blog/#) * [cpp](https://ultimasolution.pl/blog/#) * [database](https://ultimasolution.pl/blog/#) * [java](https://ultimasolution.pl/blog/#) * [js](https://ultimasolution.pl/blog/#) * [language](https://ultimasolution.pl/blog/#) * [life](https://ultimasolution.pl/blog/#) * [nosql](https://ultimasolution.pl/blog/#) * [oil](https://ultimasolution.pl/blog/#) * [plsql](https://ultimasolution.pl/blog/#) * [pottery](https://ultimasolution.pl/blog/#) * [python](https://ultimasolution.pl/blog/#) * [sql](https://ultimasolution.pl/blog/#) * [tempera](https://ultimasolution.pl/blog/#) * [tool](https://ultimasolution.pl/blog/#) * ![MacBook Pro open near black Canon mug](https://ultimasolution.pl/wp-content/ uploads/2024/09/p2skp_pxhlu.jpg) * ### 󠀁[How use LAG Oracle analytic function](https://ultimasolution.pl/oracle-sql-lag-oracle-11g-is-analytic-function/)󠁿 * [database](https://ultimasolution.pl/category/database/) / [plsql](https://ultimasolution.pl/category/database/plsql/)/ [sql](https://ultimasolution.pl/category/database/sql/) * ![high-angle photography of architectural building](https://ultimasolution.pl/ wp-content/uploads/2024/09/j0da0meplny.jpg) * ### 󠀁[SAP ABAP count lines in internal table with where condition](https://ultimasolution.pl/sap-abap-count-lines-in-internal-table/)󠁿 * [abap](https://ultimasolution.pl/category/language/abap/) * ![white plant overlooking sun during daytime](https://ultimasolution.pl/wp-content/ uploads/2023/11/enr71dsao5w-jpg.webp) * ### 󠀁[How you spend your morning determines your success in life](https://ultimasolution.pl/how-you-spend-your-morning-determines-your-success-in-life/)󠁿 * [life](https://ultimasolution.pl/category/life/) * ![Close-up of CSS code with colorful syntax highlighting](https://ultimasolution. pl/wp-content/uploads/2024/09/ymciistjyy.jpg) * ### 󠀁[Remove duplicated number in column](https://ultimasolution.pl/sql-corner-remove-duplicated-number/)󠁿 * [sql](https://ultimasolution.pl/category/database/sql/) * ![Code on a computer](https://ultimasolution.pl/wp-content/uploads/2024/09/aaeqmoufhlk. jpg) * ### 󠀁[SAP ABAP ALV: LVC_FIELDCATALOG_MERGE how to use?](https://ultimasolution.pl/lvc_fieldcatalog_merge-how-to-use/)󠁿 * [abap](https://ultimasolution.pl/category/language/abap/) * ![Abstract blue digital corridor](https://ultimasolution.pl/wp-content/uploads/ 2024/09/weizaiwlk1k.jpg) * ### 󠀁[What Are the Most Popular Databases? The Latest DB-Engines Ranking Explained](https://ultimasolution.pl/database-systems-popularity-ranking/)󠁿 * [database](https://ultimasolution.pl/category/database/) / [nosql](https://ultimasolution.pl/category/database/nosql/)/ [plsql](https://ultimasolution.pl/category/database/plsql/) / [sql](https://ultimasolution.pl/category/database/sql/)/ [tool](https://ultimasolution.pl/category/tool/) * ⌊Oracle logo on a red icon against a dark background⌉ ⌊Oracle logo on a red icon against a dark background⌉ * ### 󠀁[Resolving ORA-04061: A Practical Guide to PL/SQL Package Invalidation](https://ultimasolution.pl/fix-ora-04061-package-state/)󠁿 * [plsql](https://ultimasolution.pl/category/database/plsql/) / [sql](https://ultimasolution.pl/category/database/sql/) * ![Close-up of a project file list in a code editor](https://ultimasolution.pl/ wp-content/uploads/2025/05/euzk9bieq6m.jpg) * ### 󠀁[How to Return a Result Set from an Oracle Procedure Using SYS_REFCURSOR](https://ultimasolution.pl/oracle-procedure-parameter-types/)󠁿 * [plsql](https://ultimasolution.pl/category/database/plsql/) / [sql](https://ultimasolution.pl/category/database/sql/) * ![turned on gray laptop computer](https://ultimasolution.pl/wp-content/uploads/ 2024/09/xjxwbfso2f0.jpg) * ### 󠀁[Alternative Quoting Mechanism (”Q”) for String Literals](https://ultimasolution.pl/alternative-quoting-mechanism-q-for-string-literals/)󠁿 * [plsql](https://ultimasolution.pl/category/database/plsql/) / [sql](https://ultimasolution.pl/category/database/sql/) * ![computer coding screengrab](https://ultimasolution.pl/wp-content/uploads/2026/ 08/hvsr_cvecvi.webp) * ### 󠀁[Mastering Oracle Table Partitioning: Weekly & Alphabetical Subpartitions](https://ultimasolution.pl/sql-partition-by-date-keeping-weekly-and-sub-partition/)󠁿 * [sql](https://ultimasolution.pl/category/database/sql/) * ![a close up of a computer screen with many languages on it](https://ultimasolution. pl/wp-content/uploads/2024/09/hsodesbvze0.jpg) * ### 󠀁[Timestamp display in ALV](https://ultimasolution.pl/timestamp-display-in-alv/)󠁿 * [abap](https://ultimasolution.pl/category/language/abap/) * ![turned on laptop computer](https://ultimasolution.pl/wp-content/uploads/2024/ 09/dc6pb2jdaqs.jpg) * ### 󠀁[Mastering SAP Infotype 1000 Updates: A Step-by-Step ABAP Guide](https://ultimasolution.pl/sap-abap-update-infotype-1000/)󠁿 * [abap](https://ultimasolution.pl/category/language/abap/) * ![brown and green trees on brown field during daytime](https://ultimasolution. pl/wp-content/uploads/2024/09/3xrwg5d-rq4.jpg) * ### 󠀁[Traveling on paths that have heart](https://ultimasolution.pl/traveling-on-paths-that-have-heart/)󠁿 * [life](https://ultimasolution.pl/category/life/) * ![](https://ultimasolution.pl/wp-content/uploads/2019/01/th-3280542834.jpeg) * ### 󠀁[Alonefold](https://ultimasolution.pl/alonefold/)󠁿 * [life](https://ultimasolution.pl/category/life/) * ![black and silver turntable on brown wooden table](https://ultimasolution.pl/ wp-content/uploads/2025/05/gnyjcepvrs8.jpg) * ### 󠀁[LOG ERRORS Oralce’s DML](https://ultimasolution.pl/log-errors-oralces-dml/)󠁿 * [sql](https://ultimasolution.pl/category/database/sql/) * ![](https://ultimasolution.pl/wp-content/uploads/2018/03/Buddha-Weekly-Feature- image-Manjushri-by-Ben-Christian-magnificent-tangkha-Buddhism-2223610718.jpg) * ### 󠀁[Budda nie był masochistą](https://ultimasolution.pl/budda-nie-byl-masochista/)󠁿 * [life](https://ultimasolution.pl/category/life/) * ![a person standing on top of a sandy hill](https://ultimasolution.pl/wp-content/ uploads/2026/08/2gvgvf5cnae.webp) * ### 󠀁[The Ultimate Motivation: How Facing Death Unlocks a Meaningful Life](https://ultimasolution.pl/real-death-precious-life/)󠁿 * [life](https://ultimasolution.pl/category/life/) * [ ](https://ultimasolution.pl/plsql-procedure-name-exception/) * ### 󠀁[SQL owa_util.get_procedure and $$PLSQL_UNIT](https://ultimasolution.pl/plsql-procedure-name-exception/)󠁿 * [plsql](https://ultimasolution.pl/category/database/plsql/) * ![Close-up of CSS code with colorful syntax highlighting](https://ultimasolution. pl/wp-content/uploads/2024/09/ymciistjyy.jpg) * ### 󠀁[Mastering PL/SQL Cursors: A Practical Guide to Handling NO_DATA_FOUND](https://ultimasolution.pl/plsql-cursors-exception-handling/)󠁿 * [plsql](https://ultimasolution.pl/category/database/plsql/) / [sql](https://ultimasolution.pl/category/database/sql/) * ![](https://ultimasolution.pl/wp-content/uploads/2017/09/58126ce6-8ce5-4862-9633- 093895d3cc80.webp) * ### 󠀁[SQL – Search for a particular string in Oracle CLOB column](https://ultimasolution.pl/oracle-clob-search-string/)󠁿 * [sql](https://ultimasolution.pl/category/database/sql/) * ![Close-up of a project file list in a code editor](https://ultimasolution.pl/ wp-content/uploads/2025/05/euzk9bieq6m.jpg) * ### 󠀁[How to Find a Unique Session ID in Oracle: A PL/SQL Guide](https://ultimasolution.pl/oracle-unique-session-id/)󠁿 * [sql](https://ultimasolution.pl/category/database/sql/) * ![macbook pro on white table](https://ultimasolution.pl/wp-content/uploads/2023/ 11/fots3ntrois-jpg.webp) * ### 󠀁[Oracle PL/SQL Performance Tuning: Mastering BULK COLLECT & FORALL](https://ultimasolution.pl/oracle-plsql-bulk-optimization/)󠁿 * [plsql](https://ultimasolution.pl/category/database/plsql/)