SQL CREATE TABLE FROM ANOTHER TABLE We can create tables two ways they are 1) Using CREATE TABLE by specifying columns names, columns data types, columns data length. Syntax: CREATE TABLE <TableName> ( <ColumnName1> <DataType>(Length), <ColumnName2> <DataType>(Length)); Example CREATE TABLE EMPLOYEE (NAME Varchar2(20), ID Number(10)); 2) Using CREATE TABLE statement for target table and SELECT […]
Tag: Oracle
SQL ORDER BY
SQL ORDER BY Oracle allow data from a table to be viewed in a sorted order. The rows retrieved from the table will be sorted in either ascending or descending order depending on the condition specified in the SELECT statement. Syntax SELECT * FROM <TableName> ORDER BY <ColumnName1>,<ColumnName2> <[Sort Order]> The ORDER BY clause will […]
SQL DISTINCT
In this tutorial post, we are going discussing how to Eliminating Duplicate Records from the table. SQL DISTINCT The table could have duplicate row. In such case how to view only unique rows i.e distinct rows to achieve it DISTINCT clause can be used. The DISTINCT clause can be used to removing duplicate records from […]
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 […]
