DROP AND TRUNCATE TABLE
DROP TABLE Command DROP TABLE command is used to delete entire table from the database Once a table is dropped it can’t be recovered. Syntax: DROP TABLE <table name>; Example: DROP TABLERead More…
DROP TABLE Command DROP TABLE command is used to delete entire table from the database Once a table is dropped it can’t be recovered. Syntax: DROP TABLE <table name>; Example: DROP TABLERead More…
A group by clause is used to create groups based on the similar records. It first sort records on the group by column and then creates different groups. It creates a separateRead More…
UPDATE Command: This command is used to update or modify record of the database table. To update any specific record we must use WHERE clause. Using update command without WHERE clause willRead More…
Delete command is used to delete records from the database table. We must have to use WHERE clause with the DELETE command. If DELETE command is given without WHERE clause, it willRead More…
SELECT Select command is used to fetch records from the database table and display on the screen. Syntax: SELECT*FROM <table_name>; Example: SELECT * FROM student; It will display all the records fromRead More…
Insert command is used to insert records into the database table. Syntax: INSERT INTO <table_name> VALUES(val1,val2, val3,…,valN); Example: INSERT INTO student VALUES(1,’ABC’,’Ahmedabad’); It can be helpful for inserting record for all theRead More…
CREATE TABLE command is used to create a database table. Syntax: CREATE TABLE <table_name>( <column1><datatype> (size), <column2><datatype> (size),… <column N><datatype> (size)); Example: CREATE TABLE student( std_no number(3), std_namevarchar2(10), Cityvarchar2(10)); Where, table_name isRead More…
A client server architecture is an arrangement of computer in which different computer are connected with a single pc. It is a one type of network. A central PC to whom otherRead More…
Char: It is used to store string data of fix length. It can store up to maximum 255 characters. It stores character with right padding if data is less than its size.Read More…
In 1979, a software company “Relational Software Inco.” introduced first commercially database application that implemented SQL. This application is known as Oracle. After the release of the oracle application the company renamedRead More…