Category: Oracle

Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.

SQL WHERE

SQL WHERE Statement In this tutorial post, we are going to discussing SQL WHERE statement in oracle data base. Oracle provides the option of using WHERE statement in an SQL query to apply a filter on the rows retrieved. When a WHERE clause is added to the SQL query, then query executing as follows. The […]

SQL SELECT

In this tutorial post, we are going to discussing SQL SELECT statement in oracle data base. Consider we have EMPLOYEE demo table which is using for the executing SELECT command. EMP_ID EMP_NAME EMP_DESIGNATION EMP_GENDER EMP_QUALIFICATION EMP_LOCATION 100 Narayanaswamy Sr.Software Engineer Male MCA Chennai 101 Kumar Quality Analyst Male B.Tech Chennai 102 Ramesh Database Administration Male B.Tech […]