web analytics

Category: Oracle PL/Sql

Attach files with email PL/SQL

1) If we want to attach a file inside a directory on the server, it is mandatory to use an Oracle directory previously created. We can not reference a server directory directly.  For example: if...

Table statistics Oracle SQL query

To see statistics of a table in Oracle create any table and insert data, search the table in that view:  select * from all_tables where TABLE_NAME = ‘TABLE’;  You will see how this view...

Bind Variables in PL/SQL

Let’s see an example of bind variables , since they are often quite useful in many cases, with them we can unify many processes and operations: First of all we need to create a...

Improve SQL query performance

This post is about to improve SQL performance in oracle PL/SQL procedures, functions or views. ( can be said performance tuning of your queries.) First of all, we must take into account when making...

DDL vs DML

What are DDL and DML is a very common question, i will explain here some basics for those who are new to databases. SQL statements are divided into two DDL and DML categories, Data...

Remove duplicate records PL/SQL

One of the important steps to perform after loading data into database is to find and eliminate duplicate records. I will not go into the details that how duplication produce errors, but I will...

Indexes

Indexes are optional data structures associated with tables that improve the speed of operations, allowing quick access to data in a table. They allow to increase the execution speed of sentences in a shady...

error: Content is protected !!