FIT1004 Lecture 8: Oracle Functions

56 views2 pages

2 Jul 2018

School

Department

Course

Professor

For unlimited access to Class Notes, a Class+ subscription is required.

Lecture 8 : Oracle Functions

● Arithmetic

○ square root

○ round(n,[integer])

○ abs

○ power

● Text

○ Length

○ upper

○ lower

● Date

○ year

○ month

○ sysdate

● Convert

○ to_date

○ to_char

○ to_number

● Group

○ sum

○ avg

○ max

○ min

○ count

Date Functions

SYSDATE

● current date queried from dual

● Oracle uses one type : DATE

● dd-Mon-yyyy

● date data type is formated with TO_CHAR when selecting for display

Unlock document

This preview shows half of the first page of the document.
Unlock all 2 pages and 3 million more documents.

Already have an account? Log in

Get access