# ultimasolution.pl > 3d inventory app --- ## Pages - [Dev Blog](https://ultimasolution.pl/blog/): A diverse tech portfolio with guides on PLSQL, Angular, WordPress, SAP, JS, SQL & Linux. Master Promises, ESLint, Oracle &... - [About](https://ultimasolution.pl/about/): EN-US: Dev journey: DBs to blockchain. Solutions for WP, SAP, Java & more. - [The Art](https://ultimasolution.pl/art/): Explore my portfolio of projects, from WordPress and SAP ABAP to Java, Node. js, and blockchain solutions. - [Data Center Inventory Software](https://ultimasolution.pl/) → [Markdown](https://ultimasolution.pl/wp-content/uploads/llms_md/2025-11-30_14-23.png): A programming journey building database applications. Explore d-inventory, a spatial solution for managing warehouses & server rooms. --- ## Posts - [Test and Debug Code Instantly: The Best Online SQL Fiddles](https://ultimasolution.pl/online-sql-compiler-tools/): Explore top SQL Fiddle engines and online compilers for Oracle. A guide to tools like rextester and dbfiddle for testing... - [Blockchain in Java](https://ultimasolution.pl/blockchain-in-java/): This class implements a basic blockchain in Java, incorporating fundamental blockchain concepts such as block validation, transactions, and wallet management. - [The Art of Zisha: A Complete Guide to Handmade Yixing Teapots](https://ultimasolution.pl/how-to-make-yixing-teapot/): Discover the art of crafting a handmade Yixing teapot. Our guide explores traditional techniques using Zisha purple clay. - [SAP ABAP ALV: LVC_FIELDCATALOG_MERGE how to use?](https://ultimasolution.pl/lvc_fieldcatalog_merge-how-to-use/): Understanding Field Catalog in ALV (ABAP List Viewer) In ABAP, the field catalog is a key element when working with... - [Spring Boot Rest](https://ultimasolution.pl/spring-boot-rest/): EN-US: Build a Spring Boot loan API with risk eval, Mockito & HSQL/MySQL. PL: Zbuduj API pożyczkowe w Spring Boot... - [Recursive Fibonacci in Java: A Simple Step-by-Step Guide](https://ultimasolution.pl/java-fibonacci-sequence-example/): Learn to implement the Fibonacci sequence in Java using a recursive method. A practical guide with a complete code example... - [Resolving ORA-04061: A Practical Guide to PL/SQL Package Invalidation](https://ultimasolution.pl/fix-ora-04061-package-state/): Getting PL/SQL error ORA-04061? Learn why recompiling a stateful package invalidates its state and how you can fix or prevent... - [Mastering RegEx for SQL: A Practical Guide to Data Preparation](https://ultimasolution.pl/regex-sql-data-preparation/): Learn to use RegEx to prepare SQL data for SELECT/UPDATE operations. An essential tool for any developer's toolkit. - [Remove duplicated number in column](https://ultimasolution.pl/sql-corner-remove-duplicated-number/): Struggling with duplicate numbers in a database column? Learn how to clean your data with a simple Oracle PL/SQL function. - [Essential Database Design Tools: A Complete Guide to Free & Paid Solutions](https://ultimasolution.pl/best-database-design-tools/): Discover the best database design tools. Find free, open-source, and commercial options for creating ER diagrams, DDLs, and more. - [How use LAG Oracle analytic function](https://ultimasolution.pl/oracle-sql-lag-oracle-11g-is-analytic-function/): Oracle 11g introduces the LAG function, a powerful analytic tool that allows you to access data from previous rows without... - [How you spend your morning determines your success in life](https://ultimasolution.pl/how-you-spend-your-morning-determines-your-success-in-life/): I didn’t understand how important my morning was at the beginning of my mission. But it quickly became very apparent.... - [SAP ABAP count lines in internal table with where condition](https://ultimasolution.pl/sap-abap-count-lines-in-internal-table/): Efficiently count ABAP lines with REDUCE vs. the classic LOOP AT... WHERE. - [What Are the Most Popular Databases? The Latest DB-Engines Ranking Explained](https://ultimasolution.pl/database-systems-popularity-ranking/): Explore the DB-Engines ranking for the most popular database systems. See the top contenders like Oracle, MySQL, and PostgreSQL. - [How to Return a Result Set from an Oracle Procedure Using SYS_REFCURSOR](https://ultimasolution.pl/oracle-procedure-parameter-types/): Learn to pass `varchar` parameters in an Oracle PL/SQL procedure and return a dynamic result set using `sys_refcursor`. A practical... - [Alternative Quoting Mechanism (''Q'') for String Literals](https://ultimasolution.pl/alternative-quoting-mechanism-q-for-string-literals/): In PL/SQL, handling long text with single quotes can be tricky. Oracle provides the q mechanism for easier string literal... - [Add axis in three.js](https://ultimasolution.pl/add-axis-in-tree-js/): The addAxis method in Three. js adds a visual representation of the 3D coordinate axes (X, Y, Z) to the... - [3D Inventory API](https://ultimasolution.pl/3d-inventory-api/): Build a 3D inventory API with the MEAN stack. This guide uses Node. js & MongoDB to create a backend... - [Data Center Inventory UI](https://ultimasolution.pl/data-center-inventory-ui/): The 3D Inventory Angular UI is a comprehensive front end application designed to create spatial and database representations of warehouses... - [Mastering Oracle Table Partitioning: Weekly & Alphabetical Subpartitions](https://ultimasolution.pl/sql-partition-by-date-keeping-weekly-and-sub-partition/): Learn to partition huge SQL tables by date weekly and sub-partition alphabetically by station name. A practical guide for Oracle. - [Timestamp display in ALV](https://ultimasolution.pl/timestamp-display-in-alv/): The provided text contains information and code related to working with timestamps and formatting them for display in an ALV... - [Mastering SAP Infotype 1000 Updates: A Step-by-Step ABAP Guide](https://ultimasolution.pl/sap-abap-update-infotype-1000/): A guide to updating HR infotypes in SAP ABAP. Get the code to read, modify, and write data using core... - [How to youtube-dl](https://ultimasolution.pl/how-to-youtube-dl/): EN: Install youtube-dl on Linux/macOS/Win. Learn to download videos & playlists. PL: Zainstaluj youtube-dl na Linux/macOS/Win. Pobieraj filmy i playlisty. - [Traveling on paths that have heart](https://ultimasolution.pl/traveling-on-paths-that-have-heart/): (EN) I only travel paths with heart, walking them fully and breathlessly. (PL) Podróżuję tylko ścieżkami z sercem, przechodząc je... - [Alonefold](https://ultimasolution.pl/alonefold/): Alonefold is the musical project of Australian artist and composer Scott Ashton Beardow. His works blend a mixture of experimental... - [LOG ERRORS Oralce's DML](https://ultimasolution.pl/log-errors-oralces-dml/): This PL/SQL block dynamically creates and populates a table based on a SELECT statement, while using Oracle's DBMS_ERRLOG package to... - [Budda nie był masochistą](https://ultimasolution.pl/budda-nie-byl-masochista/): Mandżuśri, figlarny uczeń Siddharthy, poddał próbę mnicha medytującego nad brzydotą, przemieniając się w piękną nimfę. Mnich, choć długo opierał się... - [The Ultimate Motivation: How Facing Death Unlocks a Meaningful Life](https://ultimasolution.pl/real-death-precious-life/): Death is real and can come at any moment. Don't waste your life. True purpose comes from self-realization and inner... - [SQL owa_util.get_procedure and $$PLSQL_UNIT](https://ultimasolution.pl/plsql-procedure-name-exception/): Build a generic PL/SQL exception handler using `owa_util. get_procedure` to easily identify the source of an error in your Oracle... - [Mastering PL/SQL Cursors: A Practical Guide to Handling NO_DATA_FOUND](https://ultimasolution.pl/plsql-cursors-exception-handling/): Learn to efficiently check if a record exists in PL/SQL using cursors, exception handling, and REF CURSOR with practical code... - [SQL – Search for a particular string in Oracle CLOB column](https://ultimasolution.pl/oracle-clob-search-string/): Learn to search for a string in an Oracle CLOB column. This guide covers the best SQL methods to find,... - [How to Find a Unique Session ID in Oracle: A PL/SQL Guide](https://ultimasolution.pl/oracle-unique-session-id/): Learn two ways to get a unique session ID in Oracle. Use the DBMS_SESSION function in PL/SQL or query the... - [Implementing Brian's Brain: A Step-by-Step Guide to Cellular Automata in C](https://ultimasolution.pl/cellular-automaton-c-code/): Learn to implement a Cellular Automaton in C. This guide covers Brian's Brain rules, the Moore neighborhood, and a C... - [Java Constructors Explained: A Practical Guide to Classes and Overloading](https://ultimasolution.pl/java-class-constructor-example/): Explore Java dedicated constructors with a practical code example. Learn to declare a class, initialize fields, and create objects. - [Oracle PL/SQL Performance Tuning: Mastering BULK COLLECT & FORALL](https://ultimasolution.pl/oracle-plsql-bulk-optimization/): Boost Oracle PL/SQL performance with Bulk Processing. Learn how BULK COLLECT and FORALL speed up data retrieval and DML operations. --- # # Detailed Content ## Pages - Published: 2023-10-29 - Modified: 2026-03-07 - URL: https://ultimasolution.pl/blog/ A diverse tech portfolio with guides on PLSQL, Angular, WordPress, SAP, JS, SQL & Linux. Master Promises, ESLint, Oracle & more. 3D Inventory UI Gallery 3D Inventory UI 3d-inventory, js, portfoilio, recent 3D Inventory UI Gallery Alternative Quoting Mechanism (”Q”) for String Literals plsql, sql Alternative Quoting Mechanism (”Q”) for String Literals Gallery Alonefold life Alonefold Gallery Implementing Brian’s Brain: A Step-by-Step Guide to Cellular Automata in C No Category Implementing Brian’s Brain: A Step-by-Step Guide to Cellular Automata in C Gallery Oracle PL/SQL Performance Tuning: Mastering BULK COLLECT & FORALL plsql Oracle PL/SQL Performance Tuning: Mastering BULK COLLECT & FORALL Gallery Java Constructors Explained: A Practical Guide to Classes and Overloading java Java Constructors Explained: A Practical Guide to Classes and Overloading Gallery How to youtube-dl No Category How to youtube-dl Gallery LOG ERRORS Oralce’s DML sql LOG ERRORS Oralce’s DML Gallery How to Find a Unique Session ID in Oracle: A PL/SQL Guide sql How to Find a Unique Session ID in Oracle: A PL/SQL Guide Gallery How to Return a Result Set from an Oracle Procedure Using SYS_REFCURSOR plsql, sql How to Return a Result Set from an Oracle Procedure Using SYS_REFCURSOR Gallery Mastering PL/SQL Cursors: A Practical Guide to Handling NO_DATA_FOUND plsql, sql Mastering PL/SQL Cursors: A Practical Guide to Handling NO_DATA_FOUND Gallery SQL owa_util. get_procedure and $$PLSQL_UNIT plsql SQL owa_util. get_procedure and $$PLSQL_UNIT Gallery The Ultimate Motivation: How Facing Death Unlocks a Meaningful Life life The Ultimate Motivation: How Facing Death Unlocks a Meaningful Life Gallery Budda nie był masochistą life Budda nie był masochistą Gallery Traveling on paths that have heart life Traveling on paths... --- - Published: 2016-01-27 - Modified: 2026-03-07 - URL: https://ultimasolution.pl/about/ EN-US: Dev journey: DBs to blockchain. Solutions for WP, SAP, Java & more. Welcome! I'm a developer passionate about solving real-world programming challenges. This blog is a space where I dive into the topics that matter most in modern software development — with a particular focus on building database application interfaces. Whether it's designing intuitive UIs for complex data, tackling integration challenges, or exploring best practices for database-driven applications, you'll find practical insights and lessons learned from hands-on experience. What You'll Find Here Database Application Development — Deep dives into designing and building robust interfaces for database-backed systems. Programming Challenges — Exploring common (and uncommon) problems developers face, along with solutions and strategies. Best Practices & Patterns — Proven approaches to writing clean, maintainable, and efficient code. Tools & Technologies — Reviews and guides on the tools that make database application development easier and more productive. Why This Blog? I believe that the intersection of databases and user interfaces is one of the most critical — and often underestimated — areas in software engineering. Getting it right means building applications that are not only functional but also performant, scalable, and a pleasure to use. Thanks for stopping by — I hope you find something here that helps you on your own development journey. --- - Published: 2016-01-27 - Modified: 2026-04-11 - URL: https://ultimasolution.pl/art/ Explore my portfolio of projects, from WordPress and SAP ABAP to Java, Node.js, and blockchain solutions. Gallery The Art of Zisha: A Complete Guide to Handmade Yixing Teapots portfoilio The Art of Zisha: A Complete Guide to Handmade Yixing TeapotsKarol Preiskorn2026-04-10T09:06:19+02:00April 10th, 2026|Categories: portfoilio| --- - Published: 2016-01-27 - Modified: 2026-05-09 - URL: https://ultimasolution.pl/ A programming journey building database applications. Explore d-inventory, a spatial solution for managing warehouses & server rooms. 3data center inventory software T€‹he 3Data Center Inventory is a comprehensive front-end application designed to create spatial and database representations of warehouses and data-centers. This project serves as a practical sandbox for exploring database systems while building an efficient platform for graphical IT inventory management. The application leverages modern web technologies to provide interactive 3D visualization combined with robust data management capabilities. The application is built on Angular 21. 2. 8 with standalone components, strict TypeScript, and modern Angular control flow. Bootstrap 5. 3. 8 and Angular Material/CDK provide the UI foundation, while three. js 0. 183. 2 powers the interactive spatial visualization layer. Security is enhanced through Google reCAPTCHA v3, typed HTTP services, and CI quality gates. The backend supports both MongoDB Atlas and Oracle, and the frontend talks to it through a documented REST API. The project is built and tested with the Angular CLI, Jest, Docker, and GitHub Actions. Data Model The data model is based on a parametric, generic attribute class. All attributes for Devices, Models, and Connections are stored in this model. Parameter types are defined in the Attribute Dictionary. Attributes store values defined in the Attribute Dictionary for Devices, Models, and Connections. The Attribute Dictionary specifies parameters for these entities. I had a lot of fun learning how to convert relational DB structures to correct collections in NoSQL MongoDB. Application https://3d-inventory. ultimasolution. pl All3d-inventory Data Center Inventory UI3d-inventory / applications / js / recent 3D Inventory API3d-inventory / applications / recent --- --- ## Posts - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/online-sql-compiler-tools/ - Categories: plsql, tool - Tags: oracle, sql Explore top SQL Fiddle engines and online compilers for Oracle. A guide to tools like rextester and dbfiddle for testing your SQL code. A regular expression (shortened as regex or regexp), sometimes referred to as rational expression, is a sequence of characters that specifies a match pattern in text. Usually such patterns are used by string-searching algorithms for "find" or "find and replace" operations on strings, or for input validation. Regular expression techniques are developed in theoretical computer science and formal language theory. http://rextester. com/l/oracle_online_compiler http://dbfiddle. uk/ https://livesql. oracle. com/apex/livesql/file/index. html --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/blockchain-in-java/ - Categories: java - Tags: java This class implements a basic blockchain in Java, incorporating fundamental blockchain concepts such as block validation, transactions, and wallet management. Simple implementation blockchain implemented in Java on Linux. Clone catalog GitHub repo git clone git@github. com:karol-preiskorn/java-examples. git src/main/java/blockchain/ Setup environment We need Gradle to test and run. Simple method to install. Try use https://sdkman. io/usage SDKMAN! (my favorite) curl -s "https://get. sdkman. io" | bash source "$HOME/. sdkman/bin/sdkman-init. sh" Install Java & Gradle # list all version sdk list java * # choice one sdk install java 13. 0. 1. j9-adpt # list all version gradle sdk list gradle * # choice 6. * because we will test by jupiter sdk install gradle 6. 0. 1 Minimum theory We create simple list. Every next element is linked by hash key with body block Source @github package blockchain; import java. util. ArrayList; import java. util. Date; public class Block { public String hash; public String previousHash; public String merkleRoot; public ArrayList transactions = new ArrayList; //our data will be a simple message. public long timeStamp; //as number of milliseconds since 1/1/1970. public int nonce; //Block Constructor. public Block(String previousHash) { this. previousHash = previousHash; this. timeStamp = new Date. getTime; this. hash = calculateHash; //Making sure we do this after we set the other values. } //Calculate new hash based on blocks contents public String calculateHash { return StringUtil. applySha256( previousHash + Long. toString(timeStamp) + Integer. toString(nonce) + merkleRoot ); } //Increases nonce value until hash target is reached. public void mineBlock(int difficulty) { merkleRoot = StringUtil. getMerkleRoot(transactions); String target = StringUtil. getDificultyString(difficulty); //Create a string with difficulty * "0" while... --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/how-to-make-yixing-teapot/ - Categories: portfoilio Discover the art of crafting a handmade Yixing teapot. Our guide explores traditional techniques using Zisha purple clay. About This is compilation materials form internet to do handmade Yixing Teapot with clay some similar to Purple Clay Zisha. I am fascinating qiyun this handmade piece of art. Chinese Teapots - Manufacture And Clay Unlike Western pottery-making techniques where “earth-clays” are turned on a wheel, the more rigid quality of Zisha clay enables the component parts of a teapot to be made in advance and then assembled piece by piece. There are 3 types of manufacture: Handmade Teapots shapes Half-handmade Moulded Handmade teapots are formed into shape by an artist who hand-cuts pieces and assembles them into shape using traditional tools such as wooden picks and paddles. In preparing Zisha the clay to make the various parts of a handmade teapot, it is folded many times, somewhat like in the manufacture of Japanese katana (samurai swords). This folding strengthens the clay and creates micro channels of air pockets in the clay which allows air to move in both directions through the teapot. This “dual-porosity” characteristic is thought to provide additional oxygen to the tea while brewing and as wine drinkers know, oxygen intensifies flavour. Half-handmade is the assembly of machine-moulded pieces by hand with traditional tools. Many good teapots using Zisha clay are made in this way. Moulded teapots are made by a mass-production process of assembling pre-moulded pieces by machine, such as the two halves of the teapot and lid and attaching a pre-moulded spout and handle. Even though moulded teapots are not as valuable as handmade or... --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/lvc_fieldcatalog_merge-how-to-use/ - Categories: abap - Tags: abap, ALV Understanding Field Catalog in ALV (ABAP List Viewer) In ABAP, the field catalog is a key element when working with ALV (ABAP List Viewer) to define how the data from internal tables is displayed. It provides control over various properties of the fields displayed in the ALV, such as column headers, alignment, visibility, editability, etc. Key Concepts: Field Catalog: This is a table (usually of type lvc_t_fcat for modern ALV grid or slis_t_fieldcat_alv for old ALV grid) that contains metadata about each field of the internal table displayed in the ALV. It defines how each column should appear (e.g., column headers, field alignment, output length). Creating a Field Catalog: You can manually define a field catalog or use a function module like LVC_FIELDCATALOG_MERGE to automatically create one based on a data dictionary structure (DDIC). After generating the catalog, you can modify it to adjust field properties. Field catalog All fields of the global structure type appears in the data table with the same name. Now the requirement is to introduce changes to the dictionary structure or the additional columns are to be displayed. In this case we can call a function module ( LVC_FIELDCATALOG_MERGE ) that returns the field catalog of the dictionary structure to a table of type lvc_t_fcat. Now we can loop it and can make whatever changes we want. The REUSE_*ALV* function modules are unsupported. I'd suggest switching to the CL_SALV_* classes. The documentation is better, there are more sample programs (DEMO_SALV_*) and you get support. You need a dictionary structure if you want to get dictionary-based field descriptions (duh). If you assemble a structure type on the ABAP level using TYPE ... BEGIN OF ... END OF ... , as far as I know, the dictionary types for the individual fields are converted to ABAP types first and only then assembled into a structure type. Anyway, the dictionary reference of the original fields is lost. Instead of defining the structure of the output table in your code, use a dictionary structure. There are several different text components provided by structure slis_fieldcat_alv that are used as column labels. The chosen text depends on the current column width (which itself usually depends on the length of the data displayed). Make sure that you change them all accordingly! The usual technique is: By passing the I_STRUCTURE_NAME, you get a field catalog corresponding to this DDIC... --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/spring-boot-rest/ - Categories: java - Tags: api, java EN-US: Build a Spring Boot loan API with risk eval, Mockito & HSQL/MySQL. PL: Zbuduj API pożyczkowe w Spring Boot z analizą ryzyka, Mockito, HSQL/MySQL. Stack Simple REST backend service. Spring Boot Unit Test 4/5 Mockito HSQL -> MYSQL Task Client can apply for loan asking for amount and term Loan application evaluation: Application is risky if: Loan application is done for max amount and loan application is created between 0:00–6:00 Client Applied 3 times using the same IP address Loan is granted if loan application goes through risk evaluation without errors. Once within loan term client can apply for term to be prolonged up to 14 days. Planned Add Swagger to recognize this service https://swagger. io/resources/articles/best-practices-in-api-design/ Add docker and deploy service to AWS from GitHub Add stemming libs from IoT . Analyse I assume that the risky loan request will be rejected. Loan entity static MAX_LOAN = 1000 - overrun loanId Int artifical id. Amount Long LoanName String Ip String TermAt Date historyLog String - info about allowed operations. CreatedAt Date UpdatedAT Date example: riskEvaluation amount > MAX_LOAN. createdAt . ip same for 3 last apply in the same loanName. UnitTest Take Loan < MAX_LOAN out of - accepted. Take loan > MAX_LOAN - declined. Take loan from different IP. Take loan in different time . TrolongTerm - check changes. Prolong two times loan - declined. Impementation spring-boot-rest sample init data HSQL in import. sql junit test Setting environment (InteliJ) http://start. spring. io/ - pom. xml -add-opens and dependency for jaxb-api for suppres warning Illegal reflective access by org. springframework. cglib. core. ReflectUtils$1 StackOverflow GROOVY_TURN_OFF_JAVA_WARNINGS=true temp fix WARNING: Illegal reflective access by org. codehaus.... --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/java-fibonacci-sequence-example/ - Categories: java - Tags: exercises Learn to implement the Fibonacci sequence in Java using a recursive method. A practical guide with a complete code example and explanation. Zadanie Utwórz rekurencyjna metode obliczajaca ciag Fibonacciego, zdefiniowany dla elementu fibonacci(n) jako sume fibonacci(n-1) + fibonacci(n-2) przy załozeniu, ze fibonacci(1) i fibonacci(2) maja odpowiednio wartosci 1 i 2. Ciąg Fibonaciego In mathematics, the Fibonacci numbers are the numbers in the following integer sequence, called the Fibonacci sequence, and characterized by the fact that every number after the first two is the sum of the two preceding ones: 1 , 1 , 2 , 3 , 5 , 8 , 13 , 21 , 34 , 55 , 89 , 144 , ... Often, especially in modern usage, the sequence is extended by one more initial term: 0 , 1 , 1 , 2 , 3 , 5 , 8 , 13 , 21 , 34 , 55 , 89 , 144 , ...   The Fibonacci spiral: an approximation of the golden spiral created by drawing circular arcs connecting the opposite corners of squares in the Fibonacci tiling; this one uses squares of sizes 1, 1, 2, 3, 5, 8, 13, 21, and 34. By definition, the first two numbers in the Fibonacci sequence are either 1 and 1, or 0 and 1, depending on the chosen starting point of the sequence, and each subsequent number is the sum of the previous two. In mathematical terms, the sequence Fn of Fibonacci numbers is defined by the recurrence relation with seed values or The Fibonacci sequence is named after Italian mathematician Leonardo of Pisa, known as Fibonacci. His 1202 book Liber... --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/fix-ora-04061-package-state/ - Categories: plsql, sql - Tags: oracle, plsql, sql Getting PL/SQL error ORA-04061? Learn why recompiling a stateful package invalidates its state and how you can fix or prevent the issue. I suspect you're only reporting the last error in a stack like this: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body "schema. package" has been invalidated ORA-04065: not executed, altered or dropped package body "schema. package" ORA-06508: PL/SQL: could not find program unit being called: "schema. package" If so, that's because your package is stateful: The values of the variables, constants, and cursors that a package declares (in either its specification or body) comprise its package state. If a PL/SQL package declares at least one variable, constant, or cursor, then the package is stateful; otherwise, it is stateless. When you recompile the state is lost: If the body of an instantiated, stateful package is recompiled (either explicitly, with the "ALTER PACKAGE Statement", or implicitly), the next invocation of a subprogram in the package causes Oracle Database to discard the existing package state and raise the exception ORA-04068. After PL/SQL raises the exception, a reference to the package causes Oracle Database to re-instantiate the package, which re-initializes it... You can't avoid this if your package has state. I think it's fairly rare to really need a package to be stateful though, so you should revisit anything you have declared in the package, but outside a function or procedure, to see if it's really needed at that level. Since you're on 10g though, that includes constants, not just variables and cursors. But the last paragraph from the quoted documentation means that the next time you reference... --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/regex-sql-data-preparation/ - Categories: js, sql, tool - Tags: data, regex, sql Learn to use RegEx to prepare SQL data for SELECT/UPDATE operations. An essential tool for any developer's toolkit. Regex is an essential tool in every developer's tool-bag. It helps you perform a search in strings. Regex is used everywhere from compilers to word processors. Problem with SQL IN(... ) It is an example to use Regexp to prepare SQL data for SELECT/UPDATE operation. Regexp: /^. */gm and substitution: '�', Explanation ^ asserts position at start of a line . * matches any character (except for line terminators) * Quantifier — Matches between zero and unlimited times, as many times as possible, giving back as needed (greedy) Global pattern flags >g modifier: global. All matches (don't return after first match) m modifier: multi line. Causes ^ and $ to match the begin/end of each line (not only begin/end of string) Example how to use it This example simple replaces MBS to ,'MBS'. For example, when you have many selected values in SQL (in one column) and need to convert it to running query. SELECT * FROM TABLE WHERE ID IN( AAA AAB AAC ... ) Convert it to: SELECT * FROM TABLE WHERE ID IN( 'AAA', 'AAB', 'AAC') Example in practice: https://regex101. com/r/34repv/1 or https://extendsclass. com/regex-tester. html#MTkxMTI1MTNkZTM5MmRjYWY1 solution Try to find playlist in YouTube URL (? :https? :\/\/)? (? :youtu\. be\/|(? :www\. |m\. )? youtube\. com\/(? :playlist|list|embed)(? :\. php)? (? :\? . *list=|\/))(+) Test this example https://regex101. com/r/p8x4GU/2 Good tools for testing regex https://regex101. com/ and here is this example: https://regex101. com/r/34repv/1 https://extendsclass. com/regex-tester. html#MTkxMTI1MTNkZTM5MmRjYWY1 (very good graphics explanation) https://pythonium. net/regex https://regexr. com/ https://rustexp. lpil. uk/ How is run... --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/sql-corner-remove-duplicated-number/ - Categories: sql - Tags: data, find, html, oracle, regex, sql Struggling with duplicate numbers in a database column? Learn how to clean your data with a simple Oracle PL/SQL function. Problem Last time I have a problem with duplicated number in post address (column). Our callback interfaces write to us many error_number. Bad formatted duplicated numbers. So first I have to find where is and how many this number are. How remove duplicated in field number? Bad numbers: CREATE TABLE locations ( site_number INT, ADR_STREET_NO VARCHAR (7) ); INSERT INTO locations (site_number, ADR_STREET_NO) VALUES (2, '22 22'); INSERT INTO locations (site_number, ADR_STREET_NO) VALUES (1, '1 111'); INSERT INTO locations (site_number, ADR_STREET_NO) VALUES (3, '3 3'); INSERT INTO locations (site_number, ADR_STREET_NO) VALUES (3, '43 645'); INSERT INTO locations (site_number, ADR_STREET_NO) VALUES (3, '72 85'); INSERT INTO locations (site_number, ADR_STREET_NO) VALUES (3, '23 95'); INSERT INTO locations (site_number, ADR_STREET_NO) VALUES (3, '711 711'); SITE_NUMBER ADR_STREET_NO 2 22 22 1 1 111 3 3 3 3 43 645 3 72 85 3 23 95 3 711 711 How to solve the problem? SELECT l. site_number, l. ADR_STREET_NO, REGEXP_REPLACE (l. ADR_STREET_NO, '(+)( \1)+', '\1') FROM mibp_owner. locations l WHERE REGEXP_LIKE (ADR_STREET_NO, '\d \d'); -- UPDATE mibp_owner. locations l SET l. ADR_STREET_NO = REGEXP_REPLACE (l. ADR_STREET_NO, '(+)( \1)+', '\1') WHERE REGEXP_LIKE (ADR_STREET_NO, '\d \d'); ITE_NUMBER ADR_STREET_NO REGEXP_REPLACE(L. ADR_STREET_NO,'(+)(\1)+','\1') 2 22 22 22 1 1 111 111 3 3 3 3 3 43 645 43 645 3 72 85 72 85 3 23 95 23 95 3 711 711 711 After update: SELECT l. site_number, l. ADR_STREET_NO, REGEXP_REPLACE (l. ADR_STREET_NO, '(+)( \1)+', '\1') FROM locations l WHERE REGEXP_LIKE (ADR_STREET_NO, '\d \d'); SITE_NUMBER ADR_STREET_NO REGEXP_REPLACE(L. ADR_STREET_NO,'(+)(\1)+','\1') 3... --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/best-database-design-tools/ - Categories: tool - Tags: php, plsql, project, sql Discover the best database design tools. Find free, open-source, and commercial options for creating ER diagrams, DDLs, and more. GNU-GPL OpenSystemArchitect http://www. codebydesign. com/ Power*Architect http://code. google. com/p/power-architect/ Druid http://druid. sourceforge. net/ ERW http://erw. dsi. unimi. it/ Dia http://live. gnome. org/Dia XML to DDL (python scripts) http://xml2ddl. berlios. de/ Graphiz - I believe I've read of people using it to reverse engineer from DDL http://graphviz. org/ Multiple versions/licenses (each has a "free" and a "not-free" version) DBVisualizer Toad Not-free Microsoft Visio - (If you already have it, it does work quite well) DataStudio - 30 day trial http://www. aquafold. com DBWrench - 30 day trial http://www. dbwrench. com/ ER diagram tool http://druid. sf. net/ http://schemaspy. sourceforge. net/ http://uml. sourceforge. net/index. php --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/oracle-sql-lag-oracle-11g-is-analytic-function/ - Categories: plsql, sql - Tags: oracle, plsql, sql Oracle 11g introduces the LAG() function, a powerful analytic tool that allows you to access data from previous rows without needing a self-join. The LAG() function retrieves data from a specific offset before the current row, making it ideal for tasks like comparing consecutive entries. Very usefully new features in Oracle 11g is analytic Oracle SQL function LAG. Oracle LAG is an analytic function that allows you to access the row at a given offset before the current row without using a self-join. The following illustrates the syntax of the LAG function: LAG(expression ) OVER ( order_by_clause ) SQL query LAG This code find change in address post code in journal table: SELECT * FROM ( SELECT t1. SITE_NUMBER ,t1. JN_DATETIME ,t1. ADR_POSTCODE ,LAG (t1. ADR_POSTCODE, 1) OVER (PARTITION BY t1. SITE_NUMBER ORDER BY t1. jn_datetime) AS PREV_ADR_POSTCODE FROM t1 ) WHERE adr_postcode = '00-001' AND PREV_ADR_POSTCODE '00-001' AND PREV_ADR_POSTCODE '00-000' ORDER BY SITE_NUMBER; Test query data CREATE TABLE T1 ( SITE_NUMBER VARCHAR2(16 BYTE), JN_DATETIME DATE, ADR_POSTCODE VARCHAR2(20 BYTE) ) LOGGING NOCOMPRESS MONITORING;" message="" highlight="" provider="manual"/][pastacode lang="sql" manual="SET DEFINE OFF; Insert into KPREISKORN. T1 (SITE_NUMBER, JN_DATETIME, ADR_POSTCODE) Values ('20001', TO_DATE('08/01/2017 15:01:31', 'MM/DD/YYYY HH24:MI:SS'), '00-001'); Insert into KPREISKORN. T1 (SITE_NUMBER, JN_DATETIME, ADR_POSTCODE) Values ('20002', TO_DATE('04/20/2017 11:59:29', 'MM/DD/YYYY HH24:MI:SS'), '00-002'); Insert into KPREISKORN. T1 (SITE_NUMBER, JN_DATETIME, ADR_POSTCODE) Values ('20001', TO_DATE('06/15/2017 04:02:41', 'MM/DD/YYYY HH24:MI:SS'), '00-003'); Insert into KPREISKORN. T1 (SITE_NUMBER, JN_DATETIME, ADR_POSTCODE) Values ('20004', TO_DATE('06/20/2017 20:15:13', 'MM/DD/YYYY HH24:MI:SS'), '00-001'); Insert into KPREISKORN. T1 (SITE_NUMBER, JN_DATETIME, ADR_POSTCODE) Values ('20001', TO_DATE('12/10/1929 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '00-001'); Insert into KPREISKORN. T1 (SITE_NUMBER, JN_DATETIME, ADR_POSTCODE) Values ('20001', TO_DATE('09/25/2091 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '00-003'); Insert into KPREISKORN. T1 (SITE_NUMBER, JN_DATETIME, ADR_POSTCODE) Values ('20001', TO_DATE('09/14/1914 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '00-001'); Insert into KPREISKORN. T1 (SITE_NUMBER, JN_DATETIME, ADR_POSTCODE) Values ('20001', TO_DATE('03/25/1911 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '00-001'); Insert into KPREISKORN.... --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/how-you-spend-your-morning-determines-your-success-in-life/ - Categories: life - Tags: life, quote I didn’t understand how important my morning was at the beginning of my mission. But it quickly became very apparent. As a missionary, the first several hours of the day are dedicated to getting ready, studying, and planning. After a few months in “the mission field,” I noticed that most missionaries dragged themselves out of bed, and dragged themselves through their studies. While serving a humanitarian and ecclesiastical mission at the age of 20, I learned potentially the most important lesson of my life. How you spend your morning determines your success in life. How you spend your morning determines who you will become. How you spend your morning determines whether you become world-class at something, or remain merely average. How you spend your morning is the difference between making tens of millions of dollars and making less than 100 grand. How you spend your morning determines how well you: think strategize prioritize spend your time choose your friends choose your lover choose your career perform in your work influence the world I didn’t understand how important my morning was at the beginning of my mission. But it quickly became very apparent. As a missionary, the first several hours of the day are dedicated to getting ready, studying, and planning. After a few months in “the mission field,” I noticed that most missionaries dragged themselves out of bed, and dragged themselves through their studies. My experience was different. For the first time in my life, I experienced the power of learning. I felt the nourishment of feeding my mind and soul. To quote Oliver Wendell Holmes, Jr. : “A mind that is stretched by a new experience can never go back to its old dimensions. ” I started waking up earlier than prescribed to read more and more. Rather than reading one hour each morning as recommended, I was reading three or... --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/sap-abap-count-lines-in-internal-table/ - Categories: abap - Tags: tables - Formats: Link Efficiently count ABAP lines with REDUCE vs. the classic LOOP AT...WHERE. Ex1 REDUCE Definition REDUCE ... REDUCE type( INIT || || ... FOR for_exp1 FOR for_exp2 ... NEXT ... | | ... ) ... While `VALUE` and `NEW` expressions can include `FOR` expressions, `REDUCE` must include at least one FOR expression. You can use all kinds of `FOR` expressions in `REDUCE`: with `IN` for iterating internal tables with `UNTIL` or `WHILE` for conditional iterations Source: https://help. sap. com/doc/abapdocu_751_index_htm/7. 51/en-us/abenconstructor_expression_reduce. htm Before 7. 40 DATA: lv_lines TYPE i. LOOP AT gt_itab INTO ls_itab where F1 = 'XYZ'. lv_lines = lv_lines + 1. ENDLOOP. After 7. 40 DATA(lv_lines) = REDUCE i( INIT x = 0 FOR wa IN gt_itab WHERE( F1 = 'XYZ' ) NEXT x = x + 1 ). Source: https://blogs. sap. com/2015/10/25/abap-740-quick-reference/ Example SELECT * FROM mara INTO TABLE @DATA(lt_mara) UP TO 10 ROWS. DATA(lv_count) = REDUCE i( INIT i = 0 FOR wa IN lt_mara WHERE ( aenam EQ 'MARSLAN' ) NEXT i = i + 1 ). TYPES: BEGIN OF ty_material, matnr TYPE char40, maktx TYPE char40, matkl TYPE char9, END OF ty_material. DATA: lt_materials TYPE STANDARD TABLE OF ty_material. lt_materials = VALUE #( ( matnr = '000000000051000298' maktx = 'Description 1' matkl = 'A' ) ( matnr = '000000000051003780' maktx = 'Description 2' matkl = 'A' ) ( matnr = '000000000051008389' maktx = 'Description 3' matkl = 'B') ( matnr = '000000000051008390' maktx = 'Description 4' matkl = 'C' ) ( matnr = '000000000051008394' maktx = 'Description 5' matkl = 'B' ) ). * Simply get the... --- - Published: 2026-04-10 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/database-systems-popularity-ranking/ - Categories: plsql, sql - Tags: database, sql Explore the DB-Engines ranking for the most popular database systems. See the top contenders like Oracle, MySQL, and PostgreSQL. The DB-Engines Ranking ranks database management systems according to their popularity. The ranking is updated monthly. Read more about the method of calculating the scores. https://db-engines. com/en/ranking Rank DBMS Database Model Score Sep 2024 Aug 2024 Sep 2023 Sep 2024 Aug 2024 Sep 2023 1. 1. 1. Oracle Relational, Multi-model 1286. 59 +28. 11 +45. 72 2. 2. 2. MySQL Relational, Multi-model 1029. 49 +2. 63 -82. 00 3. 3. 3. Microsoft SQL Server Relational, Multi-model 807. 76 -7. 41 -94. 45 4. 4. 4. PostgreSQL Relational, Multi-model 644. 36 +6. 97 +23. 61 5. 5. 5. MongoDB Document, Multi-model 410. 24 -10. 74 -29. 18 6. 6. 6. Redis Key-value, Multi-model 149. 43 -3. 28 -14. 26 7. 7. 11. Snowflake Relational 133. 72 -2. 25 +12. 83 8. 8. 7. Elasticsearch Search engine, Multi-model 128. 79 -1. 04 -10. 20 9. 9. 8. IBM Db2 Relational, Multi-model 123. 05 +0. 04 -13. 67 10. 10. 9. SQLite Relational 103. 35 -1. 44 -25. 85 Source: DB-Engines Ranking - popularity ranking of database management systems --- - Published: 2024-11-01 - Modified: 2026-03-28 - URL: https://ultimasolution.pl/oracle-procedure-parameter-types/ - Categories: plsql, sql - Tags: oracle, plsql Learn to pass `varchar` parameters in an Oracle PL/SQL procedure and return a dynamic result set using `sys_refcursor`. A practical code example. -- Declare a typed cursor type CREATE OR REPLACE PACKAGE emp_pkg AS TYPE emp_cur_t IS REF CURSOR RETURN employees%ROWTYPE; PROCEDURE get_employees ( p_dept_id IN NUMBER, p_cursor OUT emp_cur_t ); END emp_pkg; / DECLARE l_cursor SYS_REFCURSOR; l_emp_id employees. employee_id%TYPE; l_fname employees. first_name%TYPE; l_lname employees. last_name%TYPE; l_salary employees. salary%TYPE; BEGIN get_employees(p_dept_id => 10, p_cursor => l_cursor); LOOP FETCH l_cursor INTO l_emp_id, l_fname, l_lname, l_salary; EXIT WHEN l_cursor%NOTFOUND; DBMS_OUTPUT. PUT_LINE(l_fname || ' ' || l_lname || ': ' || l_salary); END LOOP; CLOSE l_cursor; -- always close to release resources END; / Key Rules Rule Detail Always CLOSE the cursor Unclosed ref cursors hold server-side resources until the session ends Callers own the cursor Once passed back, the procedure is done — the caller fetches and closes Use bind variables Avoid SQL injection and improve plan reuse when building dynamic SQL SYS_REFCURSOR vs typed REF CURSOR SYS_REFCURSOR (weak) accepts any query; a typed ref cursor is tied to a specific row type and gives compile-time checking Exception handling If an exception is raised after OPEN, the cursor may never be returned — close it in the EXCEPTION block if opened locally Typed cursors give compile-time type checking but are less flexible than SYS_REFCURSOR. --- - Published: 2024-09-16 - Modified: 2026-04-06 - URL: https://ultimasolution.pl/alternative-quoting-mechanism-q-for-string-literals/ - Categories: plsql, sql - Tags: oracle, plsql In PL/SQL, handling long text with single quotes can be tricky. Oracle provides the q[] mechanism for easier string literal management. By using custom delimiters, you can avoid escaping single quotes. All know that is sth. Problem with long text in PL/SQL. It is good to start use q' where "" represents the ending delimiter. Oracle automatically recognizes "paired" delimiters, such as , {}, , and . If you want to use some other character as your start delimiter and it doesn't have a "natural" partner for termination, you must use the same character for start and end delimiters. Finally, if you choose a character for a delimiter and it appears in your string immediately before a single quotation mark, Oracle will be unhappy and raise an error. BEGIN DBMS_OUTPUT. put_line ('That''s a really funny ''joke''. '); END; BEGIN DBMS_OUTPUT. PUT_LINE ( q''); END; Links livesql. oracle. com --- - Published: 2024-08-23 - Modified: 2026-05-02 - URL: https://ultimasolution.pl/add-axis-in-tree-js/ - Categories: js The addAxis() method in Three.js adds a visual representation of the 3D coordinate axes (X, Y, Z) to the scene, along with corresponding labels to help users identify the orientation of the space. The `addAxis` method adds a visual representation of the 3D coordinate axes to the scene, along with corresponding labels ("X", "Y", "Z") placed at the ends of each axis. This helps users easily identify the orientation of the 3D space. Three. js addAxis Method Description The addAxis method is responsible for adding a visual representation of the coordinate axes (X, Y, Z) to a 3D scene using Three. js. Here's a breakdown of the method: 1. Adding the Axes Helper The method begins by creating an instance of THREE. AxesHelper with a size of 35 units. This helper is a built-in utility in Three. js that visually represents the three coordinate axes: X-axis (usually red) Y-axis (usually green) Z-axis (usually blue) The axesHelper is then added to the scene using this. scene. add(axesHelper). 2. Loading the Font The method loads a font using the FontLoader from Three. js. The font file is located in the specified path and is loaded asynchronously. Once the font is loaded, a callback function is triggered to create text labels for the axes. 3. Creating Text Labels Within the callback function, a text material is created using THREE. MeshBasicMaterial with a white color (0xffffff). A helper function, createTextMesh, is defined to generate 3D text meshes: Text Geometry: The function takes in a text string and a position vector. It creates a 3D text geometry using the loaded font, with a size of 4 units and a depth of 1 unit. Text Mesh: A mesh is... --- - Published: 2023-10-29 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/3d-inventory-api/ - Categories: 3d-inventory, applications, recent - Tags: api, mongo Build a 3D inventory API with the MEAN stack. This guide uses Node.js & MongoDB to create a backend for spatial inventory management. 3d-inventory-mongo-api 3d-inventory-mongo-api Purposes Architecture Features MEAN stack Data Model API documentation Getting Started License About Backend API for the 3D-Inventory platform — a modern inventory management system that combines spatial visualization with structured inventory data. This Node. js-based API uses MongoDB as its primary database and serves inventory data to a frontend interface built in 3d-inventory. Features RESTful API for managing inventory elements, racks, rooms, and objects MongoDB schema designed for spatial and visual representation of inventory items Modular structure using Express. js Secure API endpoints with basic validation Designed to support 3D spatial UI representation in real-time MEAN stack MongoDB is a NoSQL database that stores data in JSON format. Express. js is a web application framework for Node. js that simplifies the process of building web servers and APIs. RxJs - Reactive Extensions Library for JavaScript. NodeJS is a JavaScript runtime that allows you to run code on the server-side. API Endpoints Swagger API definition. Endpoint Method Description /devices GET Get all devices /devices POST Create a new device /devices/ GET Get device by ID /devices/ PUT Update device by ID /devices/ DELETE Delete device by ID /models GET Get all models /models POST Create a new model /models/ GET Get model by ID /models/ PUT Update model by ID /models/ DELETE Delete model by ID /connections GET Get all connections /connections POST Create a new connection /connections/ GET Get connection by ID /connections/ PUT Update connection by ID /connections/ DELETE Delete connection by ID /logs GET Get... --- - Published: 2023-02-18 - Modified: 2026-05-09 - URL: https://ultimasolution.pl/data-center-inventory-ui/ - Categories: 3d-inventory, applications, js, recent - Tags: mongo, project The 3D Inventory Angular UI is a comprehensive front end application designed to create spatial and database representations of warehouses and data centers. This project serves as a practical sandbox for exploring database systems while building an efficient platform for graphical IT inventory management. The application combines interactive 3D visualization, typed Angular services, and audit-focused administration features for day-to-day inventory work. 3Data Center Inventory Software Project Overview and Purpose The Data Center Inventory Angular UI is a comprehensive front-end application designed to create spatial and database representations of warehouses and data centers. This project serves as a practical sandbox for exploring database systems while building an efficient platform for graphical IT inventory management. The application leverages modern web technologies to provide interactive 3D visualization combined with robust data management capabilities. Demo Data Model Philosophy The data model employs a unique parametric, generic attribute class approach. Rather than rigid table structures, all attributes for Devices, Models, and Connections are stored flexibly in this model. The system uses an Attribute Dictionary to define parameter types, which then govern how values are stored and validated. This design provides significant flexibility while maintaining data integrity. Technology stack The application is built on Angular 20. 3+ using the modern standalone component architecture, which eliminates the need for traditional NgModules and simplifies the application structure. For the user interface, it employs Bootstrap 5. 3+ to ensure responsive design across different devices. The standout feature is the integration of three. js 163+, an advanced 3D graphics library that powers the interactive spatial visualization of inventory items. Security is enhanced through Google reCAPTCHA v3, which provides invisible, score-based bot protection without disrupting the user experience. The backend supports both MongoDB Atlas and Oracle databases, demonstrating flexibility in handling both NoSQL and relational data models. All communication happens through a well-documented REST API using Swagger/OpenAPI specifications. The entire stack is... --- - Published: 2022-03-05 - Modified: 2026-03-28 - URL: https://ultimasolution.pl/sql-partition-by-date-keeping-weekly-and-sub-partition/ - Categories: sql - Tags: oracle Learn to partition huge SQL tables by date weekly and sub-partition alphabetically by station name. A practical guide for Oracle. Partition by date keeping weekly and sub partition by station name alphabetically for huge records in separate sub partition. PARTITION BY RANGE (CREATED_DATE) INTERVAL (numtodsinterval(7, 'DAY')) SUBPARTITION BY RANGE(STATION) SUBPARTITION TEMPLATE ( SUBPARTITION SUB_PART_A VALUES LESS THAN ('B%'), SUBPARTITION SUB_PART_B VALUES LESS THAN ('C%'), SUBPARTITION SUB_PART_C VALUES LESS THAN ('D%'), SUBPARTITION SUB_PART_D VALUES LESS THAN ('E%'), SUBPARTITION SUB_PART_E VALUES LESS THAN ('F%'), SUBPARTITION SUB_PART_F VALUES LESS THAN ('G%'), SUBPARTITION SUB_PART_G VALUES LESS THAN ('H%'), SUBPARTITION SUB_PART_H VALUES LESS THAN ('I%'), SUBPARTITION SUB_PART_I VALUES LESS THAN ('J%'), SUBPARTITION SUB_PART_J VALUES LESS THAN ('K%'), SUBPARTITION SUB_PART_K VALUES LESS THAN ('L%'), SUBPARTITION SUB_PART_L VALUES LESS THAN ('M%'), SUBPARTITION SUB_PART_M VALUES LESS THAN ('N%'), SUBPARTITION SUB_PART_N VALUES LESS THAN ('O%'), SUBPARTITION SUB_PART_O VALUES LESS THAN ('P%'), SUBPARTITION SUB_PART_P VALUES LESS THAN ('Q%'), SUBPARTITION SUB_PART_Q VALUES LESS THAN ('R%'), SUBPARTITION SUB_PART_R VALUES LESS THAN ('S%'), SUBPARTITION SUB_PART_S VALUES LESS THAN ('T%'), SUBPARTITION SUB_PART_T VALUES LESS THAN ('U%'), SUBPARTITION SUB_PART_U VALUES LESS THAN ('V%'), SUBPARTITION SUB_PART_V VALUES LESS THAN ('W%'), SUBPARTITION SUB_PART_W VALUES LESS THAN ('X%'), SUBPARTITION SUB_PART_X VALUES LESS THAN ('Y%'), SUBPARTITION SUB_PART_Y VALUES LESS THAN ('Z%'), SUBPARTITION SUB_PART_Z_0_9 VALUES LESS THAN (MAXVALUE) ) ( PARTITION OLD_PART_DATA VALUES LESS THAN (TO_DATE('01-AUG-2018', 'dd-mon-yyyy')) ); --- - Published: 2020-11-04 - Modified: 2026-03-28 - URL: https://ultimasolution.pl/timestamp-display-in-alv/ - Categories: abap - Tags: abap, ALV, sap The provided text contains information and code related to working with timestamps and formatting them for display in an ALV (ABAP List Viewer) table. Here's a breakdown of the key points: Timestamp Format Transformation: The text begins with a description of a timestamp represented as '20,201,004,223,429' and the desire to format it as '2020-10-04 22:34'. This indicates a need to transform the timestamp from one format to another for better presentation. ABAP Code: The code section titled "FORM modify_fieldcat" shows a piece of ABAP code that is likely part of an ABAP program. It appears to be working with field catalog entries for an ALV display. In this code, a specific field with the name 'TIMESTAMP' is being modified. The modifications include setting the field as non-editable ('-edit = ' ''), indicating it's a column option ('-col_opt = 'X''), and specifying an edit mask for formatting ('-edit_mask = '____-- :''). Timestamp Conversion: The text also provides information about converting date and time into a timestamp and vice versa. It mentions that you can convert date and time into a timestamp using the 'CONVERT DATE' syntax and split a timestamp into date and time using the 'CONVERT TIME STAMP' syntax. This is useful for scenarios where you need to work with both date/time and timestamps. In summary, the text is primarily focused on formatting timestamps for display in an ALV table, and it includes relevant ABAP code for modifying field catalog entries to achieve the desired formatting. Additionally, it provides information about how to convert between date/time and timestamps when needed in ABAP programming. In ABAP, when displaying a timestamp in an ALV (ABAP List Viewer), you typically use the CL_SALV_TABLE or REUSE_ALV_GRID_DISPLAY functions to present data, including timestamp fields. The timestamp field is often stored in the TIMESTAMP or TIMESTAMPL format (CHAR type with length 14 or 21 respectively). To display it properly in an ALV, you can use formatting options or convert it into a readable format. Here's how you can display a timestamp in ALV Example using CL_SALV_TABLE: DATA: lt_data TYPE TABLE OF ztable, " Replace ztable with your table lr_alv TYPE REF TO cl_salv_table, lt_fieldcatalog TYPE salv_t_fieldcat_alv. " Select data from your table with timestamp fields SELECT * FROM ztable INTO TABLE lt_data. " Create the ALV instance cl_salv_table=>factory( IMPORTING r_salv_table = lr_alv CHANGING t_table = lt_data ). " Optionally, format the timestamp field to be more readable DATA: ls_columns TYPE REF TO cl_salv_columns_table, ls_column TYPE REF TO cl_salv_column. ls_columns = lr_alv->get_columns. " Get the timestamp field for formatting ls_column = ls_columns->get_column( 'TIMESTAMP_FIELD' ). " Replace with actual field name " Set output length (if required) and other properties ls_column->set_output_length( 21 ). " Display the ALV lr_alv->display. Example using REUSE_ALV_GRID_DISPLAY: DATA: lt_data TYPE TABLE OF ztable, " Replace ztable with your table lt_fieldcatalog TYPE slis_t_fieldcat_alv, ls_fieldcatalog TYPE slis_fieldcat_alv. " Select data with timestamp fields SELECT * FROM ztable INTO TABLE I have a time stamp which is displayed as '20,201,004,223,429'. I want to show this in ALV formatted as '2020-10-04 22:34'. FORM modify_fieldcat. LOOP AT i_fieldcat ASSIGNING . CASE -fieldname.... --- - Published: 2020-10-06 - Modified: 2026-03-28 - URL: https://ultimasolution.pl/sap-abap-update-infotype-1000/ - Categories: abap - Tags: abap, sap A guide to updating HR infotypes in SAP ABAP. Get the code to read, modify, and write data using core function modules. Read the infotype 1000 data DATA: lt_p1000 TYPE TABLE OF p1000, lv_p1000 LIKE LINE OF lt_p1000, lv_object TYPE hrobject. CALL FUNCTION 'RH_READ_INFTY_1000' EXPORTING plvar = lv_object-plvar otype = lv_object-otype objid = lv_object-objid begda = sy-datum endda = sy-datum TABLES i1000 = lt_p1000 Modify the name in infotype lv_p1000-stext = lv_stext_new. MODIFY lt_p1000 FROM lv_p1000. Update the infotype in buffer CALL FUNCTION 'RH_UPDATE_INFTY' EXPORTING vtask = 'B' "Buffer commit_flg = ' ' authy = 'X' workf_actv = ' ' TABLES innnn = lt_p1000. After all changes are made, write update to the DB CALL FUNCTION 'RH_UPDATE_DATABASE' EXPORTING vtask = 'S' workf_actv = ' '. How to correct endda rhgrenz4 SUBMIT rhgrenz4 AND RETURN "VIA SELECTION-SCREEN WITH pchplvar EQ '01' WITH pchotype EQ 'C' WITH pchobjid EQ lo_limit_notuse->cwa_notuse-objid WITH pchistat EQ '1' WITH pchobeg EQ defaultbegda WITH pchoend EQ defaultendda WITH pchbegda EQ defaultbegda WITH pchendda EQ defaultendda WITH g_dat EQ sel_endda WITH new_end EQ dsl_endda WITH test EQ 'X' WITH anzeige EQ 'X'. We have brand-new report rhgrenz4 --- - Published: 2020-04-24 - Modified: 2026-04-06 - URL: https://ultimasolution.pl/how-to-youtube-dl/ - Categories: No Category EN: Install youtube-dl on Linux/macOS/Win. Learn to download videos & playlists. PL: Zainstaluj youtube-dl na Linux/macOS/Win. Pobieraj filmy i playlisty. INSTALLATION To install it right away for all UNIX users (Linux, macOS, etc. ), type: sudo curl -L https://yt-dl. org/downloads/latest/youtube-dl -o /usr/local/bin/youtube-dl sudo chmod a+rx /usr/local/bin/youtube-dl If you do not have curl, you can as an option use a recent wget: sudo wget https://yt-dl. org/downloads/latest/youtube-dl -O /usr/local/bin/youtube-dl sudo chmod a+rx /usr/local/bin/youtube-dl Windows users can download an . exe file and place it in any location on their PATH except for %SYSTEMROOT\%System32 (e. g. do not put in C:\Windows\System32). You can also use pip: sudo -H pip install --upgrade youtube-dl This command will update youtube-dl if you have already installed it. See the pypi page for more information. sudo port install youtube-dl Alternatively, refer to the developer instructions for how to check out and work with the git repository. For further options, including PGP signatures, see the youtube-dl Download Page. CONFIGURATION You can configure youtube-dl by placing any supported command line option to a configuration file. On Linux and macOS, the system wide configuration file is located at /etc/youtube-dl. conf and the user wide configuration file at ~/. config/youtube-dl/config. On Windows, the user wide configuration file locations are %APPDATA%\youtube-dlconfig. txt or C:\Users\\youtube-dl. conf. Note that by default configuration file may not exist so you may need to create it yourself. For example, with the following configuration file youtube-dl will always extract the audio, not copy the mtime, use a proxy and save all videos under Movies directory in your home directory: # Lines starting with # are comments # Always extract... --- - Published: 2019-12-28 - Modified: 2026-03-28 - URL: https://ultimasolution.pl/traveling-on-paths-that-have-heart/ - Categories: life - Tags: quote (EN) I only travel paths with heart, walking them fully and breathlessly. (PL) Podróżuję tylko ścieżkami z sercem, przechodząc je w całości i bez tchu. “For me there is only the traveling on paths that have heart, on any path that may have heart, and the only worthwhile challenge is to traverse its full length -- and there I travel looking, looking breathlessly. ” --- - Published: 2019-01-03 - Modified: 2026-04-06 - URL: https://ultimasolution.pl/alonefold/ - Categories: life - Formats: Audio Alonefold is the musical project of Australian artist and composer Scott Ashton Beardow. His works blend a mixture of experimental synthesizer music, acoustic recordings and multi layered soundscapes. spotify bandcamp soundcloud --- - Published: 2018-11-14 - Modified: 2026-04-06 - URL: https://ultimasolution.pl/log-errors-oralces-dml/ - Categories: sql - Tags: oracle, sql - Formats: Link This PL/SQL block dynamically creates and populates a table based on a SELECT statement, while using Oracle's DBMS_ERRLOG package to handle any runtime errors during the INSERT operation. Very powerfully and simple solution for 10g+ database. This script is useful for data migration or transformation tasks where some records may fail due to data quality issues, but you want the process to continue for the rest. The failed records and their error reasons are saved for review, without halting the whole insert operation. Would you like an example of how the ERR$_ table looks or how to query it for logged errors? DECLARE l_sql_statement VARCHAR2(30000) := ' SELECT emp. * ,sal / comm sal_to_comm_ratio FROM scott. emp emp '; l_create_table_sql VARCHAR2(32767); l_insert_table_sql VARCHAR2(32767); l_table_name VARCHAR2(30) := 'XXERR_TEST'; l_error_table_name VARCHAR2(30) := 'ERR$_' || l_table_name; BEGIN l_create_table_sql := 'CREATE TABLE ' || l_table_name || ' AS SELECT * FROM (' || l_sql_statement || ') WHERE 1=2'; EXECUTE IMMEDIATE l_create_table_sql; dbms_errlog. create_error_log(dml_table_name => l_table_name); l_insert_table_sql := 'INSERT INTO ' || l_table_name || ' SELECT * FROM (' || l_sql_statement || ') LOG ERRORS INTO err$_' ||l_table_name || ' (''INSERT'') REJECT LIMIT UNLIMITED'; EXECUTE IMMEDIATE l_insert_table_sql; dbms_output. put_line('Error Messages are stored in table ' || l_error_table_name); END;   Source: Run Library Script: https://livesql. oracle. com/apex/livesql/file/content_DKGPNGUHVKH7JRGJ1TWPDGIGP. html --- - Published: 2018-03-03 - Modified: 2026-03-28 - URL: https://ultimasolution.pl/budda-nie-byl-masochista/ - Categories: life - Tags: quote Mandżuśri, figlarny uczeń Siddharthy, poddał próbę mnicha medytującego nad brzydotą, przemieniając się w piękną nimfę. Mnich, choć długo opierał się pokusie, w końcu uległ. Gdy odkrył, że nimfa była iluzją, Mandżuśri wyjaśnił, że zarówno piękno, jak i brzydota to jedynie koncepcje, które zniewalają umysł. Siddhartha miał świeckiego ucznia, wojownika o imieniu Mandżuśri, znanego dowcipnisia i figlarza. Jednym ze współtowarzyszy Mandżuśriego był pewien bardzo sumienny i szanowany mnich, znany z „medytowania nad brzydotą” – metody zalecanej tym, których przepełnia pożądanie i namiętność. Medytacja tego rodzaju polega na wyobrażaniu sobie, że wszystkie istoty składają się z żył, chrząstek, jelit i tak dalej. Mandżuśri, wykorzystując swoje nadprzyrodzone moce, postanowił poddać sumiennego mnicha próbie. Zmienił się w piękną nimfę i pojawił przed medytującym, aby go uwieść. Przez pewien czas poczciwy mnich pozostawał niewzruszony, trwając w całkowitym bezruchu. Jednak powab Mandżuśrego okazał się nieodparty i mnich powoli zaczął ulegać. Był bardzo zaskoczony, ponieważ w ciągu wielu lat medytacji z powodzeniem opierał się najpiękniejszym kobietom w okolicy. W końcu zdruzgotany i rozczarowany sobą, umknął. Nimfa rzuciła się w pogoń i ścigała go, aż wyczerpany ucieczką padł na ziemię. Kiedy zaczęła się zbliżać, mnich pomyślał: „Już po mnie. Ta piękna dziewczyna zaraz mnie porwie w ramiona”. Zacisnął powieki i czekał, ale nic się nie wydarzyło. Gdy wreszcie otworzył oczy, urodziwa nimfa rozpadła się na kawałki, a na jej miejscu ukazał się roześmiany Mandżuśri. „Myślenie, że ktoś jest piękny, to tylko koncepcja – powiedział. – Lgnięcie do tej koncepcji ogranicza cię, krępuje, więzi. Ale jeśli myślisz, że ktoś jest brzydki, to także tylko koncepcja, która cię zniewala”. Source: Dzongsar Kjence Rinpocze: Budda nie był masochistą – Portal Buddyjski --- - Published: 2017-12-17 - Modified: 2026-03-28 - URL: https://ultimasolution.pl/real-death-precious-life/ - Categories: life - Tags: quote Death is real and can come at any moment. Don't waste your life. True purpose comes from self-realization and inner practice. Dla zwykłego człowieka śmierć jest czymś realnym i może przyjść w każdej chwili, bez ostrzeżenia. Marnowanie swego cennego ludzkiego życia w trakcie banalnych zajęć jest tragedią. Jedynie praktyka prowadzi do własnego urzeczywistnienia i wyłącznie poprzez swą własną realizację można ostatecznie pomóc innym, przejawiając zdolności prowadzenia ich tak, aby sami osiągnęli taki sam stan. Jakakolwiek pomoc materialna, którą możemy ofiarować, jest zawsze tylko czymś prowizorycznym. Aby móc pomagać innym, trzeba zacząć od pomagania samemu sobie, bez względu na to, jak paradoksalnie może to brzmieć. Aby doliczyć do miliona, trzeba zacząć od jedynki. Tak samo, aby pomóc społeczeństwu, trzeba zacząć od pracy nad samym sobą. Każda jednostka powinna w pełni ponosić odpowiedzialność za siebie, co można osiągnąć wyłącznie poprzez pracę nad poszerzeniem własnej świadomości, aby stać się w coraz pełniejszym stopniu uważnym, by coraz bardziej być mistrzem samego siebie. ― Kryształ i ścieżka światła - Namkhai Norbu Rinpocze --- - Published: 2017-12-10 - Modified: 2026-03-28 - URL: https://ultimasolution.pl/plsql-procedure-name-exception/ - Categories: plsql - Tags: oracle, plsql Build a generic PL/SQL exception handler using `owa_util.get_procedure` to easily identify the source of an error in your Oracle code. In 10g and 11g I use the "owa_util. get_procedure" function. I normally use this in packages as it will also return the name of an internal procedure or function as part of the package name, i. e. (package_name). (procedure name). I use this to provide a generic EXCEPTION template for identifying where an exception occurred. CREATE OR REPLACE procedure some_procedure is v_procedure_name varchar2(32); begin v_procedure_name := owa_util. get_procedure; end; CREATE OR REPLACE PACKAGE some_package AS FUNCTION v_function_name RETURN DATE; END; / CREATE OR REPLACE PACKAGE BODY some_package AS FUNCTION v_function_name RETURN DATE IS BEGIN RETURN SYSDATE; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT. PUT_LINE('ERROR IN '||owa_util. get_procedure); DBMS_OUTPUT. PUT_LINE(SQLERRM); END; END; / Source: https://stackoverflow. com/questions/286549/find-out-name-of-pl-sql-procedure#286569 alter session set plscope_settings='identifiers:all' / Session altered. SQL> set serverout on SQL> create or replace package pkg as procedure p1; procedure p2; end pkg; / Package created. SQL> create or replace package body pkg as procedure get_scope (obj varchar2, line int) as begin for c in (select rpad (lpad (' ', 2 * (level - 1)) || name, 20, '. ') || ' ' || rpad (type, 20) || rpad (usage, 20) identifier_usage_contexts from user_identifiers t where level ! = 1 start with line = get_scope. line and object_name = obj connect by usage_id = prior usage_context_id) loop dbms_output. put_line (c. identifier_usage_contexts); end loop; end get_scope; procedure p1 as begin null; end p1; procedure p2 as begin get_scope ($$plsql_unit, $$plsql_line); end p2; end pkg; Return information about witch module call this code. CREATE OR REPLACE FUNCTION MIBP_OWNER.... --- - Published: 2017-11-18 - Modified: 2026-03-28 - URL: https://ultimasolution.pl/plsql-cursors-exception-handling/ - Categories: plsql, sql - Tags: data, plsql, sql Learn to efficiently check if a record exists in PL/SQL using cursors, exception handling, and REF CURSOR with practical code examples. Here we are common problem in PLSQL. We try find answer for one common question in programing databases. Is the specyfic record exist in other table or not exist? Some examples below show how to menage this problem: DECLARE VAR_SUPP_NM VARCHAR2(100); VAR_SUPP_ID NUMBER := 1; WHILE_VAR CHAR := 'Y'; BEGIN SELECT SUPP_NM INTO VAR_SUPP_NM FROM TEST. SUPPLIER WHERE SUPP_ID = VAR_SUPP_ID; DBMS_OUTPUT. PUT_LINE('DATA FOUND'); exception when no_data_found then -- here some code when data ont exist DBMS_OUTPUT. PUT_LINE('SQL DATA NOT FOUND'); END; / In line 11 and 14 we have place to insert own code. Other solution we found when we use define explicit cursor: CREATE FUNCTION f_get_name (ip_emp_id IN NUMBER) RETURN VARCHAR2 AS CURSOR c IS SELECT ename FROM emp WHERE emp_id = f_get_name. ip_emp_id; lv_ename emp. ename%TYPE; BEGIN OPEN c; FETCH c INTO lv_ename; IF (SQL%NOTFOUND) THEN RAISE NO_DATA_FOUND; ENDIF; FETCH c INTO lv_ename; IF (SQL%FOUND) THEN RAISE TOO_MANY_ROWS; ENDIF; CLOSE c; RETURN lv_ename; END; / CREATE OR REPLACE PROCEDURE refresh_store_feed AS TYPE prod_array IS TABLE OF store_products%ROWTYPE INDEX BY BINARY_INTEGER; l_prod prod_array; CURSOR c IS SELECT product FROM listed_products@some_remote_site; BEGIN OPEN C; LOOP FETCH C BULK COLLECT INTO l_prod LIMIT 100; FOR i IN 1 . . l_csi. COUNT LOOP /* ... do some procedural code here that cannot be done in SQL to l_csi(i) ... */ END LOOP; FORALL i IN 1 . . l_csi. COUNT INSERT INTO store_products (product) VALUES (l_prod(i)); EXIT WHEN c%NOTFOUND; END LOOP; CLOSE C; END; / REF Cursors in Brief Though... --- - Published: 2017-09-14 - Modified: 2026-04-10 - URL: https://ultimasolution.pl/oracle-clob-search-string/ - Categories: sql - Tags: data, database, find, oracle, plsql, sql, tables Learn to search for a string in an Oracle CLOB column. This guide covers the best SQL methods to find, update, and replace large text data. Clobs Not many tables demand the use of CLOBs (Character Large Objects). CLOB data type columns can store up to 4 GB of text. When designing a new application, developers face a dilemma – I need a column where I need to store a large block of text. Should I use multiple VARCHAR2 columns or CLOB? ×VARCHAR2 Variable-length character string having maximum length size bytes or characters. You must specify size for VARCHAR2. Minimum size is 1 byte or 1 character. Maximum size is: 32767 bytes or characters if MAX_STRING_SIZE=EXTENDED or 4000 bytes or characters if MAX_STRING_SIZE=STANDARD. Close The decision to use VARCHAR2 instead of CLOB is usually driven by the fear of the unknown. One should always use CLOB when it comes to deciding about multiple VARCHAR2 columns vs. CLOB to store a single logical piece of textual data. Example use string in Oracle CLOB column: create table aTable( id number, aClobColumn clob ); insert into aTable values (1,'value' ); insert into aTable values (1,'values are like this' ); select * from aTable where dbms_lob. substr( aClobColumn , 4000, 1 )='value'; Source, try it online: http://sqlfiddle. com/#! 4/1878f6/164 Accessing a CLOB as a VARCHAR2 in PL/SQL The following example illustrates the way CLOB manage. Length of CLOB declare myStoryBuf VARCHAR2(4001); BEGIN SELECT ad_sourcetext INTO myStoryBuf FROM print_media WHERE ad_id = 12001; -- Display Story by printing myStoryBuf directly END; / Assigning a CLOB to a VARCHAR2 in PL/SQL declare myLOB CLOB; BEGIN SELECT 'ABCDE' INTO myLOB FROM print_media WHERE... --- - Published: 2016-02-04 - Modified: 2026-04-06 - URL: https://ultimasolution.pl/oracle-unique-session-id/ - Categories: sql - Tags: oracle, plsql, sql Learn two ways to get a unique session ID in Oracle. Use the DBMS_SESSION function in PL/SQL or query the v$session view directly. The UNIQUE_SESSION_ID function returns a character string unique to the session among all sessions currently connected to the database. The return string can be up to 24 bytes in length. Multiple calls to the function from the same session will always return the same string. The program header follows: FUNCTION DBMS_SESSION. UNIQUE_SESSION_ID RETURN VARCHAR2; Notes UNIQUE_SESSION_ID is functionally identical to the DBMS_PIPE. UNIQUE_SESSION_NAME function; however, their return values are not identical. Be very careful not to write code that assumes that these two functions are equivalent. The UNIQUE_SESSION_ID function does not raise any exceptions. Example To display the value of the unique id for the current session, specify the following: DECLARE my_unique_id VARCHAR2(30); BEGIN my_unique_id := DBMS_SESSION. UNIQUE_SESSION_ID; DBMS_OUTPUT. PUT_LINE('UNIQUE ID: '||my_unique_id); END; An example of output from executing the preceding PL/SQL block follows: UNIQUE ID: F000E4020000 Source: https://www. toadworld. com/platforms/oracle/w/wiki/3246. dbms-session-unique-session-id When you have problem receive information about session in Oracle PLSQL database for example purposes journalling. Look bellow on SQLs witch rewrite two or more rows: SELECT * FROM v$session s WHERE username IS NOT NULL AND s. AUDSID = SYS_CONTEXT ('userenv', 'sessionid') ORDER BY username, osuser; You need add two condition to receive one row. WHERE username IS NOT NULL AND s. AUDSID = SYS_CONTEXT ('userenv', 'sessionid') AND S. SID = SYS_CONTEXT ('userenv', 'sid') Final query return unique session row: SELECT * FROM v$session s WHERE username IS NOT NULL AND s. AUDSID = SYS_CONTEXT ('userenv', 'sessionid') AND S. SID = SYS_CONTEXT ('userenv', 'sid') ORDER BY username,... --- - Published: 2015-12-30 - Modified: 2026-04-06 - URL: https://ultimasolution.pl/cellular-automaton-c-code/ - Categories: No Category - Tags: html, life, project Learn to implement a Cellular Automaton in C. This guide covers Brian's Brain rules, the Moore neighborhood, and a C code walkthrough. Cellular automata and Moore neighborhood Cellular automaton (CA) is by definition a periodic grid of cells, where in each cell sits a finite automaton, and a set of (identical) rules for every such automaton describing to which state it switches on a next moment of discrete time ti+1, depending of its own state and states of all its neighbors on a current moment of time ti. For now, we will be interested in 2d, rectangular CA, and a neighborhood which includes 8 neighbors of the cell. This is what is called the Moore neighborhood, because it was invented by Edward Moore. Rules Brain http://zvold. blogspot. com/2010/01/conways-life-and-brians-brain-cellular. html Each cell has three possible states: passive, active, and semi-active. If a cell is active, it goes to semi-active state on the next step If a cell is semi-active, it becomes passive on the next step If a cell is passive, it becomes active if and only if it has exactly 2 active neighbors Materials http://meil. pw. edu. pl/za/ZA/Dydaktyka/Informatyka-1 https://en. wikipedia. org/wiki/Cellular_automaton GitHub git clone git@bitbucket. org:snippets/karol-preiskorn/E8e4L/brians-brain. git Source /** * Brian's Brain * * Rules: * ------- * Each cell has three possible states: passive, active, and semi-active. * If a cell is active, it goes to semi-active state on the next step * If a cell is semi-active, it becomes passive on the next step * If a cell is passive, it becomes active if and only if it has exactly 2 active neighbors * **/ #include #include #include #include #include... --- - Published: 2015-12-12 - Modified: 2026-04-06 - URL: https://ultimasolution.pl/java-class-constructor-example/ - Categories: java - Tags: exercises Explore Java dedicated constructors with a practical code example. Learn to declare a class, initialize fields, and create objects. Przykład na dedykowany konstruktor Zadeklaruj klasę Sloik zawierającą pole Dzem dzem, dedykowany konstruktor inicjujący wszystkie zadeklarowane pola i metody: otworz zamknij czyOtwarty Następnie utwórz obiekt klasy Sloik i napełnij go wybranym rodzajem dżemu, operacje powtórz dla wszystkich rodzajów dżemów. Uwaga: nakładanie dżemu do zamkniętego słoika lub pozostawienie słoika nie zamkniętego może prowadzić do zepsucia się produktu! Oryginał zadnia Zadeklaruj klasę Dzem zawierająca prywatne pola: String smak, double waga Utwórz konstruktory przyjmujące jako parametry zmienne: (String smak, double waga), (double waga), (String smak). Dostarczone parametry konstruktorów powinny znacjonalizować pola klasy. W przypadku gdy konstruktor nie dostarcza niezbędnego parametru należny przyjąć, ze pole smak musi przyjąć wartość “No name”, natomiast waga – 100. 0. Przedstaw wykorzystanie wszystkich konstruktorów tworząc obiekty reprezentujące co najmniej trzy rodzaje dżemów. Uwaga: należny założyć, ze tylko konstruktor z dwoma parametrami możne przypisać wartości polom klasy. Zadanie trochę zmodyfikowane Zadeklaruj klasę Sloik zawierająca pole Dzem dzem (lub konstruktor klasy pochodnej), dedykowany konstruktor inicjujący wszystkie zadeklarowane pola i metody: otworz zamknij czyOtwarty napełnijSloik Wymagane pola: klasa Dzem Następnie utwórz obiekt klasy Sloik i napełnij go wybranym rodzajem Dzem. Resources czyli od czego zacząć https://docs. oracle. com/javase/tutorial/java/javaOO/constructors. html o konstruktorach na stronie Oracle Java. https://docs. oracle. com/javase/tutorial/java/javaOO/arguments. html argumenty w konstruktorach. class Programming { //constructor method Programming { System. out. println("Constructor method called. "); } public static void main(String args) { Programming object = new Programming; // Creating an object } } class Language { String name; Language { System. out. println("Constructor method called. "); } Language(String t) { name... --- - Published: 2015-11-18 - Modified: 2026-04-06 - URL: https://ultimasolution.pl/oracle-plsql-bulk-optimization/ - Categories: plsql - Tags: data, oracle, plsql, sql Boost Oracle PL/SQL performance with Bulk Processing. Learn how BULK COLLECT and FORALL speed up data retrieval and DML operations. Bulk Processing with BULK COLLECT and FORALL· BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed of data retrieval· FORALL: INSERTs, UPDATEs, and DELETEs that use collections to change multiple rows of data very quicklyPL/SQL is so tightly integrated with the SQL language, you might be wondering why special features would be needed to improve the performance of SQL statements inside PL/SQL. The explanation has everything to do with how the runtime engines for both PL/SQL and SQL communicate with each other—through a context switch.   Source: Mukesh K Suthar on Oracle PL/SQL: Bulk Processing with BULK COLLECT and FORALL BULK COLLECT Bulk binds can improve the performance when loading collections from a queries. The BULK COLLECT INTO construct binds the output of the query to the collection. To test this create the following table. CREATE TABLE bulk_collect_test AS SELECT owner, object_name, object_id FROM all_objects; The following code compares the time taken to populate a collection manually and using a bulk bind. SET SERVEROUTPUT ON DECLARE TYPE t_bulk_collect_test_tab IS TABLE OF bulk_collect_test%ROWTYPE; l_tab t_bulk_collect_test_tab := t_bulk_collect_test_tab; l_start NUMBER; BEGIN -- Time a regular population. l_start := DBMS_UTILITY. get_time; FOR cur_rec IN (SELECT * FROM bulk_collect_test) LOOP l_tab. extend; l_tab(l_tab. last) := cur_rec; END LOOP; DBMS_OUTPUT. put_line('Regular (' || l_tab. count || ' rows): ' || (DBMS_UTILITY. get_time - l_start)); -- Time bulk population. l_start := DBMS_UTILITY. get_time; SELECT * BULK COLLECT INTO l_tab FROM bulk_collect_test; DBMS_OUTPUT. put_line('Bulk (' || l_tab. count || ' rows):... --- ---