Home
Videos uploaded by user “Oracle 12c Tutorials for Beginners”
Oracle SQL PLSQL 12C Tutorial 11 - CREATE table from other table
 
03:06
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 3 - How to Install TOAD (Oracle Client) on Window 8 and 8.1
 
05:52
This Video will Provide the step by step installation of TOAD, which is oracle database 12c , 11g, 10g, 9i, 8i client. Installation of oracle is not sufficient. We need a oracle client to work with. It is possible work with server, but only if you have working on stand-alone or personal computer. But If you are working on network, where oracle database will be installed only on one computer i.e. server. Then to work with that server or interact with that installed oracle database you need a oracle client. TOAD is one of the popular client available in the market. There are others too. Let start with the installation of oracle database client TOAD.
Oracle SQL PLSQL 12C Tutorial 4 - Create New User
 
07:15
This Video Tutorial Will Describe how to create 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. Full Syntax will be given in this video tutorial about how to create a new user in oracle database. Along with the live example of the new user creating. In this video tutorial, we will create a new sample user like XYZ. Then we will see how many other users are available using ALL_USER table, which is a predefined table available in oracle. Before the creation of new user and after the creation of the new table, we will examine the list of available user in oracle database.
Oracle SQL PLSQL 12C Tutorial 5 - How to create new Table
 
08:36
This Video Tutorial Will Describe how to create a new 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. Full Syntax will be given in this video tutorial about how to create a new table in oracle database. Along with live example of new table creation . In this video tutorial we will create a new sample table. All the keywords, format, mandatory clauses etc are described in this video. As example we create new table with different datatypes and length of data that can be stored in that table. Many columns will be created that can store alphanumeric, numeric , date etc.
Oracle SQL PLSQL 12C Tutorial 10 - ORDER BY Clause, Sorting Data
 
05:22
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 7 - How to Insert Record or Data in Table
 
04:23
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 1 - How to Install Oracle Database 12c on Window 8 and 8.1
 
05:54
This video will provide the step by step installation of Oracle Database 12c on Window 8 or 8.1. Also it will give information about where you can download the oracle database 12c. Please like and subscribe this channel. Also comment about your any requirement related to Oracle. Thank you.
Oracle SQL PLSQL 12C Tutorial 12 - INSERT Data from other table
 
03:30
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.
Oracle SQL PLSQL 12C Tutorial 9 - DISTINCT Command, Unique Data
 
04:33
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 2 - How to Install PLSQL Developer (Oracle Client) on Window 8 and 8.1
 
01:23
This Video will Provide the step by step installation of PLSQL Developer, which is oracle database 12c , 11g, 10g, 9i, 8i client. Installation of oracle is not sufficient. We need a oracle client to work with. It is possible to work with server, only if you have working on stand-alone or personal computer. But If you are working on network, where oracle database is installed on one computer i.e. server. To work with that server or interact with that installed oracle database you need oracle client. PLSQL developer is one of the popular client available in the market. There are others too. Let start with the installation of oracle database client PLSQL Developer.
Oracle SQL PLSQL 12C Tutorial 19 - Default Value
 
04:32
This Video Tutorial Will Describe how to set the default value of the column. 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. DEFAULT clause is used to set the value for the table column. DEFAULT clause insert the predefined value into the column if you left it blank while inserting the column. Full Syntax will be given in this video tutorial about how to use the DEFAULT clause. Along with live example to demonstrate DEFAULT clause. All the keywords, format, mandatory clauses etc are described in this video.
Oracle SQL PLSQL 12C Tutorial 13 - DELETE Statement
 
03:27
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 6 - How to Give Grant to New User
 
01:33
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, 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.
Oracle SQL PLSQL 12C Tutorial 14 - UPDATE Statement
 
05:49
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 8 - SELECT Command , Fetch Data from Table
 
09:41
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 12C Tutorial 20 - Constraints (Primary, Foreign, Unique, Null etc.)
 
19:41
This Video Tutorial Will Describe about various constraints we can use with tables. Some of the constraints can used as table level or column level so also known as table level constraints and column level constraints. These 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. In this video i explain Not Null Constraint, Unique key Constraint, Primary Key Constraint, Foreign Key - Reference key Constraint, Check constraint and user_constraints table. Full Syntax will be given in this video tutorial about how to use these constraints. Along with live example to execute Not Null Constraint, Unique key Constraint, Primary Key Constraint, Foreign Key - Reference key Constraint, Check constraint and user_constraints table . All the keywords, format, mandatory clauses etc are described in this video.
Oracle SQL PLSQL 12C Tutorial 18 - Computation / Functions Part 2
 
08:38
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, MAX, SUM, ABS, POWER, ROUND, SQRT, LOWER, INITCAP, UPPER, SUBSTR, LENGTH, LTRIM, RTRIM, LPAD, RPAD ETC. All the commands explained with syntax and example.
Oracle SQL PLSQL 12C Tutorial 22 - Computation / Functions Part 3
 
11:29
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 TO_NUMBER, TO_CHAR, TO_DATE, ADD_MONTHS, LAST_DAY, MONTHS_BETWEEN, NEXT_DAY ETC. All the commands explained with syntax and example. Gymnopedie No 3 by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Source: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100785 Artist: http://incompetech.com/
Oracle SQL PLSQL 12C Tutorial 15 - ALTER Statement
 
08:54
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 16 - RENAME & DROP Statement
 
04:44
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 21 - Group By, Having Clause
 
02:52
This Video Tutorial Will Describe about using GROUP BY and HAVING CLAUSE to group the data of rows based on conditions. These 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. In this video i explain how to use GROUP BY CLAUSE to group the column value of multiple rows. And HAVING Clause to use conditions to group only certain rows. Full Syntax will be given in this video tutorial about how to use these constraints. Along with live example of using GROUP BY and HAVING Clause. All the keywords, format, mandatory clauses etc are described in this video. Gymnopedie No 3 by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Source: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100785 Artist: http://incompetech.com/
Oracle SQL PLSQL 12C Tutorial 17 - Computation / Functions Part 1
 
24:15
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 23 – Date Manipulation
 
03:10
This video describes the various Date Manipulation methods that we can use on table data. This includes To_char, To_date, Date formats etc. It includes the following functions that include, TO_CHAR, TO_DATE, ‘TH’, ‘SP’, ‘SPTH’ ETC. All the commands explained with syntax and example. Gymnopedie No 3 by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Source: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100785 Artist: http://incompetech.com/