Oracle PLSQL Conversion Functions 48 codes

1 Cast null as timestamp

2 Cast string to date type before comparison

3 CAST() convertS one built-in data type (cast) into another

4 Cast(12 98 as number(2))

5 Cast(null as date )

6 COALESCE() returns the first non-null expression in the expression list

7 CONVERSION functions

8 Convert a negative number into one with a trailing minus sign

9 CONVERT() converts between two different character sets The returned values data type is VARCHAR2

10 Converting a Character Formatted as Currency to an Integer Value

11 Converting a Character to an Integer Value

12 Converting VARCHAR2 Percentage Data to a Decimal Equivalent

13 Create a report that shows number of customers per state

14 Decode a column with substr and instr

15 DECODE and GROUPING

16 DECODE and substr function

17 Decode char value to number

18 Decode column data to output more meaningful information

19 Decode for more than one key value pair

20 DECODE in the GROUP BY clause

21 Decode statement could be easily rewritten using the CASE statement

22 Decode the result from row_number over, partition by, order by

23 Demo range comparison with DECODE

24 Errors with the Format Mask

25 Extract any procedure, function or package

26 Format nullable heading

27 NULLIF() compares two expressions If they are equal, it returns NULL Otherwise, it returns the first expression

28 Pass variable into to_char function

29 ROWIDTOCHAR(x)

30 ROWIDTONCHAR(x)

31 Select coalesce( null, , A )

32 Select coalesce( null, sysdate )

33 Select nullif( 1, 1 )

34 Select nullif( 1, null )

35 Syntax

36 The TO_CHAR() function converts the expression into character data

37 To_char(bdate,fmMonth ddth, yyyy)

38 To_char(round(sqrt(sal),2),9999 99)

39 To_char(sysdate, Day, nls_date_language=Dutch)

40 To_char(sysdate,DAY dy Dy) as day, to_char(sysdate,MONTH mon) as month

41 To_char(sysdate,hh24

42 To_number(123)

43 Use chartorowid

44 Use DECODE and SIGN functions on the ORD table

45 Use decode as if statement and output high or low

46 Use Decode as if statement to logic like if then else

47 Use decode create dynamic select statement

48 Use to_char function to init an text value