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

 

Helpful overview about Oracle cursor

Last updated on September 17th, 2017 at 05:17 pmOracle Cursor Oracle Uses work area called Private SQL areas to execute SQL Statements and store information. A Oracle Cursor is a PL/SQL construct that allows you to name these work areas, and to access their stored information Types of Oracle Cursor Implicit Cursor in Oracle Explicit Cursor in Oracle   Implicit cursor in Oracle Explicit Cursor … Continue reading Helpful overview about Oracle cursor »

How to alter table add column oracle

Last updated on April 1st, 2017 at 08:11 am-You Add a new column using the ALTER TABLE statement. – The table must be contained in your schema To alter a table, or you should either have  ALTER object privilege for the table or the ALTER ANY TABLE system privilege. -If a view, materialized view, trigger,  function-based index, check constraint, function, procedure of package depends on a base table, the … Continue reading How to alter table add column oracle »

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

Last updated on April 1st, 2017 at 10:02 amThis 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 … 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

Last updated on March 22nd, 2017 at 04:52 amThis 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” … 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

Last updated on April 22nd, 2017 at 01:06 pmWe 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   Table of content CREATE USER statement Oracle System Privileges User System privileges Oracle Object Privileges What is a … Continue reading Oracle Create User , System Privileges and Oracle Object Privileges »

Oracle sql decode processing

Last updated on December 12th, 2016 at 05:48 pmIntroduction 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 … Continue reading Oracle sql decode processing »