- ABS(number)

Returns the absolute positive value of an expression.

Syntax:

ABS(expression)

Example:

SELECT ABS(-1.0), ABS(0.0), ABS(1.0)

Output:

1.0 .0 1.0

- CEIL(number)

Returns the smallest integer greater than, or equal to, the specified numeric expression.

Syntax:

CEILING(expression)

Example:

SELECT CEILING($223.45), CEILING($-223.45), CEILING($0.0)

Output:

224.00 -223.00 0.00

- FLOOR(number)

Returns the largest integer less than, or equal to, the specified numeric expression.

Syntax:

FLOOR(expression)

Example:

SELECT FLOOR($223.45), CEILING($-223.45), CEILING($0.0)

Output:

223.00 -224.00 0.00

- MOD(number, divisor)

Returns the remainder of the division from 2 integer values.

Syntax:

MOD(dividend, divisor)

Example:

SELECT MOD(20,3)

Output:

2

- POWER(number, power)

Returns the exponential value for the numeric expression.

Syntax:

POWER(number, power)

Example:

SELECT POWER(2.0, 3.0)

Output:

8.0

- SIGN(number)

Returns the sign i.e. positive or negative value for the numeric expression. It returns -1 for negative expressions, a value of 0 for zero

Syntax:

SIGN(number)

Example:

SELECT SIGN(4)

Output:

1

- ROUND(number, precision)

Returns the numeric value rounded off to the next value specified.

Syntax:

ROUND(number, number of places)

Example:

SELECT ROUND(1.3456, 2)

- SQRT(number)

Returns the square root value of the expression.

Syntax:

SQRT(number)

Example:

SELECT SQRT(4.0)

Output:

2.0

- TRUNC(number, precision)

Returns a numeric value that truncate to the specific places

Syntax:

TRUNCATE(number,places)

Example:

SELECT TRUNCATE(1.3456, 2)

Output:

1.34

A) 8 | B) 9 |

C) 12 | D) 14 |

LINQ stands for " Language Integrated Query " and it is pronounced as "LINK".

LINQ was introduced in with .NET framework 3.5 including VS2008. It enables you to query the data from various data source like SQL, XML document, ADO .NET data source, web services and any other objects such as Collection, Generics etc...

Insert image into a table

Create the following table:

create table pics_table (

bfile_id number,

bfile_desc varchar2(30),

bfile_loc bfile,

bfile_type varchar2(4))

TABLESPACE appl_data

storage (initial 1m next 1m pctincrease 0)

Insert Query:

INSERT INTO pics_table

VALUES(4,'test image',bfilename('GIF_FILES','Test.JPG'),'JPEG');

- Clustering means one than one database server configured for the same user connection. When users connect, one of the server’s responds and connects based on availability. The user is completely ignorant of the fact that there are more than one database servers. It demands high cost due to infrastructure needs. Clustering is hence done on server level.

- Mirroring means, one has many configured databases on the same server. Mirrors are basically copies of the original database. Mirroring is hence done on database level.

WATER MARK is a divided segment of used and free blocks. Blocks which are below high WATER MARK i.e. used blocks, have at least once contained some data. This data might have been deleted later. Oracle knows that blocks beyond high WATER MARK don’t have data; it only reads blocks up to the high WATER MARK during a full table scan.