Tag: technology

A MERGE statement is used to merge the data of one table with data from another.

A MERGE statement replaces the data of one table with that of another.

A MERGE statement can be used to insert new rows into a table.

A MERGE statement can be used to update existing rows in a table.

String

Character

Integer

Date

Numeric

Conversion

word()

wordindex()

wordnumber

wordno()

Strip()

trun()

remove()

space()

uppercase()

upcase()

Translate()

tran()

mult('mindworks ',3)

repeat('mindworks ',3)

copy('mindworks ',3)

copies('mindworks ',3)

DATE('W')

DATE('E')

DATE('N')

DATE('D')

Wrapper Type Call

Primitive Type Call

Compiler Error

Compiles fine, throws runtime exception

An exception is thrown if you attempt to add an element with a duplicate value.

The add method returns false if you attempt to add an element with a duplicate value.

A set may contain elements that return duplicate values from a call to the equals method.

Duplicate values will cause an error at compile time.

-3

3

-4

4