Tag: databases

concat

initcap

round

length

selects all the rows from the table having the column_xyz value starting with the word oracle

selects all the rows from the table having the column_xyz value ending with the word oracle

selects all the rows from the table having the column_xyz value containing the word oracle

selects all the rows from the table having the column_xyz value not containing the word oracle

abs(-123.456)

trunc(123.456,2)

round(123.456,2)

avg(1,2,3,4,5)

O

oracle

Oracle

ORACLE

8

30

1.03225806

.998989989

'14-mar-2002'

'13-mar-2001'

'20-mar-2001'

'14-apr-2001'

removes the time component from a date_time value

removes the date component from a date_time value

removes the day component from a date_time value

removes the year component from a date_time value

to_date(string,format)

to_char(date,format)

to_date(date,format)

to_number(string,format)

% processor time >80

% processor time <80

Processor queue length>2

Batch request/sec

sql compilation./sec

sql recompilation/sec

network

relational

hierarchical

object-oriented