how to use select statement and sql plus commands - learn oracle tutorail 6
in this video i will show you how to use select statement and sql plus commands and many more, join our group for more detail / 242999206136244 ,
The Four main categories of SQL statements are as follows:
1. DML (Data Manipulation Language)
2. DDL (Data Definition Language)
3. DCL (Data Control Language)
4. TCL (Transaction Control Language)
--------------------------------------------------------------------------
DML statements include the following:
SELECT – select records from a table
INSERT – insert new records
UPDATE – update/Modify existing records
DELETE – delete existing records
--------------------------------------------------------------------------
DDL statements are used to alter/modify a database or table structure and schema. These statements handle the design and storage of database objects.
CREATE – create a new Table, database, schema
ALTER – alter existing table, column description
DROP – delete existing objects from database
--------------------------------------------------------------------------
DCL statements control the level of access that users have on database objects.
GRANT – allows users to read/write on certain database objects
REVOKE – keeps users from read/write permission on database objects.
--------------------------------------------------------------------------
TCL statements allow you to control and manage transactions to maintain the integrity of data within SQL statements.
BEGIN Transaction – opens a transaction
COMMIT Transaction – commits a transaction
ROLLBACK Transaction – ROLLBACK a transaction in case of any error.
-------------
.---------------------------------------------------------------------------------------------------------.
video courses- list of playlist :
tips and trics
link► • tips and tricks
command prompt commands:
link► • command prompt commands
oracle sql:
link► • oracle sql
c programming:
link► • c++ programming
.-----------------------------------------------------------------------------------------------------------.
watch more videos:
learn oracle sql online overview tutorail :
• learn oracle sql online overview tuto...
how to fix or repair a corrupted usb flash drive or cd card using command prompt:
https://www.youtube.com/edit?video_id...
how to copy a folder using cmd:
https://www.youtube.com/watch?v=Lblhb...
how to move a folder using cmd:
https://www.youtube.com/watch?v=YFfHZ...
how to dell files in cmd:
https://www.youtube.com/watch?v=3-lqg...
how to make and remove directory:
https://www.youtube.com/edit?video_id...
how to change color and title in cmd:
https://www.youtube.com/edit?video_id...
how to change directory in command prompt:
https://www.youtube.com/watch?v=SmLYx...
.-----------------------------------------------------------------------------------------------------------.
social media links:
join our group:
► / 24299. .
► Follow on Google+: http://[email protected]
► Follow on Twitter: / @rananavi4766669 :