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

 

Oracle Indexes and types of indexes in oracle with example

types of indexes in oracle with example

Last updated on March 30th, 2018 at 10:43 amWe 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 »

Single row functions in sql

Last updated on September 18th, 2016 at 09:01 amThis is part of series on how to learn sql Functions are programs that take zero or more arguments and return a single value. Functions can be single row ,mutiple row functions We will be discussing here Single row functions in sql What is single row functions in sql Single-row functions are built-in functions and include character, … Continue reading Single row functions in sql »

good Oracle sql examination questions with answer

Last updated on December 31st, 2015 at 06:05 pmHere are some of good Oracle sql examination questions with answer 1. You must permanently remove all data from the sales_data table, but will need the table structure in the future. What single command should be issued? a. DROP TABLE sales_data b. TRUNCATE TABLE sales_data c. DELETE FROM sales_data d. TRNCATE TABLE sales_data KEEP STRUCTURE; Solution :(b) … Continue reading good Oracle sql examination questions with answer »

Good Question for Oracle Sql

Here I am giving few good questions from Oracle Sql domain.Please do try these. Answer and explanation is provided 1) You need to create a report to display the ship date and order totals of your order table. If the order has not been shipped your report must display not shipped. If the total is not available your report must say not available. In the … Continue reading Good Question for Oracle Sql »

Oracle SQL*Plus: Basics part 1

Here in this post,I would be giving introduction to Oracle sqlplus  which is Oracle tools to connect to database . Oracle SQL*Plus: Basics part 1 What is Sqlplus: 1) SQL*Plus, widely used by DBAs and developers, is a powerful and straightforward tool from Oracle to interact with the database. 2) SQL*Plus has its own formatting commands to make your queries look better, as well as … Continue reading Oracle SQL*Plus: Basics part 1 »

Oracle sql: order by and distinct clause

In this section of Oracle sql,we will discuss about order by and distinct clause Define a null value: If a column in a table has no assigned value , then the column is said to be null for that row. A null is a value that is unavailable,unassigned ,unknown. A null is not same as zero or space. Zero is a number and space is … Continue reading Oracle sql: order by and distinct clause »

Oracle sql tutorial :Restricting the data set

So far in earlier oracle sql tutorial, we have learned about select from the table where all the rows are being returned. Now in this Oracle sql tutorial we learn about restricting the date set (number of rows selected) from the table. This is achieved through where clause in the sql statement Basic sql statment with where clause is of the form select [Distinct] { … Continue reading Oracle sql tutorial :Restricting the data set »