The Oracle return error call “ORA-00933: SQL command not properly ended” once execute a DML operation. That indicates that there’s a problem with your SQL statement syntax. This error triggers ...
In this short article, I’m going to be the explanation of the 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 is ...
Oracle SQL developer is a great tool for doing various tasks in the Oracle database. This powerful tool allows you to do hundreds of tasks including exporting query results to ...
Oracle can we delete temp tablespace? Yes, it is. Deleting a temporary tablespace in Oracle is a significant database operation that requires extra caring and understanding of its consequences. This ...
Exception handling is most important in any programming and the same rule applies with Oracle. When a user need to raise a user-defined error from the application raise_application_error allows you ...
This is related to MOD Oracle SQL function. I hope to write about the simple example of mod in Oracle SQL and the invalid use of mod in Oracle plsql ...
Before moving on to the 4 Pillars of OOP I would like to add a small recap on what is Object-Oriented Programming (OOP). OOP is one of the famous techniques ...
Oracle SQL comparing dates is not complicated but you have to follow the correct syntax and match targeting columns. Otherwise, need to convert column types into the same matching data ...
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 ...
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 ...