Subscribe:
Subscribe To
Posts
All Comments
Popular Posts
-
LINKING COLUMNS AND LITTERAL STRINGS Through Linking Columns And Literal Strings With Concatenation Operator In A Select Clause, You Can P... -
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...
-
BETWEEN SQL RANGE used to display rows based on a rang of values,you use the between and keywords . You specify the between keyword...
-
IN IN Operator used to restrict rows retrieved to values in specified list The IN keyword is followed by values separated by commas. The ...
-
Before create a tables please follow the below rules not for table only but for all database objects. 1- All names begin with letters ...
-
Oracle uses constraints to prevent invalid data entry into a table. You can add and remove constraint after creating a table. Constraints en...
-
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, ...
-
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... -
SEQUENCES You create a sequence to generate a unique numbers. Create sequences You can create a sequence by using CREATE SEQUENCE statement...