Oracle DDL | DDL | Data Definition Language - oracle tutorial - sql tutorial



What is Data Definition Language (DDL) in oracle ?

  • Data Definition Language (DDL) statements are used to define the database structure or schema.
  • Oracle Command Types
  • The schema to perform these functions are,

CREATE:

  • It is used to create tables in the database.
Oracle create table with normal

Learn oracle - oracle tutorial - Oracle create table with normal - oracle examples - oracle programs

CREATE TABLE [table name] ( [column definitions] ) [table parameters]
click below button to copy the code. By - oracle tutorial - team

ALTER :

  • It is used to alters the structure of the database
Oracle alter table

Learn oracle - oracle tutorial - Oracle alter table - oracle examples - oracle programs

ALTER table tablename parameters.
click below button to copy the code. By - oracle tutorial - team

DROP :

  • It is used to delete the INDEX,TABLE and DATABASES in Drop Statement.
Oracle drop table

Learn oracle - oracle tutorial - Oracle drop table - oracle examples - oracle programs

DROP table tablename.
click below button to copy the code. By - oracle tutorial - team
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

TRUNCATE :

  • It is used to remove all records from a table.
  • Including all spaces allocated for the records are removed.
Oracle truncate table

Learn oracle - oracle tutorial - Oracle truncate table - oracle examples - oracle programs

TRUNCATE TABLE table_name;  
click below button to copy the code. By - oracle tutorial - team

COMMENT :

  • It is uses to add comments to the data dictionary

RENAME:

  • It used to rename the table from old name to new name.
Oracle alter table rename column

Learn oracle - oracle tutorial - Oracle alter table rename column - oracle examples - oracle programs

RENAME TABLE old_name TO new_name;
click below button to copy the code. By - oracle tutorial - team

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning

Related Searches to Oracle DDL | DDL | Data Definition Language