Oracle SQL PLSQL 12C Tutorial 11 – CREATE table from other table

This Video Tutorial Will Describe how to CREATE TABLE from OTHER TABLE in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on.

Whenever you create a new table in oracle, you need to specify the columns and datatype and length of the table. But sometimes you need to create a table which is exactly same as the other table. you need the same structure as the other table have. So, in that case, you need not write the whole columns etc. This command will help you to do that.

Full Syntax will be given in this video tutorial about how to create a table from another table in oracle database.

Along with the live example to create the table from another table.

All the keywords, format, mandatory clauses etc are described in this video.

 

Oracle SQL PLSQL 12C Tutorial 10 – ORDER BY Clause, Sorting Data

This Video Tutorial Will Describe how to SORT data which is already inserted into the table in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on.

Whenever you create a new table in oracle, you insert the data as and when it comes. But you always need to get data in particular order. For that, we use ORDER BY clause with the SELECT statement to sort the data in ascending or descending order and retrieve it.

Full Syntax will be given in this video tutorial about how to insert records in oracle database table.

Along with the live example to get or print the sorted data in a SELECT statement with ORDER BY clause.

All the keywords, format, mandatory clauses etc are described in this video.

 

Oracle SQL PLSQL 12C Tutorial 9 – DISTINCT Command, Unique Data

This Video Tutorial Will Describe how to get DISTINCT OR unique values or data from a table in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on.

Whenever you create a new table in oracle, sometimes you just insert the duplicate data or sometimes you need to get only some columns of data which are duplicate but the row is unique. In that case, you need this DISTINCT clause.

Full Syntax will be given in this video tutorial about how to get unique records from oracle database table.

Along with the live example to get DISTINCT records.

All the keywords, format, mandatory clauses etc are described in this video.

Oracle SQL PLSQL 12C Tutorial 8 – SELECT Command , Fetch Data from Table

This Video Tutorial Will Describe how to select or retrieve values or data into a table in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on.

Whenever you create a new table in oracle, you need to insert some data into that table otherwise that table is not usable. Example to select data, to update data and delete data, you first need to insert some data. Then this part comes where you select the data from the table.

Full Syntax will be given in this video tutorial about how to select records from oracle database table.

Along with the live example to select records.

All the keywords, format, mandatory clauses etc are described in this video.

 

Oracle SQL PLSQL 12C Tutorial 7 – How to Insert Record or Data in Table

This Video Tutorial Will Describe how to insert values or data into the table in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on.

Whenever you create a new table in oracle, you need to insert some data into that table otherwise that table is not usable. Example to select data, to update data and delete data, you first need to insert some data.

Full Syntax will be given in this video tutorial about how to insert records in oracle database table.

Along with the live example to insert records.

All the keywords, format, mandatory clauses etc are described in this video.

In this video, I use the INSERT command to add an entire record into a table. When using the command you must also use the keyword VALUES. If you want to enter a null value (one that has no value) for a field you can use the keyword NULL. Be sure to put single quotes around data types that are not numbers. Values need to be entered in the order the fields appear in the table.

Oracle SQL PLSQL 12C Tutorial 6 – How to Give Grant to New User

This Video Tutorial Will Describe how to give grants to a new user in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on.

Whenever you create a new user in oracle, you need to give some specific or all grants to that particular user otherwise that user is not able to work at all. Example to create a new table, select data, insert data, for all this type of work your new user only be able to do if and only if proper grants has been given to that user. Otherwise, an error message will pop up.

Full Syntax will be given in this video tutorial about how to give grants to the newly created user in oracle database.

Along with the live example to give grants or authorization to the new user. In this video tutorial, we will give all grants to the new user i.e. DBA grant. All the facilities that a super user can do, we give those to this new user.

All the keywords, format, mandatory clauses etc are described in this video.

Create a website or blog at WordPress.com

Up ↑