skip to main |
skip to sidebar
Subscribe:
Pages
Labels
- Concatenation (2)
- (ADD (1)
- BETWEEN Operator (1)
- Case conversion functions (1)
- Column Aliases (1)
- Common Database structure (1)
- Common Date Functions (1)
- Comparing in sql (1)
- Constraints (1)
- Create and Alter Tables (1)
- DATE Arithmetic (1)
- DB Terms (1)
- DECODE (1)
- DESC (1)
- Data type (1)
- Duplict rows (1)
- ELIMINATE DUPLICATE ROWS (1)
- Entity Relationship model Components (1)
- How to select columns and row (1)
- In operator (1)
- Is null operator (1)
- LPAD (1)
- Length (1)
- Life Cycle (1)
- Like (1)
- Literal character (1)
- Logical operators (1)
- MODIFY (1)
- NESTING (1)
- NVL (1)
- Order by (1)
- REMOVE) (1)
- ROUND (1)
- RPAD (1)
- RULES OF PRIORITY (1)
- Relatuion Concept (1)
- SEQUENCES (1)
- SORTING BY MULTIPLE COLUMNS (1)
- SQL Functions (1)
- SUBSTR and INSTR (1)
- SYSDATE Function (1)
- Single row functions (1)
- Sorting by column alias (1)
- TABLE STRUCTURE (1)
- TO_CHAR (1)
- TO_DATE (1)
- TO_NUMBER (1)
- Transaction control (1)
- Type Of SQL Statement (1)
- What is Arithmetic in SQL (1)
- Where (1)
- letiral as a separte column (1)
Followers
Posts
Popular Posts
-
Case conversion function used to display character values in a different case,without changing the case of the data in the table Types of c...
-
We used order by clause to sort rows in an order that you specify. Sorting data is ascending order by . 1- Numeric data is sorted from...
-
How to display the letiral as a separte column For example suppose that you want to create a result that detailes employee names and thire ...
-
Oracle uses constraints to prevent invalid data entry into a table. You can add and remove constraint after creating a table. Constraints en...
-
Manipulating Data Language (DML) Before execute DML statements, you must have INSERT,UPDATE, and DELETE privilege. INSERT EXAMPLES 1- ...
-
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...
-
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, ...
-
By using arithmetic operators you can perform calculations on dates. For example SELECT EMPNO,ENAME,SAL,HIREDATE,HIREDATE+100 “NEW DATE” FR...
-
Is a date function returns the current date The default format is DD-MON-YY If you want to select current date Type Select sysdate From dua...
-
Common Database structure 1- Table: Common structure in database is a table .table consist of columns and rows in which data is stored .t...
Powered by Blogger.
Copyright (c) 2011 Oracle SQL tutorial.
Designed for Fruit Machine Jackpots
Manchester United Retro Shirts, Scratch Card Games, Xmas Hampers
Manchester United Retro Shirts, Scratch Card Games, Xmas Hampers