|
|
-
|
|
Let Us Learn Oracle - Part 5 of N [ InStrb function in Oracle ]
Source table: tblPlayers
Syntax: InStrB(char1,char2 [,n[,m]])
Purpose: It searches the string argument char1, beginning with it's nth byte , for the mth occurance of string argument char2
Example 1:
SQL> select PlayerLastName,In......
|
|
-
|
|
Let Us Learn Oracle - Part 4 of N [ InStr function in Oracle ]
Source table: tblPlayers
Purpose:Finds the occurance of a character(s) in a string. It is case sensitive
Syntax: InStr(Column Name,Character(s) [,Start[Occurance]])
SQL> Select PlayerLastName, InStr(PlayerLastName,'R') From tblP......
|
|
-
|
|
Let Us Learn Oracle - Part 3 of N [ InitCap function in Oracle ]
Source table: tblPlayers
Purpose:Capitalizes the first letter of the string
Syntax : InitCap(Column Value)
SQL> Select Initcap(Upper(BelongsTo)) InitCapExample From tblPlayers;
INITCAPEXAMPLE
--------------
India
India......
|
|
-
|
|
Let Us Learn Oracle - Part 2 of N [ Length function in Oracle ]
Source table: tblPlayers
This function will return the length of the string
SQL> Select PlayerFirstName || ' ' || PlayerLastName FullName,Length(PlayerFirstName || ' ' || PlayerLastName) FullNameLength From tblPlayers;
FULLN......
|
|
-
|
|
The tables that will participate in the demonstration
tblPlayers
tblStudents
tblDept
tblEmployee
Script for tblPlayers
CREATE TABLE tblPlayers
(
PlayerID INT NOT NULL,
PlayerFirstName VARCHAR(10),
PlayerLastName VARCHAR(10),
BelongsTo VARCHAR(10),
DOB varchar(20),
Fee......
|
|
-
|
|
The tables that will participate in the demonstration
tblPlayers
tblStudents
tblDept
tblEmployee
tblCols
tblRows
tblUnPivotExample
tSqlChallenge8
MatchTable
Script for tblPlayers
CREATE TABLE tblPlayers
(
PlayerID INT NOT NULL,
PlayerFirstName VARCHAR2(10),
PlayerL......
|
|
-
|
|
Let Us Learn Oracle - Part 1 of N [ String Concatenation in Oracle ]
Source table: tblPlayers
In Oracle concatenation can be done in the following ways
Option 1: Using Concatenation Operator ( || )
SQL> Select PlayerFirstName || ' ' || PlayerLastName FullName From tblPlayers;
FULLN......
|
|
-
|
|
Let us Learn Oracle
Since sometime I was thinking to start a series of article on Oracle, but because of time constraint I was not able to do so. But atlast I have decided to take it up seriously and henceforth starting this new series of Oracle.
In this series(an N-Part series) we will learn the ......
|
|
-
|
|
In this article we will read a word document and in that we will search if any valid email address is there and if so we will pick up those
The content of the word file is as under
Hello
How r u
Email: mail3456@gg.com
Another email is aaa@zz.com
And not a valid email as invalid@.com
......
|
|
-
|
|
In this article, we will look into how we can perform CRUD operation through Javascript directly
N.B.~I won't recommend this approach as it is highly unsafe , but I will promote the way to do so
The database is Sql Server 2008 DB
In that DB, there is a table , PlayerTable
Let us create the table......
|
|