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
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...
SQL STATEMENT TYPES
Types Sql SQL statement are five types - Data retrieval. Data . data retrieval statement retrieve data from database. SQL SELECT stateme...
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 ...
BETWEEN
BETWEEN SQL RANGE used to display rows based on a rang of values,you use the between and keywords . You specify the between keyword...
DML
Manipulating Data Language (DML) Before execute DML statements, you must have INSERT,UPDATE, and DELETE privilege. INSERT EXAMPLES 1- ...
Constraints
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 IN Operator used to restrict rows retrieved to values in specified list The IN keyword is followed by values separated by commas. The ...
DISPLAYING TABLE STRUCTURE
DISPLAYING TABLE STRUCTURE. Structure of sql. You can use the DESCRIBE command to see the column names, the data types ,And whether a...
HOW YOU CAN ELIMINATE DUPLICATE ROWS
HOW YOU CAN ELIMINATE DUPLICATE ROWS. sql duplicate records, query to find duplicate records You can eliminate duplicate rows by using th...
SQL Functions
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, ...
Powered by
Blogger
.
No comments:
Post a Comment