Answer Posted / vijitha vijayan

DDL:-
Data definition language.
Mainly 3 commands are available here,create,Drop,Alter.
DML:
•Data manipulating language
•This wil mainly contains select,insert,delete,update operations
DETAILED SYTAX AND EXAMPLES:-
CREATE: SQL CREATE is the command used to create data objects, including everything from new databases and tables to views and stored procedures. In this lesson, we will be taking a closer look at how table creation is executed in the SQL world and offer some examples of the different types of data a SQL table can hold, such as dates, number values, and texts.
CREATE [TEMPORARY] TABLE [table name] ( [column definitions] ) [table parameters]
Ex: CREATE TABLE employees (
id INTEGER PRIMARY KEY,
first name VARCHAR(50) NULL,
last_name VARCHAR(75) NOT NULL,
dateofbirth DATE NULL
);
DROP: - To destroy an existing database, table, index, or view

Drop table tablename;

Ex: DROP TABLE employees;

ALTER: SQL ALTER is the command used to add, edit, and modify data objects like tables, databases, and views. ALTER is the command responsible for making table column adjustments or renaming table columns. New table columns can also be added and dropped from existing SQL tables.

Alter table tablename add tupilname datatype(“range”).

Ex: alter table orders add discount varchar(10);
Alter table orders modify column discount varchar(8,2);
Alter table orders drop column discount ;

•This wil mainly contains select,insert,delete,update operations

SELECT; SQL SELECT may be the most commonly used command by SQL programmers. It is used to extract data from databases and to present data in a user-friendly table called the result set.
•Select table tupile tablename
Ex: select customername from employe;

INSERT: To use the INSERT command, we must first have an understanding of where we would like to insert data and what types of data we want to insert. Do we plan on inserting numbers? Strings? Files? Let's return to the orders table we created in an earlier lesson.
•Insert into tablename(attributename) values(corresponding values that we are like to give)
Ex: Insert into employe (custname) value(“vijitha”);

DELETE: In the SQL world, databases, rows, and columns all have one thing in common: once a DELETE statement has been executed successfully against them, the data they once contained is lost forever! Be very careful with these commands and be sure to properly backup all data before proceeding with any type of DELETE command(s).

Delete from tablename where[include the condition];
Ex: Delete from employe where custname=vijitha;

UPDATE: SQL UPDATE is the command used to update existing table rows with new data values. UPDATE is a very powerful command in the SQL world. It has the ability to update every single row in a database with the execution of only a single query. Due to UPDATE's supreme authority, it is in your best interest to always include a WHERE clause when working with UPDATE query statements. That way, you will not accidentally update more rows than you intend to.
Udate tablename set any condition where any condition;
Ex: update orders set custname=’amith’ where age=’20’;

How to do paging with oracle?

1003

---

Explain enable novalidate constraint.

1089

---

How to convert characters to times in oracle?

1023

---

What is meant by raw datatype?

1063

---

How do we represent comments in oracle?

1052

---

How to check your oracle database 10g xe installation?

989

---

Why do we need integrity constraints in a database?

1023

---

How to use subqueries with the in operator using oracle?

1091

---

What is an oracle transaction?

1147

---

How to invoke the original export import utilities?

1065

---

types of indexes and the rationale behind choosing a particular index for a situation.

2510

---

What is dynamic proxy?

1011

---

Is postgres faster than oracle?

1046

---

What is the use of aggregate functions in oracle?

1026

---

What is a user account in oracle?

1121

---