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
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 ...
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...
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 Database structure
Common Database structure 1- Table: Common structure in database is a table .table consist of columns and rows in which data is stored .t...
Create and Alter Tables
Before create a tables please follow the below rules not for table only but for all database objects. 1- All names begin with letters ...
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 P...
Arithmetic Expressions
- What is Arithmetic in SQL Arithmetic in SQL + Addition - Subtraction * Multiplication / Division You can use ari...
How to select columns and row
To select all data from table you use this cod SELECT * FROM EMP; ...
Constraints
Oracle uses constraints to prevent invalid data entry into a table. You can add and remove constraint after creating a table. Constraints en...
Powered by
Blogger
.
No comments:
Post a Comment