Oracle SQL PLSQL 12C Tutorial 17 – Computation Part 1

This video describes the various computation methods that can be done on table data and values. This includes arithmetic operators, renaming columns, logical operators, NOT operator, range searching, pattern matching, Oracle functions, string functions, numeric functions, a conversion function, date function.

It includes the following functions that include, AVG, MIN, COUNT, BETWEEN, AND, OR, NOT, NOT IN, LIKE ETC.

All the commands explained with syntax and example.

Oracle SQL PLSQL 12C Tutorial 16 – RENAME & DROP Statement

This Video Tutorial Will Describe how to change the name of a table or how to delete the existing table. 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.

RENAME command is used to change the name of the table to new name. DROP command is used to delete the existing table permanently along with all its data.

Full Syntax will be given in this video tutorial about how to use the RENAME & DROP command.

Along with the live example to RENAME AND DROP table command.

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

Oracle SQL PLSQL 12C Tutorial 15 – ALTER Table Statement

This Video Tutorial Will Describe how to change the structure of an existing table. 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.

This command is used to add, modify or delete the columns from the table. You can add, modify or delete a single column or multiple columns at a time.

Full Syntax will be given in this video tutorial about how to use the ALTER table command.

Along with the live example to add, modify or delete the columns from the table.

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

Oracle SQL PLSQL 12C Tutorial 14 – UPDATE Statement

This Video Tutorial Will Describe how to update a row or update column or update particular value 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.

This command is used to update or modify the inserted data into the table. You can update single column, single row, multiple columns or multiple rows with this command.

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

Along with the live example to update rows or columns from the table.

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

Oracle SQL PLSQL 12C Tutorial 13 – DELETE Statement

This Video Tutorial Will Describe how to delete a row or delete 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.

Sometimes you delete to delete some unwanted rows or data from the table. Delete command is used to do that. But it does not permanently delete rows, you can restore or rollback the deleted rows before commit.

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

Along with the live example to delete rows from the table.

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

 

Oracle SQL PLSQL 12C Tutorial 12 – INSERT Data from another table

This Video Tutorial Will Describe how to insert values or data into a table from another 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. But sometimes you just need to copy the data from one table to other or make a backup of the data of a table. Example to insert data from one table into the other table.

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

Along with the live example to insert records from one table to another table.

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

 

Create a website or blog at WordPress.com

Up ↑