skip to main
|
skip to sidebar
Subscribe:
Oracle SQL tutorial
Pages
Home
Contact Me
Monday, September 26, 2011
LINKING COLUMNS AND LITTERAL STRINGS
LINKING COLUMNS AND LITTERAL STRINGS
Through Linking Columns And Literal Strings With Concatenation Operator In A Select Clause, You Can Produce Customized Results That Are Easy To Read And Understand.
PLEASE CHECK THE BELOW EXAMPLE.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
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
Subscribe To
Posts
Atom
Posts
Comments
Atom
Comments
Popular Posts
Case conversion functions
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...
Literal character strings
Literal character strings A literal is character, expression, or number placed in the select list between column names. You enclose charact...
Common Date Functions
DATE FUNCTION IN SQL 1- MONTHS_BETWEEN Function : finds the number of months between two dates For example assume that you want find numb...
Order by
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.
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 ...
Comparing Expression
Comparing in sql = Equal < Less than > Greater than <= Less than or equal >= ...
LIKE
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...
IN
IN IN Operator used to restrict rows retrieved to values in specified list The IN keyword is followed by values separated by commas. The ...
Data type
Data type SQL DATATYPES NUMBER : INDICATE THE COLUMN CONTAINS NUMBER. EXAMPLE: NUMBER (6, 2) 32155.01 The number in parentheses follo...
Column Aliases
Column Aliases, SQL ALIAS Here you will know how to use column aliases as one way to customize SELECT statements. - USING A COLUMN ALIASES ...
Powered by
Blogger
.
No comments:
Post a Comment