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

 

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 October 21st, 2017 at 11:08 amIntroduction to Oracle sql decode In this section we will discuss about Oracle 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.Oracle Decode transform data values at retrieval time. It is a type of … 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

Last updated on March 20th, 2017 at 03:57 amHere  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 … Continue reading Most commonly asked 25 oracle plsql interview questions »

Top-N Queries and Pagination

Top-N Queries  and Pagination is common in Web-based applications. The user inputs a set of criteria, which runs a query and then lets the user click the Previous and Next buttons to page through the result set. To achieve this paging functionality, the application needs to be able to get a certain set of rows from the Database query. Lets take a look at the … Continue reading Top-N Queries and Pagination »

How to use external tables in Oracle with example

Last updated on October 27th, 2016 at 04:09 pmExternal table is one of the important feature in oracle , we will exploring external table in oracle with example in this post What are EXTERNAL TABLES in Oracle? 1)External tables are read only tables where the data is stored in flat files outside the database 2) You can user external table feature to access external files as … Continue reading How to use external tables in Oracle with example »

What is Sequences in oracle

Last updated on October 27th, 2016 at 06:14 pmWhat is Sequences in oracle Sequence is a user created object which can be shared by multiple users to generate unique integers The most general use of sequences would be to generate primary key column in the table. The sequence is generated by oracle internal routine so we don’t need to worry about . It will save … Continue reading What is Sequences in oracle »

What are Oracle Joins, Set and Subqueries

joins,set and subqueries

Last updated on August 17th, 2016 at 04:57 pmSometimes you need to display data from multiple tables. In order to perform that you need to link one table to another table. There are various ways in which we can obtain data from Multiple tables.I would be giving details on  Joins, Set and Subqueries Join A Join is a query that combines rows from two or … Continue reading What are Oracle Joins, Set and Subqueries »

How to create Oracle views

Last updated on December 24th, 2017 at 04:17 pmTable of content What is Oracle  view Privileges Required to create oracle view How to Modify the Oracle View How to recompile the Oracle view How to drop the Oracle view How to perform DML operations on Oracle View Creating Force Oracle Views What happens to view if the base tables are dropped Dictionary Views for seeing … Continue reading How to create Oracle views »

Aggregating Data Using Group Functions

As part of learning sql,Here is good detail on Aggregating Data Using Group Functions Group Functions unlike single value functions operate on set of of rows and return one rows per group.  The set of rows may be whole table or the table split into groups Types of Group Functions include: AVG([Distinct/all]  n) Numeric datatypes only. Average value of the column n ignoring null values COUNT({*/[Distinct/all]expr}) … Continue reading Aggregating Data Using Group Functions »

Oracle Indexes and types of indexes in oracle with example

types of indexes in oracle with example

Last updated on September 17th, 2016 at 06:37 pmWe will be discussing Oracle indexes/types of indexes in oracle with example  in this post. I will through light on all the option on how to create index in oracle.I would also be discussing  how to check index size in oracle. I hope you will like this post. I will be looking forward for  feedback on this … Continue reading Oracle Indexes and types of indexes in oracle with example »