Tag Archives: SQL

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: Then you can download Oracle SQL … Continue reading

Posted in Linux, Oracle, Shell Script | Tagged , , , , | Leave a comment

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

Posted in Oracle | Tagged , , , , , , , | 3 Comments

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

Posted in Oracle | Tagged , , , , , , | 1 Comment

Oracle Create External Table

Oracle lets you to use an organized files as a regular table. With that way, you can easily use select statements with your file. First of all, we need to create a logical directory name for Oracle on behalf of … Continue reading

Posted in Oracle | Tagged , , , , , , , , , , , , , , , , | 3 Comments

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 , , , , , , , | 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 , , , , , , , , , | Leave a comment

Oracle SQL Boolean Expressions

We use boolean expressions nearly all of our SQL’s. Boolean expressions are necessary to manipulate data according to business rules. But we must be careful, because SQL might return some values in Select statements, but this may not be what … Continue reading

Posted in Oracle | Tagged , , , , , , , , | Leave a comment