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 Create table Syntax,Tip and Examples

Last updated on December 24th, 2017 at 02:29 pmThis article talks how to create table in Oracle,create table syntax in oracle,oracle create table example, Oracle is the most RDBMS used everywhere for system Table of content What is Oracle database Table How to create table in oracle create table syntax in oracle Privilege required to create table Other characteristics associated with table How to modify the … Continue reading Oracle Create table Syntax,Tip and Examples »

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 »

Oracle sql tutorial :Basic Sql statement

we have already discussed about sql in the previous post how to write sql queries Please go through the post if you not read before. It gives a brief introduction sql statement Here in this tutorial we will be presenting the Basic sql statement. Basic sql statment is of the form select [Distinct] { *,col alias…..} from table; The important takeways from this 1) select … Continue reading Oracle sql tutorial :Basic Sql statement »

how to write sql queries

Last updated on October 30th, 2015 at 05:28 pm Relational Database Management system(RDBMS) contains many tables . These tables are the basic storage in Database. Tables contains the information about something in the real world for example customers ,employees ,deptTables in the database contain zero to many rows. SQL which stands for “Structured Query Language” which is pronounced as “SQL” or “sequel . SQL is … Continue reading how to write sql queries »