Blog

Alter Table Statement  Definition : Alter Table statement is used to change the structure of an existing table of a database i.e. this statement specifies how to add one or multiple new columns/fields/attributes, modify one or more existing columns/fields/attributes , …

Definition : This statement is used to modify/change/update the existing record/s or data in the database. Syntax : UPDATE table–name SET(column–name1=value1, column–name2 =value2, column–name3=value3, column–name4=value4, column–name5=value5 ) ; Example : UPDATE employee SET(emp_id=”125M”, emp_name=”Rahman”, emp_addr =”Kolkata”, emp_dept=”Manager”, emp_dob=”05/22/2020″, emp_sal=20500, emp_mob=9334582186); UPDATE employee SET(emp_name=”Rahman”, emp_addr …

Definition :  This statement is used to remove one or more records permanently from the database table. Syntax :  DELETE table-name; DELETE table-name where condition; Example :  Problem : How to remove all data/records from a table permanently. SQL> Delete …

SELECT STATEMENT Basic Select Syntax :  SELECT column_name1,column_name2… column_name_n FROM table-name[WHERE Clause][GROUP BY clause][HAVING clause][ORDER BY clause]; The SELECT query statement is used to retrieve stored data from a database in the form of table-like structure called result set. It is one of the …

Definition : Insert into statement is used to add new or fresh record/s into an existing database table. Syntax : INSERT INTO table-name (field or attribute or column-name1, column-name2, column-name3, column-name4, column-name5) VALUES (value1, value2, value3, value4, value5 );(Press Enter) Example …

Create Table Definition : This statement creates a new/fresh table with various column or field names and respective datatypes in a database. Syntax : CREATE TABLE schema_name.table_name (column_name1 data_type1 column_constraint1, column_name2 data_type2 column_constraint2,    . . . table_constraints ); CREATE …

Click this link to know How to Uninstall Oracle 10g from Window 7/8.1/10.        Example : How to start/open oracle 10g from C-Command prompt/in MS-DOS ? Example : How to back at C-Command prompt/in MS-DOS from Oracle 10g …

Example : How to Start/open Oracle 10g/11g first time. Example : How to create new user in Oracle 10g/11g. Example : How to change/modify the current logged in user password in Oracle 10g/11g. Example : How to give administrator power …

Introduction DCL stands for Data Control Language. DCL statements are crucial for managing database security by controlling who has access to what data and what operations they can perform. Definition DCL statements are a collection of those SQL statements that …