Subscribe:
Subscribe To
Posts
All Comments
Popular Posts
-
When you don’t know what value you need to search then you can use the like operator in where cluse. Symbols with like. (%) represents any...
-
Types Sql SQL statement are five types - Data retrieval. Data . data retrieval statement retrieve data from database. SQL SELECT stateme...
-
Before create a tables please follow the below rules not for table only but for all database objects. 1- All names begin with letters ...
-
BETWEEN SQL RANGE used to display rows based on a rang of values,you use the between and keywords . You specify the between keyword...
-
Manipulating Data Language (DML) Before execute DML statements, you must have INSERT,UPDATE, and DELETE privilege. INSERT EXAMPLES 1- ...
-
Oracle uses constraints to prevent invalid data entry into a table. You can add and remove constraint after creating a table. Constraints en...
-
IN IN Operator used to restrict rows retrieved to values in specified list The IN keyword is followed by values separated by commas. The ...
-
HOW YOU CAN ELIMINATE DUPLICATE ROWS. sql duplicate records, query to find duplicate records You can eliminate duplicate rows by using th... -
DISPLAYING TABLE STRUCTURE. Structure of sql. You can use the DESCRIBE command to see the column names, the data types ,And whether a... -
Single row function accepts one or more arguments and returns one value for each row. A single row functions can be used in SELECT, WHERE, ...