-
Recent Posts
- How to generate self-signed X.509 certificates for local development (Nginx)
- Gpg – can’t connect to `/home/${USER)/.gnupg/S.gpg-agent’: No such file or directory
- Oracle Null Safe Comparison (Spoiler alert: SYS_OP_MAP_NONNULL)
- Git – Moving folders with history and all related branches
- Installation of Oracle SQL Developer to Ubuntu
Categories
Blog Stats
- 362,078 hits
Archives
Blogroll
Meta
Category Archives: Oracle
Oracle Null Safe Comparison (Spoiler alert: SYS_OP_MAP_NONNULL)
Even most experienced programmers are caught null comparison trap time to time. Let’s say we have two different customer tables and our business need is to find the customers that has the same first name, middle name and last name … Continue reading
Installation of Oracle SQL Developer to Ubuntu
First of all, you need to install Java in your environment. I will continue with the latest OpenJDK version currently available. Easiest method to install jdk is to write following commands to the terminal: And put below content inside of … Continue reading
Posted in Linux, Oracle, Shell Script
Tagged Linux, ORACLE, SQL, SQL Developer, Ubuntu
Leave a comment
Getting result from database in shell script
In shell script, there is no standard way of connecting and retrieving result from database. But, for Oracle we can use SQLPlus to connect and run operations on database. I tried my codes on bash for this post and codes … Continue reading
Posted in Linux, Oracle, Shell Script
Tagged Linux, ORACLE, Shell Script, SQL, Sqlplus
Leave a comment
Oracle Time Overlaps (WM_OVERLAPS)
Oracle has undocumented and documented functions for time operations. In this writing, I will mention the undocumented ‘overlaps’ and documented ‘wm_overlaps’ functions. Actually, they do the same work, but they have some differences. Our aim is to find that two … Continue reading
Create Html Table From Oracle Table In PL/Sql
Sometimes we need to represent a database table as HTML table. In such situations there is no standart way of doing this. So that, I write a Oracle package for converting sql query to html table code with using Oracle … Continue reading
Oracle Import Mining Model to Database
You can import your mining models to Oracle database and you can easily call those models from select statements and procedures. In this post I will try to explain how to do that. First of all you must create a … Continue reading
Java Prepared Statements (Oracle Cursor Sharing & Bind Variables)
My last post is about Oracle bind variables and cursor sharing. In this post, I will talk about how to use and how not to use sql queries in Java. Let’s make a basic sql query and analyze the performances … Continue reading
Posted in Java, Oracle
Tagged Bind Variable, Cursor Sharing, Java, ORACLE, PL-SQL, PL/SQL, Prepared Statements, SQL
2 Comments
Oracle Cursor Sharing & Bind Variables
In Oracle, queries are kept in Shared Pool to improve performance. If we send the query which is already in Shared Pool, Oracle may pass the parsing part and use the same execution plan for that query. Oracle compares these … Continue reading
Posted in Oracle
Tagged Bind Variable, Cursor Sharing, Exact, Force, Literals, ORACLE, PL-SQL, PL/SQL, Similar, SQL
Leave a comment
ORA-30926: unable to get a stable set of rows in the source tables
In my recent project I get this error while I’m using Merge in Oracle. After some searching I found the problem and decided to write a post about it:) The reason of this error is source table. In merge queries … Continue reading