Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 15, 2002

Listen Software's How To: Oracle Functions

By David Nishimoto

Oracle String Functions

  • initcap(char)--Returns a char with the first letter of each word in uppercase
  • instr(char1, char2,n,m)--n=position m=occurance returns the numeric position of char2 in char1
  • length(char)--Length of char
  • lower(char)--Returns char with all lower case
  • lpad(char1,n,char2)--Return a char with char1 left pad with char2
  • ltrim(char)--Remove all leading spaces
  • rpad(char1,n,char2)--Returns char with char1 right pad with char2
  • rtrim(char)--Remove all trailing spaces
  • substr(char,m,n)--Returns substring start at m for n characters
  • upper(char)--Converts all characters to uppercase
  • chr(n)--Returns the ascii code equivalent
  • concat(char1, char2)--Return a char which is the result of char1 and char2

Oracle Time Functions

  • ADD_MONTHS(d,n)--Add n months to d date
  • LAST_DAY(d)--Returns last day of the month
  • MONTHS_BETWEEN(d1,d2)--Difference between d1 and d2
  • ROUND(d,fmt)--Round to format
  • TO_CHAR(string,format)
  • TO_DATE(string,format)

Oracle Number Functions

  • ABS(value)--Absolute value
  • CEIL(value)--Smallest integer larger than equal to value
  • COS(value)--Cosine value
  • EXP(value)--e raise to value
  • FLOOR(value)--Largest value smaller than equal to value
  • ROUND(value)--Rounding of value to precision
  • SIGN(value)--1 if positive -1 if negative
  • SQRT(value)--Square root of value
  • TAN(value)--Tangent of value
  • TRUNC(value)--Value truncated to precision

Oracle Group Functions

  • Avg(value)--Average of value for a group of rows
  • Count(value)--Count rows of columns
  • Max(value)--Maximum of all value for groups of rows
  • Min(value)--Minimum of all values for groups of rows
  • Sum(value)--Sum of all values for groups of rows

Oracle Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.