Generated by All in One SEO v4.9.0, this is an llms.txt file, used by LLMs to index the site. # Ennicode - Your Guide to Software Engineering Ennicode ## Sitemaps - [XML Sitemap](https://www.ennicode.com/sitemap.xml): Contains all public & indexable URLs for this website. ## Posts - [Blog](https://www.ennicode.com/blog/) - [Top 20 SQL Performance Tuning New Tips](https://www.ennicode.com/sql-performance-tuning/) - SQL performance tuning is a BIG Topic on Databases, and that is not theoretical all the time. It’s a practical thing that must be handled case by case. - [LEFT JOIN in SQL – Ultimate Guide Including Performance Tips & FAQs (Updated)](https://www.ennicode.com/left-join-in-sql/) - Once you are doing relational databases, LEFT JOIN in SQL is essential for data merging, binding, and manipulating. LEFT JOIN allows you to merge multiple table - [Best 13 Simple Tips to Performance Tuning in Oracle](https://www.ennicode.com/tips-to-performance-tuning-in-oracle/) - This is related to simple tips for Performance Tuning in Oracle. But those tips may have a huge effect on big databases that have millions of records in a table - [SQL DECLARE Variable: Complete Guide | Examples in All 5 Databases](https://www.ennicode.com/sql-declare-variable/) - Variables are the heart of SQL programming and the most powerful tools inside SQL programming. SQL DECLARE Variable allows you to store data temporarily - [How to Check SQL Version (Any Database 7 Examples)](https://www.ennicode.com/check-sql-version/) - Learn how to check SQL Version in Oracle, MySQL, SQL Server, PostgreSQL, SQLite, and more, with a guide including commands, examples, and explanations. - [COALESCE SQL – Full Guide with Real Examples (All Databases)](https://www.ennicode.com/coalesce-sql/) - COALESCE SQL: The COALESCE function looks for the first non-null value from the expression. Once the database reaches a non-null value, stop the traverse - [how to use Common Table Expression | Hidden power in SQL](https://www.ennicode.com/common-table-expression/) - In this article, I plan to describe what a common table expression is, and how to write sql common table expressions in database programming languages. - [How to oracle SQL limit rows? 6 ways](https://www.ennicode.com/oracle-sql-limit-rows/) - In SQL, there are several ways to oracle SQL limit rows. Limiting rows or selecting the top-most record improves the performance of the query. - [How to Understand Oracle Index Unique Scan](https://www.ennicode.com/oracle-index-unique-scan/) - If the table has primary keys then you can scan through the unique index. oracle index unique scan stops the scanning process once the first record is found. - [2 Reasons to Why Oracle Index Full Scan](https://www.ennicode.com/oracle-index-full-scan/) - An Oracle index full scan is Oracle start read block from ROOT and then navigating to the down branch until find the leaf block on the left side. - [What is Full Table Scan in Oracle | Quick Guide](https://www.ennicode.com/what-is-full-table-scan-in-oracle/) - What is Full Table Scan in Oracle? Simply it reads all the rows in the table. If you have a Where condition, then filter records according to that. - [How to work Oracle Table Access by Index Rowid](https://www.ennicode.com/oracle-table-access-by-index-rowid/) - Before explaining Oracle table access by index rowid, I would like to explain a bit about what is rowid and how it is used in the Oracle database. - [What is Explain Plan in Oracle | Simple Explain](https://www.ennicode.com/explain-plan-in-oracle/) - Explain plan in Oracle is the sequence of operations for a statement that is chosen by the Oracle optimizer. This is the flow of execution of a statement. - [How to run hash join in Oracle. 3 min Quick Guide](https://www.ennicode.com/hash-join-in-oracle/) - Oracle Uses this merging mechanism to merge large datasets. Hash Join in Oracle is effective when the dataset is fit to the memory. - [How to use Nested Loop Join in Oracle](https://www.ennicode.com/how-to-use-nested-loop-join-in-oracle/) - This is one of the table join mechanisms in Oracle. There are three types of joining methods including nested loop join in Oracle. - [How To Use Oracle PLAN_TABLE Correctly](https://www.ennicode.com/oracle-plan_table/) - Oracle plan_table contains detailed information about the execution plan. It is a temporary table that holds the output of the query plan. - [Oracle List Tables in Database | A Complete Guide](https://www.ennicode.com/oracle-list-tables-in-database/) - Oracle provides many ways to retrieve a list of tables. Sometimes, we need to find all the Oracle List Tables in Database - [How to Master Oracle SQL Connect by Hierarchical Queries](https://www.ennicode.com/oracle-sql-connect-by/) - If you have a table or multiple tables with hierarchical data then use Oracle SQL connect by to select complete structuring using a single query - [Top 10 Oracle Performance Tuning Interview Questions - First Lesson](https://www.ennicode.com/oracle-performance-tuning-interview-questions/) - Database knowledge is a must for programmers. Oracle Performance Tuning Interview Questions below surely improve knowledge of the database. - [Oracle sql Interview Questions | 11 New Index Qustions](https://www.ennicode.com/oracle-sql-interview-questions/) - This is the second article related to Interview Questions on Oracle sql Interview Questions and this is focused on the Oracle index. - [Bulk Collect in Oracle Fastest Ever Now](https://www.ennicode.com/bulk-collect-in-oracle/) - After introducing bulk collect in Oracle it is reduced the context switch between PL/SQL and SQL execution engines is when select data from the Oracle database - [Oracle FORALL Performing High Now](https://www.ennicode.com/oracle-forall/) - Oracle FORALL statement is introduced for executing multiple DML operations in a single SQL switch. This is comparatively faster than for loop statements - [how to use Date in WHERE Clause Oracle 2025+](https://www.ennicode.com/date-in-where-clause-oracle/) - Oracle where condition doing the filtering data in a table according to condition but date in where clause oracle is bit special, because of bad performance. - [How to Oracle Change Column Data Type 6 Examples](https://www.ennicode.com/oracle-change-column-data-type/) - This simple article describes how Oracle change column data type in different ways. First, I will explain simple syntax for changing column properties. - [10 Types of Indexes in Oracle | Easy Read](https://www.ennicode.com/types-of-indexes-in-oracle/) - DO you know how many Types of Indexes in Oracle? This article explains the Types of indexes that make considerable performance improvements - [How to take Distinct Count in Oracle](https://www.ennicode.com/distinct-count-in-oracle/) - The Oracle Count function returns only the number of records available for the attribute. But how to take a Distinct count in Oracle? - [How to Oracle Cast String to Date](https://www.ennicode.com/oracle-cast-string-to-date/) - How to convert a string to a date in Oracle? Is there a function in Oracle? It is very easy to Oracle cast string to date with the TO_DATE function - [Oracle COALESCE vs NVL Performance | What is Good](https://www.ennicode.com/oracle-coalesce-vs-nvl-performance/) - Once comparing the Oracle COALESCE vs NVL performance most of the searches say those are mostly equal. But I also hope to do a complete analysis with data load - [Best 20 Software Engineering Degrees in Sri Lanka | New](https://www.ennicode.com/software-engineering-degrees-in-sri-lanka/) - Software engineers have high demand in the world, So Sri Lanka provides sturdy software engineering degrees in Sri Lanka - [Oracle INDEX_DESC | How to Change Performance](https://www.ennicode.com/oracle-index_desc/) - If you are wondering how to use the Oracle index_desc hint, then the Oracle index_desc hint is used when descending the existing index on a range scan - [how to check running queries in Oracle | Performance Tips](https://www.ennicode.com/how-to-check-running-queries-in-oracle/) - If you have a problem with how to check running queries in Oracle? The answer is using System views like V$SESSION, V$SQLTEXT_WITH_NEWLINES, and V$SQL - [Oracle Long Running Queries | Health Check Now](https://www.ennicode.com/oracle-long-running-queries/) - Oracle databases have great ways of taking Oracle long running queries. I hope to add some examples of queries below. I would like to use some Oracle views - [SQL Query to Check Password Expiry Date in Oracle | How to Turn Off?](https://www.ennicode.com/sql-query-to-check-password-expiry-date-in-oracle/) - Database user password expiry date is important to access the database and there is an SQL query to check password expiry date in Oracle. - [Index Unusable Oracle | How to Find and Fix it](https://www.ennicode.com/index-unusable-oracle/) - Oracle databases can have invalid indexes that are not usable. Such index unusable oracle state is UNUSABLE. Oracle DBA_INDEXES view returns all the indexes - [Query to check the Table Size in Oracle | 5 Simple Queries](https://www.ennicode.com/query-to-check-the-table-size-in-oracle/) - Oracle table size does not fix it constantly changes with DML operation. There is not only one query to check the table size in Oracle. - [How to find Oracle SQL First Day of Month](https://www.ennicode.com/oracle-sql-first-day-of-month/) - To retrieve the Oracle SQL first day of month, you can use the TRUNC function. There are specific parameters to set on TRUNCT to retrieve it. - [How to use Oracle ROUND Function | Round(Number/Date)](https://www.ennicode.com/oracle-round-function/) - In Oracle, the Oracle Round function is used to round a numeric value to a specific number of the nearest integer or the nearest decimal value. - [How To Use Oracle SQL NOTFOUND (6 Example %NOTFOUND)](https://www.ennicode.com/oracle-sql-notfound/) - Oracle PL/SQL cursors are used to fetch records from a table. oracle SQL NOTFOUND is used to check whether has any row been fetched. - [How to Use SQL ISOPEN and What is %ISOPEN?](https://www.ennicode.com/sql-isopen/) - In Oracle SQL ISOPEN attribute checks whether currently a cursor is open or not. cursor_name% %ISOPEN returns TRUE if its cursor is open - [How to Performance Tuning in Oracle | 10 Tips | Never Miss](https://www.ennicode.com/performance-tuning-in-oracle/) - Getting better performance depends on different conditions. But performance tuning in Oracle is one major condition. Hardware problem, Network problem, - [How To SQL Check if at Least One Row Exists](https://www.ennicode.com/sql-check-if-at-least-one-row-exists/) - In SQL there are several ways to SQL check if at least one row exists in the table. I hope to list everything. Performance can change according to the pattern - [What is Oracle SQL Cascade Delete | 5 Good Examples](https://www.ennicode.com/oracle-sql-cascade-delete/) - Oracle SQL cascade delete is You have a Relation between tables then the Parent table record is deleted then referring child table records will be deleted. - [How to work Index Range Scan Oracle](https://www.ennicode.com/index-range-scan-oracle/) - Oracle offers a variety of indexing methods. index range scan oracle is one of the index scanning methods to gather ROWIDs and retrieve data from the table - [How to Use Oracle Index Fast Full Scan | New Tips](https://www.ennicode.com/oracle-index-fast-full-scan/) - A database can scan only using the index to perform database operation without acessingTable in Oracle index fast full scan. This is scanning without any order - [How to Oracle Index Skip Scan Works | New From 9i](https://www.ennicode.com/oracle-index-skip-scan/) - Oracle quickly fetches data by using an Index. There are different scan methods including Oracle index skip scan. If you have a composite index in the table - [How to use MOD Oracle SQL Function: 99.9%9](https://www.ennicode.com/mod-oracle-sql/) - Mod oracle sql function you know module or Mod returns the remaining amount after dived two numbers. The same thing happens in the Oracle mod function as well - [How to Add raise_application_error in Oracle](https://www.ennicode.com/raise_application_error/) - PL/SQL Raise_Application_Error procedure for defining new user errors in oracle. You can add a new custom message from the application when raising a error - [Now Oracle can we Delete Temp Tablespace](https://www.ennicode.com/oracle-can-we-delete-temp-tablespace/) - Oracle can we delete temp tablespace? Yes, it is Deleting a temporary tablespace in Oracle is a significant database operation that requires extra caring - [How to Add an Oracle Function Based Index: Unexpected Tips](https://www.ennicode.com/oracle-function-based-index/) - Oracle function based index enhances the performance with queries that retrieve data using a custom index according to usage. - [java -xmx1024m -xms1024m -jar minecraft_server.1.19.2.jar nogui](https://www.ennicode.com/java-xmx1024m-xms1024m-jar-minecraft_server-1-19-2-jar-nogui/) - Java command for running an application with minecraft_server.1.19.2.jar with some flags. java -xmx1024m -xms1024m -jar minecraft_server.1.19.2.jar nogui - [11 Ways of Oracle SQL Command Not Properly Ended](https://www.ennicode.com/sql-command-not-properly-ended/) - The Oracle return error call "ORA-00933: SQL command not properly ended" once execute a DML operation. That indicates there's a problem with your SQL syntax - [Oracle Exception No Data Found: How to handle ora 01403](https://www.ennicode.com/oracle-exception-no-data-found/) - The Oracle Exception No Data Found in PL/SQL is helping to handle no data return from one of the below-described scenarios. - [19 New Ways to Create an Index in Oracle](https://www.ennicode.com/create-an-index-in-oracle/) - This article explains how to create an index in Oracle and the Types of indexes making considerable performance improvements. Here 19 ways to create an index - [Oracle Bitmap Index Unleashed: Optimization Made Easy](https://www.ennicode.com/oracle-bitmap-index/) - Oracle provides this nice data retrieving mechanism for low occurrence of DML operation tables. oracle bitmap index is proposed for low cardinality columns. - [Love to Performance : CONNECT BY PRIOR in Oracle Performance Issue](https://www.ennicode.com/connect-by-prior-in-oracle-performance-issue/) - CONNECT BY PRIOR clause is Oracle provided a great solution for hierarchical queries but connect by prior in Oracle performance issue are headache. - [How To Create Oracle Domain Index: with 5 Solutions](https://www.ennicode.com/oracle-domain-index/) - What is domain index in Oracle? oracle domain index is a specialized type of index in Oracle that is used to retrieve text, spatial, or user-defined data speedily. - [How To Use Rank Function in Oracle: 5 Real-World Examples](https://www.ennicode.com/rank-function-in-oracle/) - The rank function in Oracle is a useful tool that gives a rank on each row in the specific data group filtered according to specific criteria. - [How to Change Case vs Decode in Oracle Performance](https://www.ennicode.com/case-vs-decode-in-oracle-performance/) - How to change case vs decode in Oracle performance? Performance change oracle decode vs case is simple and easy. DECODE was introduced in early Oracle release - [Ultimate Guide To Oracle Order By Performance 10 Tips](https://www.ennicode.com/oracle-order-by-performance/) - Oracle order by performance is considered more often when doing performance improvements. There are lots of techniques are help in tuning and sorting queries - [Oracle ORDER BY Index | How to Perform? | 6 Examples](https://www.ennicode.com/oracle-order-by-index/) - Oracle order by index is a good option to sort data by improving performance. Sorting is used when you want to order the data in a specific manner - [How to Use Average in SQL Oracle: 5 Simple Examples](https://www.ennicode.com/average-in-sql-oracle/) - The average in SQL Oracle function is an aggregate and analytic function taking an average of a set of numeric value lists. - [How to Change DISTINCT vs GROUP BY Performance Oracle](https://www.ennicode.com/distinct-vs-group-by-performance-oracle/) - Distinct vs Group By performance oracle can be changed due to several conditions. Generally, Both are Distinct and Group By clauses doing similar work. - [Top 7 NVOCC Software(Non-Vessel Operating Common Carrier) New](https://www.ennicode.com/nvocc-software/) - NVOCC carriers play a significant role in the international shipping industry. Nowadays there are a lot of NVOCC carriers and NVOCC software solutions available - [Top 6 most powerful Container Tracking Software](https://www.ennicode.com/container-tracking-software/) - Container Tracking software is doing a major role in the shipping industry. Here we aregoing to identify the most used and top software for container tracking - [EXISTS Vs IN | How To Change Performance In Subqueries](https://www.ennicode.com/exists-vs-in/) - How to Use EXISTS vs IN in Subqueries? Query Returning a few records, then IN clause performs well. If return large data records from the subquery, use EXISTS - [Poor SQL Index Usage including Good Examples](https://www.ennicode.com/sql-index-usage/) - When making performance improvements in your database SQL Index Usage is one of the most valuable and essential features - [What are 8 Best 3PL billing software?](https://www.ennicode.com/3pl-billing-software/) - After a long time of research we have selected 8 best 3PL billing software. Here we are going to explain them one by one. - [Top 10 Tools for Download YouTube to MP3 in 1S](https://www.ennicode.com/download-youtube-to-mp3/) - YouTube video Download is not hard work there are hundreds of web and mobile apps for download YouTube to mp3. But quality, speed, and bit rates are different. - [How to Solve Oracle expdp ora-01555 snapshot too old](https://www.ennicode.com/oracle-expdp-ora-01555/) - Oracle expdp ora-01555 is because UNDO_RETENTION parameter values are not enough, A corrupted row containing LOB or Retention is not set for the LOBs. - [Tips and Tricks for Mastering Design Patterns to Better Software Design](https://www.ennicode.com/mastering-design-patterns-to-software-design/) - Ready to level up your coding skills? Discover practical tips and tricks for mastering design patterns to create professional, maintainable, and elegant software designs. - [The Importance of Design Patterns in Software Development](https://www.ennicode.com/the-importance-of-design-patterns/) - Discover why design patterns are crucial for building robust, scalable software. Learn how they improve code quality. - [How to use SQL ROWCOUNT in Oracle.](https://www.ennicode.com/sql-rowcount-in-oracle/) - SQL ROWCOUNT in Oracle is an attribute of SQL that returns an INTEGER value for the implicit cursor in PLSQL when you are running a DML or SELECT statement - [Design Patterns Discover: A Beginner's Guide](https://www.ennicode.com/design-patterns-discover/) - Unsure where to begin with design patterns? Our beginner's guide breaks down the core concepts and fundamental patterns in a simple, easy-to-understand way. - [5 Essential Design patterns every software engineer should know](https://www.ennicode.com/5-essential-design-patterns/) - Learn 5 crucial design patterns every software engineer must know. Master these essential techniques to write cleaner, more efficient, and reusable code. - [The Pros and Cons of Using Design Patterns in Software Development](https://www.ennicode.com/pros-and-cons-of-using-design-patterns/) - What is Software Development? Software Development refers to a compilation of Information technological activities involved in creating, designing, deploying, and supporting software. Simply, it is the process of building up computer programs. The process is known as the Software Development Lifecycle and includes different phases that provide unique methods for building products to meet the - [How to Improve Your Code by Using Design Patterns for Code Maintainability](https://www.ennicode.com/design-patterns-for-code-maintainability/) - An Insight of Software Development and Design Patterns The collective process of designing, creating, testing, and maintaining software applications is introduced as Software Development. The process follows the light of the software development lifecycle and uses the various aspects of the cycle to produce well-maintained software as per the client's specifications and use. The general - [Real-world Examples of Design Patterns in Action](https://www.ennicode.com/real-world-examples-of-design-patterns-in-action/) - An Insight into Design Patterns Used in Software Development One of the major steps in the Software Development Life Cycle is the ‘Design’. The sole basis of this phase is built upon the usage of different design patterns by software developers. In Software Development, Design patterns are repeatable and reusable solutions for commonly occurring problems - [The Future of Design Patterns: Emerging Trends and Best Practices](https://www.ennicode.com/emerging-trends-and-best-practices-in-future-of-design-patterns/) - For over a decade, design patterns have been the sole basis of the architecture of software. Design patterns are reusable, flexible, and efficient and pave the way for the systemic flow of the software development lifecycle. It is simply a repeatable solution to a commonly occurring problem in software design. Future of design patterns speed - [How to Oracle SQL Compare Dates (6 Ways)](https://www.ennicode.com/oracle-sql-compare-dates/) - Oracle SQL Compare Dates is easy if you follow the correct syntax and match targeting columns. else need to convert column data into the same matching data type - [A Step-by-Step Guide to Refactoring with Design Patterns](https://www.ennicode.com/a-step-by-step-guide-to-refactoring-with-design-patterns/) - A Step-by-Step Guide to Refactoring with Design Patterns Software engineering is a broad area in the field of information technology. It involves software developers designing and developing applications according to client requirements and specifications. The process of software development flows along the software development lifecycle and one of the major phases of the cycle is - [4 Pillars Of OOP With Real World New Examples](https://www.ennicode.com/4-pillars-of-oop/) - The 4 Pillars of OOP are well-defined. What are the 4 pillars of oop? Those are 1. Encapsulation 2. Inheritance 3. Polymorphism 4. Abstraction - [How to select the right ERP system for your business](https://www.ennicode.com/how-to-select-the-right-erp-system-for-your-business/) - For success, a business needs to take the right decisions at right time. The right ERP system means that is most suitable for your business & budget allocation - [A New ERP Solution: IFS ERP Software](https://www.ennicode.com/a-new-solution-ifs-erp-software-in-2022/) - Before discussing IFS ERP software, need to get an idea about IFS company.IFS stands for Industrial and Financial Systems. It is a multinational software development company started in 1983 with headquarters in Linköping, Sweden. When considering software solution companies IFS is the most powerful and well-experienced company in the world. Nowadays IFS is famous as - [Sage X3: More Reliable ERP Solution for you](https://www.ennicode.com/sage-x3-more-reliable-erp-solution-for-you/) - Sage X3 is an ERP System (Enterprise Resources Planning) introduced by Sage Business Cloud. Sage X3 streamlines the operations of the business. - [Deliveries made smarter and easy with "TOOKAN": Delivery tracking software](https://www.ennicode.com/tookan/) - Tookan is a top Delivery management software that automates delivery operations. Tookan can whole operation of last-mile delivery be taken into the dashboard. - [When using TripAdvisor you Should Know This, It is Amazing](https://www.ennicode.com/tripadvisor/) - TripAdvisor provides you to get a marvelous experience with a high-comfort journey at a low cost. TripAdvisor is a website that provides guidance to travelers - [Proxy Design Pattern: It's Super Easy](https://www.ennicode.com/proxy-design-pattern/) - Proxy Design Pattern for creating a new layer of representations for the real objects its adding a new intermediate level between real objects and object users - [Chain of Responsibility Design Pattern (New)](https://www.ennicode.com/chain-of-responsibility-design-pattern/) - Chain of Responsibility Design Pattern is processing client or sender requests through a chain of handlers. Receiving side, there is a chain of handlers - [Flyweight Design Pattern: Love to Reuse](https://www.ennicode.com/flyweight-design-pattern/) - Flyweight Design Pattern is to reduce the create new objects by reusing or sharing the already created objects but behavioral in the same way - [Strategy Design Pattern: Happy To See Your Choice](https://www.ennicode.com/strategy-design-pattern/) - Strategy Design Pattern allows a user to change the context or behavior of an algorithm according to the situation. That means deciding which is run at runtime - [State Design Pattern (New State)](https://www.ennicode.com/state-design-pattern/) - State Design Pattern is introduced as an easy way of handling behaviors and actions of a specific object according to its state and maintain a state machine - [Filter Design Pattern: (It's Now Simple)](https://www.ennicode.com/filter-design-pattern/) - Filter Design Pattern enables filtering the dataset according to specific criteria. Free to add different types of filtering criteria once it is needed. - [Command Design Pattern (Order Now)](https://www.ennicode.com/command-design-pattern/) - Command Design Pattern is to decouple an action from its action invoker. This is achieved by introducing a new Command layer between action and the invoker. - [23 Design Patterns & intro | All in one page now](https://www.ennicode.com/design-patterns/) - Design patterns are solving a common problem in software engineering. Each Design Pattern is a well-defined standard answer for a specific problem or task. - [Interpreter Design Pattern: A simple Converter](https://www.ennicode.com/interpreter-design-pattern/) - Interpreter Design Pattern provides an interpreter to deal with grammar in programming languages. Pattern mostly use with SQL parsing and Symbol processing - [Iterator Design Pattern (Great on your favorite looping)](https://www.ennicode.com/iterator-design-pattern/) - Iterator Design Pattern is one of the patterns used in collections to traversal objects sequentially without exposing their underlying representation - [Mediator Design Pattern: Great Negotiator](https://www.ennicode.com/mediator-design-pattern/) - Mediator Design Pattern reduces the coupling when communicating between objects. If tightly coupled applications are growing then complexity improves - [Observer Design Pattern (99 New Notifications)](https://www.ennicode.com/observer-design-pattern/) - Observer Design Pattern is one of the heavily used patterns in social media. If someone creates or modified something then the message notifies all followers - [Memento Design Pattern | You need to keep state](https://www.ennicode.com/memento-design-pattern/) - Memento Design Pattern introduces to capture the internal state of a given object and keep storing it to restore into a given state of an object. - [Null Design Pattern: Easy way of get default](https://www.ennicode.com/null-design-pattern-easy-way-of-get-default/) - Null Design Pattern designs Instead of putting if null check, Null object used as a default behavior. If data is not available, then a class is do nothing - [Why ERP system Is Important? 12 Reasons, 7 Success Stories](https://www.ennicode.com/erp-system/) - ERP system is an amazing tool that can boost and make a digital platform for your business. And also it can reduce traditional manual recording with paper. - [Elementor Pro 10 Features 2023, How To Speed Up Build A Website In 1000 Times?](https://www.ennicode.com/elementor-pro/) - Elementor Pro is a WordPress plugin that is an excellent page builder plugin that helps to build your exited website without knowing any piece of code - [SAP Business One ERP No Excuses Ever Being a Great Successful Company](https://www.ennicode.com/sap-business-one-erp-no-excuses-ever-being-a-great-successful-company/) - SAP Business One is one of the best ERP systems for startups, small businesses, and subsidiary companies for all a company's core functions in one system. - [What are the Secrets Behind Oracle NetSuite ERP](https://www.ennicode.com/oracle-netsuite-erp/) - Oracle NetSuite ERP system is integrated all core functions in the business management process into a single system and automates core processes effectively - [Hostinger Most Exited Hosting Deals Now $1.99/mo](https://www.ennicode.com/hostinger/) - Hostinger is a web hosting company doing hosting and other related work for amazing deals. They are focus on giving an all-in-one package for hosting users. - [What Is Overloading and Overriding In OOP? Simple to Begin](https://www.ennicode.com/overloading-and-overriding-in-oop/) - Overloading and Overriding In OOP are frequently used object-oriented programming techniques. Those are used to write and design code clearly and smartly. - [How to work Polymorphism in Object orient Programming](https://www.ennicode.com/polymorphism-in-object-orient-programming-oop/) - Polymorphism in Object orient Programming describes Poly into Many and morphism into Form. There can be many forms with a class according to the situation. - [What Is Inheritance in Object Orient Programming? How to Make](https://www.ennicode.com/inheritance-in-object-orient-programming-oop/) - Inheritance in Object Orient Programming is acquiring all the behaviors and attributes from another. it means one class properties derive from another class - [Builder Design Pattern (is it Simple?)](https://www.ennicode.com/builder-design-pattern/) - Builder Design Pattern is for creating complex objects by simple step by steps process. Pattern is doing separate the construction of the complex object. - [Singleton Design Pattern is Easy](https://www.ennicode.com/singleton-design-pattern/) - The intention of Singleton Design Pattern is to create only a single object throughout the application. Give a global access point to a single object and use it - [What is Abstract Factory Design Pattern? (Easy)](https://www.ennicode.com/abstract-factory-design-pattern/) - Abstract Factory Design Pattern hides the way of creating objects by giving a common interface to request objects. Not onsider how factories produce objects - [What is Factory Design Pattern (Easy)](https://www.ennicode.com/factory-design-pattern/) - Factory Design Pattern intention is hiding implementation and pattern motivation is to loosely couple Client Requirement(Front end) and implementation Logic - [SOLID Principles In OOP| New Explanation](https://www.ennicode.com/solid-principles-object-orient-program/) - SOLID Principles in Object-oriented Programming is five application design and development concepts in OOP. Single Responsibility, Open-Closed, Liskov Sub... - [Prototype Design Pattern (New Copy?)](https://www.ennicode.com/prototype-design-pattern/) - Prototype Design Pattern is duplicating existing objects. Considering the performance and the cost of generating objects it's easy to copy existing objects - [Adapter Design Pattern (with New Example)](https://www.ennicode.com/adapter-design-pattern/) - Adapter Design Pattern is work as Connector of non-compatible interfaces(Objects). That means Convert one interface output into another interface expectation - [Bridge Design Pattern (With New Example)](https://www.ennicode.com/bridge-design-pattern/) - Bridge Design Pattern is focusing on decoupling abstraction from implementation. it is Help to grow implementation and abstraction without coupling each other - [Facade Design Pattern (it's Simple)](https://www.ennicode.com/facade-design-pattern/) - Facade Design Pattern is very easy to understand. In the dictionary saying the front of an attractive building or commonly saying appearance of something ... - [Decorator Design Pattern is easy](https://www.ennicode.com/decorator-design-pattern/) - Decorator Design Pattern intention is to decorate an object by adding behaviors to a single object like a chain without affecting objects in the same class - [Composite Design Pattern: what it is best and famous for?](https://www.ennicode.com/composite-design-pattern/) - Composite Design Pattern suitable for cases with a hierarchical structure like a tree structure. At least a common behavior through the hierarchy is a must - [What is Abstraction in Object Orient Programming? How to Make](https://www.ennicode.com/abstraction-in-object-orient-programming/) - Abstraction in Object Orient Programming is showing the required information to the outside and hides the lower-level complex implementation. - [What is Encapsulation in OOP? How to Hide](https://www.ennicode.com/what-is-encapsulation-in-oop/) - Encapsulation in OOP is everything (data- attribute/ behaviors) combining and keeping together as a single unit when implementation. - [What Is Object Orient Programming (OOP)? Simple Start](https://www.ennicode.com/what-is-object-orient-programming-oop/) - Object Orient Programming (OOP) is a Software Programming Technique. The concept is to map programming objects with real-world objects, things, or concepts - [Ora-28001 the Password has Expired. How to Fix? 5 Solutions](https://www.ennicode.com/ora-28001-the-password-has-expired/) - If you are an Oracle database user you may face ora-28001 the password has expired problem. This means your password has expired already. - [Most powerful 8 Top ERP systems](https://www.ennicode.com/top-erp/) - A better ERP system builds a successful journey for your business with the digital platform. This blog is based on research of 7 top ERP systems in the world. - [Why Should Know Leading 9 ERP Vendors:](https://www.ennicode.com/erp-vendors/) - For selecting a better ERP system for your company you should be aware of the top leading ERP vendors. This blog is regarding 9 companies that lead ERP industry - [Leading 9 ERP Vendors in the World](https://www.ennicode.com/erp-vendors-2/) - For selecting a better ERP system for your company you should be aware of who are the best ERP vendors - [Do you know Top 10 WMS: Warehouse Management System](https://www.ennicode.com/warehouse-management-system/) - A warehouse management system provides a digital platform for your warehouse or distribution center. Automation also can be done with the warehouse management - [How to Check Database Name in Oracle | 6 Tips](https://www.ennicode.com/check-database-name-in-oracle/) - If you want to check database name in Oracle that you connected there are several ways to get it. I added 6 different methods to check it. - [Oracle REPLACE Function: How to Use Magic](https://www.ennicode.com/oracle-replace-function/) - Oracle provides a powerful set of functions for working with data. In such cases, the Oracle REPLACE function can be used on Data manipulation - [How to Oracle SQL Developer Export to Excel in 3 steps](https://www.ennicode.com/oracle-sql-developer-export-to-excel/) - Oracle SQL Developer Export to Excel Your dataset purpose is to data analysis, create reports or share your information with our people. - [Best Independent (3rd party) ERP consulting Companies](https://www.ennicode.com/erp-consulting-companies/) - To select the right ERP system for your business, contact an ERP consulting company is needed. Here list provides Top ERP consultation providing companies - [How to Grow your Business with Brevo X-Sendinblue FREE](https://www.ennicode.com/sendinblue/) - SendInBlue is one of the great digital marketing tools for growing your business and one who wants to keep engaging people by using email, SMS, chat, and more - [High Growth of ERP Market Acumatica Cloud ERP](https://www.ennicode.com/acumatica-cloud/) - Acumatica cloud ERP is a leading innovative cloud ERP vendor company. Acumatica ERP Cloud is famous as a fast-growing ERP solution provider. - [Everything you need to know NetSuite supply chain management software](https://www.ennicode.com/netsuite-supply-chain/) - Netsuite company has introduced supply chain management software as a module of the Oracle NetSuite ERP system called NetSuite supply chain management software. - [The best solution for SCM: IFS supply chain management](https://www.ennicode.com/ifs-supply-chain/) - IFS supply chain management software is the best solution for any kind of supply chain which is moving toward the latest technology and globalization. - [World famous top 3 e-procurement software](https://www.ennicode.com/e-procurement-software/) - Are you looking for e-procurement software? we have identified the top 3 procurement software that is most famous and most powerful at the moment. - [Top Manufacturing ERP Systems, Small & Medium Business](https://www.ennicode.com/top-manufacturing-erp-systems/) - Are you finding a top manufacturing ERP systems? firstly you need to analyze what are the top ERP systems that suit the manufacturing industry. ## Pages - [Home](https://www.ennicode.com/) - Place for Learn Software Engineering, Oracle and other Database lessons, Design Patterns, Programming Concepts, Software Reviews and Learning materials. - [Contact](https://www.ennicode.com/contact/) - Contact Us Let's get in touch We're Ready, Let's Talk. Office 89/1 Rabbegamuwa, Handessa, Kandy, Central, Sri Lanka Follow us Telephone +94 715122494 Email info@ennicode.com - [Terms And Conditions](https://www.ennicode.com/terms-and-conditions/) - Last updated: May 2, 2022 Please read these Terms of Use (“Terms”, “Terms of Use”) carefully before using the https://ennicode.com website (the “Service”) operated by Ennicode (“us”, “we”, or “our”). Your access to and use of the Service is conditioned on your acceptance of and compliance with these Terms. These Terms apply to all visitors, - [Privacy Policy](https://www.ennicode.com/privacy-policy-2/) - Who we are Our website address is http://ennicode.com. Comments When visitors leave comments on the site we collect the data shown in the comments form, and also the visitor’s IP address and browser user agent string to help spam detection. An anonymized string created from your email address (also called a hash) may be provided - [Services](https://www.ennicode.com/services/) - We are Providing You E-Learning Services: Learning materials and Web blogging Web Development & Configurations: Rise your Business, College, Union, or any kind of concept by adding to the Web Effective solutions Our Services E-Learning Read our technical blogs. Blogs specializations are Simply to Read Clear Content Example Codes Company Websites Build your website including - [Team](https://www.ennicode.com/team/) - Super Dupper team A great with Extraordinary Experiences Be a better place for learning software engineering. We are there to help explore your software development skills by updating modern technologies in a smart way. Simplicity Accountability Our Team Asiri Gunasena Lead Software Engineer Hi! I’m an Engineer working as a Software Developer with Over a - [About](https://www.ennicode.com/about/) - About Ennicode Our Mission Ennicode is helping to traverse software engineering clearly and easily. We are a pleasure to support beginners’ drive in the right direction. We are looking to simplify the lessons and explain the problems that beginners can realize. Our Core Values Be a better place for learning software engineering. We are here to - [Credits](https://www.ennicode.com/credits/) - [Registration](https://www.ennicode.com/registration/) - [user_registration_form id="6"] - [My Account](https://www.ennicode.com/my-account/) - [user_registration_my_account] - [Style Guide](https://www.ennicode.com/style-guide/) - Typography Menu Font: Rubik – 13px, Weight – 700 Main Content Font: Poppins, Size – 17px, Weight – 400 Headings - H1 Font: QuicksandSize – 50px/44pxWeight – 700 Fusce vulputate augue sit amet nunc egestas volutpat. Headings - H2 Font: QuicksandSize – 35px/27pxWeight – 700 Fusce vulputate augue sit amet nunc egestas volutpat. Headings - ## Categories - [Object Oriented Programming](https://www.ennicode.com/category/object-oriented-programming/) - [Design Pattern](https://www.ennicode.com/category/design-pattern/) - [Web Development](https://www.ennicode.com/category/web-development/) - [Web Tools](https://www.ennicode.com/category/web-tools/) - [SQL](https://www.ennicode.com/category/sql/) - [No Category](https://www.ennicode.com/category/uncategorized/) - [Java](https://www.ennicode.com/category/java/) - [Courses](https://www.ennicode.com/category/courses/) - [ERP](https://www.ennicode.com/category/erp/) - [services](https://www.ennicode.com/category/services/) ## Tags - [Class](https://www.ennicode.com/tag/class/) - [object oriented programming](https://www.ennicode.com/tag/object-oriented-programming-2/) - [Object-Orient Programming (OOP)](https://www.ennicode.com/tag/object-orient-programming-oop/) - [Object-Oriented Programming](https://www.ennicode.com/tag/object-oriented-programming/) - [OOP](https://www.ennicode.com/tag/oop/) - [Encapsulation](https://www.ennicode.com/tag/encapsulation/) - [Abstraction](https://www.ennicode.com/tag/abstraction/) - [Object-Orient Programming](https://www.ennicode.com/tag/object-orient-programming/) - [Inheritance](https://www.ennicode.com/tag/inheritance/) - [Polymorphism](https://www.ennicode.com/tag/polymorphism/) - [Overloading](https://www.ennicode.com/tag/overloading/) - [Overriding](https://www.ennicode.com/tag/overriding/) - [solid](https://www.ennicode.com/tag/solid/) - [Design Pattern](https://www.ennicode.com/tag/design-pattern/) - [Factory Pattern](https://www.ennicode.com/tag/factory-pattern/) - [Abstract Factory Design Pattern](https://www.ennicode.com/tag/abstract-factory-design-pattern/) - [Singleton Design Pattern](https://www.ennicode.com/tag/singleton-design-pattern/) - [Builder Design Pattern](https://www.ennicode.com/tag/builder-design-pattern/) - [Design Patterns](https://www.ennicode.com/tag/design-patterns/) - [Prototype Design Pattern](https://www.ennicode.com/tag/prototype-design-pattern/) - [Adapter Design Pattern](https://www.ennicode.com/tag/adapter-design-pattern/) - [Bridge Design Pattern](https://www.ennicode.com/tag/bridge-design-pattern/) - [Facade Design Pattern](https://www.ennicode.com/tag/facade-design-pattern/) - [Decorator Design Pattern](https://www.ennicode.com/tag/decorator-design-pattern/) - [Proxy Design Pattern](https://www.ennicode.com/tag/proxy-design-pattern/) - [Flyweight Design Pattern](https://www.ennicode.com/tag/flyweight-design-pattern/) - [Composite Design Pattern](https://www.ennicode.com/tag/composite-design-pattern/) - [Filter Design Pattern](https://www.ennicode.com/tag/filter-design-pattern/) - [filter pattern](https://www.ennicode.com/tag/filter-pattern/) - [java filter design pattern](https://www.ennicode.com/tag/java-filter-design-pattern/) - [java filter pattern](https://www.ennicode.com/tag/java-filter-pattern/) - [Chain of Responsibility Design Pattern](https://www.ennicode.com/tag/chain-of-responsibility-design-pattern/) - [Command Design Pattern](https://www.ennicode.com/tag/command-design-pattern/) - [Interpreter Design Pattern](https://www.ennicode.com/tag/interpreter-design-pattern/) - [Iterator Design Pattern](https://www.ennicode.com/tag/iterator-design-pattern/) - [Mediator Design Pattern](https://www.ennicode.com/tag/mediator-design-pattern/) - [Memento Design Pattern](https://www.ennicode.com/tag/memento-design-pattern/) - [Observer Design Pattern](https://www.ennicode.com/tag/observer-design-pattern/) - [Null Design Pattern](https://www.ennicode.com/tag/null-design-pattern/) - [Strategy Design Pattern](https://www.ennicode.com/tag/strategy-design-pattern/) - [Java Design patterns](https://www.ennicode.com/tag/java-design-patterns/) - [Elementor](https://www.ennicode.com/tag/elementor/) - [Elementor Pro](https://www.ennicode.com/tag/elementor-pro/) - [Wordpress](https://www.ennicode.com/tag/wordpress/) - [Hostinger](https://www.ennicode.com/tag/hostinger/) - [Hostinger hosting](https://www.ennicode.com/tag/hostinger-hosting/) - [SendinBlue](https://www.ennicode.com/tag/sendinblue/) - [Sendinblue alternative](https://www.ennicode.com/tag/sendinblue-alternative/) - [Sendinblue pricing](https://www.ennicode.com/tag/sendinblue-pricing/) - [Sendinblue reviews](https://www.ennicode.com/tag/sendinblue-reviews/) - [exists vs in](https://www.ennicode.com/tag/exists-vs-in/) - [oracle database](https://www.ennicode.com/tag/oracle-database/) - [oracle performance](https://www.ennicode.com/tag/oracle-performance/) - [oracle performance tips](https://www.ennicode.com/tag/oracle-performance-tips/) - [oracle sql](https://www.ennicode.com/tag/oracle-sql/) - [oracle](https://www.ennicode.com/tag/oracle/) - [oracledatabase](https://www.ennicode.com/tag/oracledatabase/) - [oracledba](https://www.ennicode.com/tag/oracledba/) - [sql database index](https://www.ennicode.com/tag/sql-database-index/) - [sql index](https://www.ennicode.com/tag/sql-index/) - [sql index performance](https://www.ennicode.com/tag/sql-index-performance/) - [sql index performance tuning](https://www.ennicode.com/tag/sql-index-performance-tuning/) - [sql index tuning](https://www.ennicode.com/tag/sql-index-tuning/) - [sql index usage](https://www.ennicode.com/tag/sql-index-usage/) - [sqldatabase](https://www.ennicode.com/tag/sqldatabase/) - [sqlprogramming](https://www.ennicode.com/tag/sqlprogramming/) - [sqlqeuries](https://www.ennicode.com/tag/sqlqeuries/) - [download from youtube to mp3](https://www.ennicode.com/tag/download-from-youtube-to-mp3/) - [download youtube to mp3](https://www.ennicode.com/tag/download-youtube-to-mp3/) - [download youtube video mp3](https://www.ennicode.com/tag/download-youtube-video-mp3/) - [download youtube video to mp3](https://www.ennicode.com/tag/download-youtube-video-to-mp3/) - [youtube converter mp3 download](https://www.ennicode.com/tag/youtube-converter-mp3-download/) - [youtube video download mp3](https://www.ennicode.com/tag/youtube-video-download-mp3/) - [Expdp](https://www.ennicode.com/tag/expdp/) - [Oracle Expdp](https://www.ennicode.com/tag/oracle-expdp/) - [PLSQL](https://www.ennicode.com/tag/plsql/) - [ROWCOUNT](https://www.ennicode.com/tag/rowcount/) - [SQL](https://www.ennicode.com/tag/sql/) - [oraclemod](https://www.ennicode.com/tag/oraclemod/) - [raise_application_error](https://www.ennicode.com/tag/raise_application_error/) - [database](https://www.ennicode.com/tag/database/) - [java](https://www.ennicode.com/tag/java/) - [minecraft_server](https://www.ennicode.com/tag/minecraft_server/) - [oracle function](https://www.ennicode.com/tag/oracle-function/) - [oracle index](https://www.ennicode.com/tag/oracle-index/) - [oracle replace](https://www.ennicode.com/tag/oracle-replace/) - [software engineering degree sri lanka](https://www.ennicode.com/tag/software-engineering-degree-sri-lanka/) - [software engineering sri lanka](https://www.ennicode.com/tag/software-engineering-sri-lanka/) - [sri lanka computer science](https://www.ennicode.com/tag/sri-lanka-computer-science/) - [sri lanka software enginering](https://www.ennicode.com/tag/sri-lanka-software-enginering/) - [oracledb](https://www.ennicode.com/tag/oracledb/) - [full table scan](https://www.ennicode.com/tag/full-table-scan/) - [index rowid](https://www.ennicode.com/tag/index-rowid/) - [oracle rowid](https://www.ennicode.com/tag/oracle-rowid/) - [execution plan](https://www.ennicode.com/tag/execution-plan/) - [explain plan](https://www.ennicode.com/tag/explain-plan/) - [design patterns c#](https://www.ennicode.com/tag/design-patterns-c/) - [design patterns in Java](https://www.ennicode.com/tag/design-patterns-in-java/) - [mastering php design patterns](https://www.ennicode.com/tag/mastering-php-design-patterns/) - [importance of design patterns in programming](https://www.ennicode.com/tag/importance-of-design-patterns-in-programming/) - [importance of design patterns in software development](https://www.ennicode.com/tag/importance-of-design-patterns-in-software-development/) - [importance of design patterns?](https://www.ennicode.com/tag/importance-of-design-patterns/) - [what is the importance of design patterns](https://www.ennicode.com/tag/what-is-the-importance-of-design-patterns/) - [what is the importance of design patterns in programming](https://www.ennicode.com/tag/what-is-the-importance-of-design-patterns-in-programming/) - [Design pattern examples](https://www.ennicode.com/tag/design-pattern-examples/) - [Design Patterns Discover](https://www.ennicode.com/tag/design-patterns-discover/) - [how to identify design patterns](https://www.ennicode.com/tag/how-to-identify-design-patterns/) - [Where do we find patterns](https://www.ennicode.com/tag/where-do-we-find-patterns/) - [Essential Design patterns](https://www.ennicode.com/tag/essential-design-patterns/) - [gang of four design patterns](https://www.ennicode.com/tag/gang-of-four-design-patterns/) - [software design patterns](https://www.ennicode.com/tag/software-design-patterns/) - [Basic design pattern pros](https://www.ennicode.com/tag/basic-design-pattern-pros/) - [Beginner-friendly design patterns](https://www.ennicode.com/tag/beginner-friendly-design-patterns/) - [Design pattern advantages](https://www.ennicode.com/tag/design-pattern-advantages/) - [Design pattern benefits](https://www.ennicode.com/tag/design-pattern-benefits/) - [Design pattern impact on software development](https://www.ennicode.com/tag/design-pattern-impact-on-software-development/) - [Design pattern pros and cons explained](https://www.ennicode.com/tag/design-pattern-pros-and-cons-explained/) - [Simple design pattern benefits](https://www.ennicode.com/tag/simple-design-pattern-benefits/) - [Design patterns for code maintainability](https://www.ennicode.com/tag/design-patterns-for-code-maintainability/) - [design patterns for code maintainability.](https://www.ennicode.com/tag/design-patterns-for-code-maintainability-2/) - [how to enhance code maintainability with design patterns](https://www.ennicode.com/tag/how-to-enhance-code-maintainability-with-design-patterns/) - [mproving code maintainability with design patterns](https://www.ennicode.com/tag/mproving-code-maintainability-with-design-patterns/) - [benefits of using design patterns for refactoring](https://www.ennicode.com/tag/benefits-of-using-design-patterns-for-refactoring/) - [best practices for refactoring with design patterns](https://www.ennicode.com/tag/best-practices-for-refactoring-with-design-patterns/) - [Refactoring legacy code with design patterns](https://www.ennicode.com/tag/refactoring-legacy-code-with-design-patterns/) - [Refactoring with design patterns](https://www.ennicode.com/tag/refactoring-with-design-patterns/) - [C# design patterns in action.](https://www.ennicode.com/tag/c-design-patterns-in-action/) - [Design patterns in action](https://www.ennicode.com/tag/design-patterns-in-action/) - [Design Patterns in actions](https://www.ennicode.com/tag/design-patterns-in-actions/) - [examples of design patterns in real-world applications](https://www.ennicode.com/tag/examples-of-design-patterns-in-real-world-applications/) - [list of design patterns in actions](https://www.ennicode.com/tag/list-of-design-patterns-in-actions/) - [real-life implementation of design patterns](https://www.ennicode.com/tag/real-life-implementation-of-design-patterns/) - [real-world scenarios for design patterns](https://www.ennicode.com/tag/real-world-scenarios-for-design-patterns/) - [cutting edge of design patterns](https://www.ennicode.com/tag/cutting-edge-of-design-patterns/) - [emerging design patterns in the future](https://www.ennicode.com/tag/emerging-design-patterns-in-the-future/) - [Future of design patterns](https://www.ennicode.com/tag/future-of-design-patterns/) - [future trends in design patterns](https://www.ennicode.com/tag/future-trends-in-design-patterns/) - [next-generation design patterns](https://www.ennicode.com/tag/next-generation-design-patterns/) - [user interface design patterns](https://www.ennicode.com/tag/user-interface-design-patterns/) - [ERP](https://www.ennicode.com/tag/erp/) - [ERP System](https://www.ennicode.com/tag/erp-system/) - [Oracle Netsuite](https://www.ennicode.com/tag/oracle-netsuite/) - [TripAdvisor](https://www.ennicode.com/tag/tripadvisor/) - [TripAdvisor Plus](https://www.ennicode.com/tag/tripadvisor-plus/) - [delivery software](https://www.ennicode.com/tag/delivery-software/) - [lastmile delivery software](https://www.ennicode.com/tag/lastmile-delivery-software/) - [tookan](https://www.ennicode.com/tag/tookan/) - [tookan app](https://www.ennicode.com/tag/tookan-app/) - [tookan software](https://www.ennicode.com/tag/tookan-software/) - [ERP systems](https://www.ennicode.com/tag/erp-systems/) - [Manufacturing ERP](https://www.ennicode.com/tag/manufacturing-erp/) - [Manufacturing ERP Systems](https://www.ennicode.com/tag/manufacturing-erp-systems/) - [E-procurement](https://www.ennicode.com/tag/e-procurement/) - [E-procurement software](https://www.ennicode.com/tag/e-procurement-software/) - [nvocc](https://www.ennicode.com/tag/nvocc/) - [NVOCC software](https://www.ennicode.com/tag/nvocc-software/) - [container tracking](https://www.ennicode.com/tag/container-tracking/) - [container tracking software](https://www.ennicode.com/tag/container-tracking-software/) - [package tracking software](https://www.ennicode.com/tag/package-tracking-software/) - [3PL billing](https://www.ennicode.com/tag/3pl-billing/) - [3PL billing software](https://www.ennicode.com/tag/3pl-billing-software/) - [3PL invoicing](https://www.ennicode.com/tag/3pl-invoicing/) - [3rd party logistics billing software](https://www.ennicode.com/tag/3rd-party-logistics-billing-software/) - [third party logistics billing software](https://www.ennicode.com/tag/third-party-logistics-billing-software/) - [Overloading and Overriding In OOP](https://www.ennicode.com/tag/overloading-and-overriding-in-oop/) - [Overriding In OOP](https://www.ennicode.com/tag/overriding-in-oop/) - [Overloading In OOP](https://www.ennicode.com/tag/overloading-in-oop/) - [Singleton Pattern](https://www.ennicode.com/tag/singleton-pattern/) - [SAP Business One](https://www.ennicode.com/tag/sap-business-one/) - [SAP](https://www.ennicode.com/tag/sap/) - [Oracle NetSuite ERP](https://www.ennicode.com/tag/oracle-netsuite-erp/) - [IFS ERP software](https://www.ennicode.com/tag/ifs-erp-software/) - [IFS ERP](https://www.ennicode.com/tag/ifs-erp/) - [Sage X3 ERP System](https://www.ennicode.com/tag/sage-x3-erp-system/) - [Sage X3](https://www.ennicode.com/tag/sage-x3/) - [netsuite supply chain management](https://www.ennicode.com/tag/netsuite-supply-chain-management/) - [netsuite supply chain](https://www.ennicode.com/tag/netsuite-supply-chain/) - [Acumatica Cloud ERP](https://www.ennicode.com/tag/acumatica-cloud-erp/) - [Acumatica ERP](https://www.ennicode.com/tag/acumatica-erp/) - [ERP vendors](https://www.ennicode.com/tag/erp-vendors/) - [brevo](https://www.ennicode.com/tag/brevo/) - [warehouse management system](https://www.ennicode.com/tag/warehouse-management-system/) - [ERP consulting](https://www.ennicode.com/tag/erp-consulting/) - [in xs exists](https://www.ennicode.com/tag/in-xs-exists/) - [Oracle can we delete temp tablespace](https://www.ennicode.com/tag/oracle-can-we-delete-temp-tablespace/) - [Case vs Decode in Oracle Performance](https://www.ennicode.com/tag/case-vs-decode-in-oracle-performance/) - [Oracle order by performance](https://www.ennicode.com/tag/oracle-order-by-performance/) - [Oracle order by index](https://www.ennicode.com/tag/oracle-order-by-index/) - [Average in SQL Oracle](https://www.ennicode.com/tag/average-in-sql-oracle/) - [software engineering degrees in Sri Lanka](https://www.ennicode.com/tag/software-engineering-degrees-in-sri-lanka/) - [Oracle index_desc](https://www.ennicode.com/tag/oracle-index_desc/) - [how to check running queries in oracle](https://www.ennicode.com/tag/how-to-check-running-queries-in-oracle/) - [check database name in Oracle](https://www.ennicode.com/tag/check-database-name-in-oracle/) - [index unusable oracle](https://www.ennicode.com/tag/index-unusable-oracle/) - [SQL ISOPEN](https://www.ennicode.com/tag/sql-isopen/) - [performance tuning in oracle](https://www.ennicode.com/tag/performance-tuning-in-oracle/) - [Oracle SQL cascade delete](https://www.ennicode.com/tag/oracle-sql-cascade-delete/) - [index range scan oracle](https://www.ennicode.com/tag/index-range-scan-oracle/) - [Oracle index fast full scan](https://www.ennicode.com/tag/oracle-index-fast-full-scan/) - [Oracle index skip scan](https://www.ennicode.com/tag/oracle-index-skip-scan/) - [Oracle index full scan](https://www.ennicode.com/tag/oracle-index-full-scan/) - [Full Table Scan in Oracle](https://www.ennicode.com/tag/full-table-scan-in-oracle/) - [Oracle table access by index rowid](https://www.ennicode.com/tag/oracle-table-access-by-index-rowid/) - [Explain plan in Oracle](https://www.ennicode.com/tag/explain-plan-in-oracle/) - [hashtable](https://www.ennicode.com/tag/hashtable/) - [hashjoin](https://www.ennicode.com/tag/hashjoin/) - [plan_table](https://www.ennicode.com/tag/plan_table/) - [oracle plan_table](https://www.ennicode.com/tag/oracle-plan_table/) - [Oracle List Tables in Database](https://www.ennicode.com/tag/oracle-list-tables-in-database/) - [Oracle SQL connect by](https://www.ennicode.com/tag/oracle-sql-connect-by/) - [performance Tunning](https://www.ennicode.com/tag/performance-tunning/) - [Oracle Performance Tuning Interview Questions](https://www.ennicode.com/tag/oracle-performance-tuning-interview-questions/) - [Oracle sql Interview Questions](https://www.ennicode.com/tag/oracle-sql-interview-questions/) - [Oracle sql Interview Questions and answers](https://www.ennicode.com/tag/oracle-sql-interview-questions-and-answers/) - [bulk collect in oracle](https://www.ennicode.com/tag/bulk-collect-in-oracle/) - [bulk collect oracle](https://www.ennicode.com/tag/bulk-collect-oracle/) - [oracle forall](https://www.ennicode.com/tag/oracle-forall/) - [forall oracle](https://www.ennicode.com/tag/forall-oracle/) - [oracleforall](https://www.ennicode.com/tag/oracleforall/) - [Date in WHERE Clause](https://www.ennicode.com/tag/date-in-where-clause/) - [Oracle change column data type](https://www.ennicode.com/tag/oracle-change-column-data-type/) - [change column data type](https://www.ennicode.com/tag/change-column-data-type/) - [SQL change column data type](https://www.ennicode.com/tag/sql-change-column-data-type/) - [Types of Indexes in Oracle](https://www.ennicode.com/tag/types-of-indexes-in-oracle/) - [Indexes in Oracle](https://www.ennicode.com/tag/indexes-in-oracle/) - [Types of Indexes](https://www.ennicode.com/tag/types-of-indexes/) - [Distinct count in Oracle](https://www.ennicode.com/tag/distinct-count-in-oracle/) - [Distinct count Oracle](https://www.ennicode.com/tag/distinct-count-oracle/) - [Distinct count in sql](https://www.ennicode.com/tag/distinct-count-in-sql/) - [Oracle cast string to date](https://www.ennicode.com/tag/oracle-cast-string-to-date/) - [sql cast string to date](https://www.ennicode.com/tag/sql-cast-string-to-date/) - [cast string to date oracle](https://www.ennicode.com/tag/cast-string-to-date-oracle/) - [database cast string to date](https://www.ennicode.com/tag/database-cast-string-to-date/) - [TO_DATE function](https://www.ennicode.com/tag/to_date-function/) - [oracle TO_DATE](https://www.ennicode.com/tag/oracle-to_date/) - [Oracle SQL limit rows](https://www.ennicode.com/tag/oracle-sql-limit-rows/) - [oracle sql row limit](https://www.ennicode.com/tag/oracle-sql-row-limit/) - [limit rows in oracle sql](https://www.ennicode.com/tag/limit-rows-in-oracle-sql/) - [sql oracle limit rows](https://www.ennicode.com/tag/sql-oracle-limit-rows/) - [common table expression](https://www.ennicode.com/tag/common-table-expression/) - [common table expressions](https://www.ennicode.com/tag/common-table-expressions/) - [cte in sql](https://www.ennicode.com/tag/cte-in-sql/) - [cte in database](https://www.ennicode.com/tag/cte-in-database/) - [common table expressions sql](https://www.ennicode.com/tag/common-table-expressions-sql/) - [sql common table expressions](https://www.ennicode.com/tag/sql-common-table-expressions/) - [sql coalesce function](https://www.ennicode.com/tag/sql-coalesce-function/) - [COALESCE SQL](https://www.ennicode.com/tag/coalesce-sql/) - [COALESCE](https://www.ennicode.com/tag/coalesce/) - [SQL COALESCE](https://www.ennicode.com/tag/sql-coalesce/) - [coalesce in sql](https://www.ennicode.com/tag/coalesce-in-sql/) - [check sql version](https://www.ennicode.com/tag/check-sql-version/) - [sql version command](https://www.ennicode.com/tag/sql-version-command/) - [oracle database version](https://www.ennicode.com/tag/oracle-database-version/) - [mysql version](https://www.ennicode.com/tag/mysql-version/) - [sql server version](https://www.ennicode.com/tag/sql-server-version/) - [postgresql version check](https://www.ennicode.com/tag/postgresql-version-check/) - [snowflake sql version](https://www.ennicode.com/tag/snowflake-sql-version/) - [SQL DECLARE Variable](https://www.ennicode.com/tag/sql-declare-variable/) - [LEFT JOIN in SQL](https://www.ennicode.com/tag/left-join-in-sql/) - [sql database](https://www.ennicode.com/tag/sql-database/) - [LEFT JOIN SQL](https://www.ennicode.com/tag/left-join-sql/) - [sql left join](https://www.ennicode.com/tag/sql-left-join/) - [sql joins left outer](https://www.ennicode.com/tag/sql-joins-left-outer/) - [what is left join in sql](https://www.ennicode.com/tag/what-is-left-join-in-sql/) - [SQL Performance Tuning](https://www.ennicode.com/tag/sql-performance-tuning/) - [SQL Performance](https://www.ennicode.com/tag/sql-performance/) - [SQL Tuning](https://www.ennicode.com/tag/sql-tuning/)