BusinessObjects, Oracle & Sql Tips
Saturday, January 2, 2010
ORACLE-Find Number of Character in a String
For example, find how many "|" is in "abc|123|wer|123|bnm".
select length('
abc|123|wer|123|bnm
')-length(replace('
abc|123|wer|123|bnm
','|','')) from dual
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
Search This Blog
Labels
businessobjects
BI4
oracle
web intelligence
webi
universe
2008
XI 3.1
backup
internet explorer 9
merge
olap
password
prompt
query
sql
xcelsius
1930605
2010
ADAPT01590478
BI41
CLSID
IDT
Information design tool
SQL Server
SQL Server 2005
SQL Server 2008
SQL Server Database Engine
Troubleshooting SQL Server
adapt01710199
administrator
architecture mismatch
biar
calendar
column
connecting
connecting to SQL Server
connection
current
date
decrease
diagnostic
difference
dimension
freeze
hint
ie9
incompatible
inconsistency
increase
infoview
insert
keycode
lag
lead
long
modify mode
no data
non-numeric
numeric
odbc
office
order
report
repository
reset
row
sum
time
timestamp
timezone
transpose
troubleshooting
update
username
view mode
workspace
Blog Archive
►
2016
(1)
►
February
(1)
►
2014
(1)
►
March
(1)
►
2013
(8)
►
November
(2)
►
August
(1)
►
May
(1)
►
March
(1)
►
February
(3)
►
2012
(9)
►
November
(2)
►
June
(1)
►
May
(3)
►
April
(3)
►
2011
(2)
►
August
(1)
►
May
(1)
▼
2010
(13)
►
December
(2)
►
March
(1)
►
February
(1)
▼
January
(9)
ORACLE-Find the Time Difference Between Two Steps
ORACLE-Cumulative Sum at the Same Line
BusinessObjects-Dont' Ask for Username and Passwor...
ORACLE-Merge Command
ORACLE-Delete Same Multiple Rows Except One
ORACLE-Get the Values from a Long Data Type Column
ORACLE-Find Non-Numeric Rows in a Table
ORACLE-Create a Calendar Table
ORACLE-Find Number of Character in a String
Links
Dave’s Adventures in Business Intelligence
BOB: Business Objects Board
Ask Tom Home
Ek$i
No comments:
Post a Comment