| aliai |
Posted: May 02, 2008 03:55:53 AM |
Total Post: 11
Joined: Apr, 2008
|
Q1. which one is the system privilege?
a.select
b.delete
c.execute
d.alter table
e.create table
Q2.which two are character manipulation functions?
a.trim
b.replace
c.trunc
d.to_date
e.mod
f.case |
|
|
Murtuja |
| Posted: May 02, 2008 04:46:19 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
1 . create table
2.
CONCAT, SUBSTR, LENGTH, INSTR, LPAD, RPAD, and TRIM are the character manipulation functions
|
|
|
|
|
Murtuja |
| Posted: May 02, 2008 04:49:28 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
The character functions that return character values are:
CHR
CONCAT
INITCAP
LOWER
LPAD
LTRIM
NLS_INITCAP
NLS_LOWER
NLSSORT
NLS_UPPER
REGEXP_REPLACE
REGEXP_SUBSTR
REPLACE
RPAD
RTRIM
SOUNDEX
SUBSTR
TRANSLATE
TREAT
TRIM
UPPER
|
|
|
|
|
aliai |
| Posted: May 03, 2008 03:13:25 AM | |
|
Total Post: 11
Joined: Apr, 2008
|
thank you so much you solve my problem!
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |