Hi guys, Welcome to the Advanced Video Search Engine, and you are watching DDL Commands (Data Definition Language) in Oracle. That video is uploaded by Tech Talk's with Naresh at 2019-11-29T13:23:46-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [yO5I8kDEyFY]
| Name | DDL Commands (Data Definition Language) in Oracle |
| Video Uploader | Video From Tech Talk's with Naresh |
| Upload Date | This Video Uploaded At 29-11-2019 21:23:46 |
| Video Discription | This video will help them who are in the learning phase of SQL. If you have any doubt's regarding this video write in comment section. If you want any other video related to SQL please comment in comment section. Please Like,Share and Subscribe the video. DDL Commands: Create: Syntex: create table table_name (column1 data_type1, column2 data_type2, column3 data_type3, column4 data_type4); E.g: CREATE TABLE Demo ( customer_number NUMBER PRIMARY KEY, Customer_name VARCHAR2(100), bank_name VARCHAR2(100), Account_Number NUMBER, Acc_start_date DATE, Balance DECIMAL(10,2) ); ALTER: Syntex: alter table demo add bank_Code number; E.g: ALTER TABLE demo ADD address varchare2(200); DROP: Syntex: Drop table table_name; E.g: DROP TABLE demo; TRUNCATE: Syntex: Truncate table table_name; E.g: TRUNCATE TABLE demo; yO5I8kDEyFY |
| Category | Education |
| Tags | Database | SQL | PLSQL | MYSQL | DBMS | Example | Data Definition Language | Examples |
