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

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×