Category Archives: Oracle Sql

Sql  stands for Structured Query Language. is the language to communicate with  the rdbms.  plsql is the programming part of sql

Oracle sql and plsql are the languages which are widely used. They are easy to learn and apply. Here I would be listing out all the articles on Oracle sql and plsql

I am starting the basics so it is very helpful for the beginners to run sql and plsql here

 

How to resolve ORA-00904: invalid identifier

ORA-00904: invalid identifier is one of the common error seen. Reference: Oracle documentation One of the most common cause of this error Invalid identifier means the column name entered is either missing or invalid. It also Some time comes  when you used reserved word in Oracle database. Check List to resolve the ORA error  It comes when you put extra comma in the create table … Continue reading How to resolve ORA-00904: invalid identifier »

How to work with date in Oracle sql

This post I am trying to explain many things  about oracle date datatype like oracle sql date functions,oracle sql date format, oracle sql date comparison, oracle date difference in  years,oracle date difference in  days, oracle date difference in  months Oracle has provided date and timestamp type for storing the date and time information in the database. Date Type DATE is the datatype that we are all familiar with … Continue reading How to work with date in Oracle sql »

How to resolve ORA-06512 at line num

ORA-06512  is one of the common error seen in PLSQL programs. Here is what documentation says about this error Reference :Oracle documentation Explanation of the error: Error Ora-06512 means the backtrace message as the stack is being unwound by unhandled exceptions in your PLSQL code. This is a catch-all error for PLSQL exceptions and is commonly seen. Ora-06512 does not indicate the actual error, but … Continue reading How to resolve ORA-06512 at line num »

Oracle PLSQL Tables

PLSQL tables are composite datatypes. These behave in the same way as arrays except that have no upper bounds, allowing them to constantly extend. They are also called index by table PLSQL Table contains two elements 1) A primary key of BINARY_INTEGER datatypes that index the table, which do not need to be consecutive. The collection is extended by assigning values to an element using … Continue reading Oracle PLSQL Tables »

Everything about Oracle PLSQL records

Oracle PLSQL records PLSQL records are composite datatypes .It is a group of related data items as fields ,each with its own name and datatype. PL/SQL records are similar in structure to a row in a database table. Each scalar data types in the record holds a value. A record consists of components of any scalar, PL/SQL record, or PL/SQL table type. They can be … Continue reading Everything about Oracle PLSQL records »

Top 40 Oracle sql interview questions

This article contains Top 40  Oracle sql interview questions asked in various interview. I hope it should help in interviews 1) What is a table Cluster ? Answer: Table Cluster is a group of related tables that share common columns are store related data in the same block. 2) What is exists usage in sql Answer “exists” statement helps us to do the job of … Continue reading Top 40 Oracle sql interview questions »

Oracle PLSQL Block Structure and Oracle PLSQL Variable

Here we will be discussing about Oracle PLSQL Block Structure and Oracle PLSQL Variable Table of content What is PL/SQL Why Use PLSQL PLSQL Block Structure PLSQL Block Types Difference  Between  Function and Procedure Oracle PLSQL Variables Scope of Oracle PLSQL Variables What is PL/SQL PL/SQL is Oracle’s proprietary extension to SQL that allowsfor procedural language capabilities. It gives all the features of modern software … Continue reading Oracle PLSQL Block Structure and Oracle PLSQL Variable »

Things you need to know about Oracle SQL developer

This is a post on Things  you need to know about Oracle SQL developer .I hope you will like it.Please do provide feedback Table of content Introduction to Oracle SQL developer How to perform Oracle SQL developer download How to install Oracle sql developer How to migrate the connection How to Uninstall Oracle SQL Developer Favorite SQL Developer Shortcuts FAQ for Oracle SQL developer How … Continue reading Things you need to know about Oracle SQL developer »

Oracle Create User , System Privileges and Oracle Object Privileges

We will be posting information on User access and security in oracle database.This post will give good information on  Oracle Create User  , System Privileges and Oracle Object Privileges,How to show all privileges from a user in oracle CREATE USER statement  It is employed to create a user (schema). The default authentication for a new user is the database. The user is assigned password, and … Continue reading Oracle Create User , System Privileges and Oracle Object Privileges »

Oracle sql decode processing

Introduction to Oracle sql decode In this section we will discuss about Oracle sql decode processing which is very important aspect in Oracle sql statement Oracle sql decode is the method in Oracle database to  transform data values for one value to another which is better to understand.Decode transform data values at retrieval time. It is a type of If then else for the processing The code … Continue reading Oracle sql decode processing »

ORA-00911: invalid character Common Issues and Resolution

As per OERR,ORA-00911: invalid character Cause: identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after the first character. Identifiers enclosed by doublequotes may contain any character other than a doublequote. Alternative quotes (q’#…#’) cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL Language Reference Manual. Action: None ORA-00911 exception … Continue reading ORA-00911: invalid character Common Issues and Resolution »

Most commonly asked 25 oracle plsql interview questions

Here  is the compilation of Most commonly asked oracle plsql interview questions Q1) What is Oracle plsql? Answer PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and procedural programming language Q2) What are the components of a PL/SQL Block? Answer Declarative part, Executable part and Exception part. Q3) What are the datatypes a available … Continue reading Most commonly asked 25 oracle plsql interview questions »