logging in or signing up SQL FUNCTIONS manjuhasini Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 32 Category: Entertainment License: All Rights Reserved Like it (0) Dislike it (0) Added: February 06, 2012 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... Premium member Presentation Transcript SQL FUNCTIONS : SQL FUNCTIONS TYPES OF FUNCTIONS : TYPES OF FUNCTIONS Single-Row Functions : Single-Row Functions Character Functions : Character Functions Case-manipulationfunctions : LOWER UPPER INITCAP Case-manipulationfunctions Character-manipulationfunctions : CONCAT SUBSTR LENGTH INSTR LPAD | RPAD TRIM REPLACE Character-manipulationfunctions Number Functions : ROUND: Rounds value to specified decimal TRUNC: Truncates value to specified decimal MOD: Returns remainder of division Number Functions Date Functions : MONTHS_BETWEEN ADD_MONTHS NEXT_DAY LAST_DAY ROUND TRUNC Date Functions Conversion Functions : Conversion Functions Implicit Data Type Conversion : Implicit Data Type Conversion Explicit Data Type Conversion : Explicit Data Type Conversion TO_NUMBER TO_DATE NUMBER CHARACTER DATE TO_CHAR TO_CHAR General Functions : NVL (expr1, expr2) NVL2 (expr1, expr2, expr3) NULLIF (expr1, expr2) COALESCE (expr1, expr2, ..., exprn) General Functions Conditional Expressions : CASE expression DECODE function Conditional Expressions MULTIPLE ROW FUNCTIONS : AVG COUNT MAX MIN STDDEV SUM VARIANCE MULTIPLE ROW FUNCTIONS THANK YOU : THANK YOU You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.
SQL FUNCTIONS manjuhasini Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 32 Category: Entertainment License: All Rights Reserved Like it (0) Dislike it (0) Added: February 06, 2012 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... Premium member Presentation Transcript SQL FUNCTIONS : SQL FUNCTIONS TYPES OF FUNCTIONS : TYPES OF FUNCTIONS Single-Row Functions : Single-Row Functions Character Functions : Character Functions Case-manipulationfunctions : LOWER UPPER INITCAP Case-manipulationfunctions Character-manipulationfunctions : CONCAT SUBSTR LENGTH INSTR LPAD | RPAD TRIM REPLACE Character-manipulationfunctions Number Functions : ROUND: Rounds value to specified decimal TRUNC: Truncates value to specified decimal MOD: Returns remainder of division Number Functions Date Functions : MONTHS_BETWEEN ADD_MONTHS NEXT_DAY LAST_DAY ROUND TRUNC Date Functions Conversion Functions : Conversion Functions Implicit Data Type Conversion : Implicit Data Type Conversion Explicit Data Type Conversion : Explicit Data Type Conversion TO_NUMBER TO_DATE NUMBER CHARACTER DATE TO_CHAR TO_CHAR General Functions : NVL (expr1, expr2) NVL2 (expr1, expr2, expr3) NULLIF (expr1, expr2) COALESCE (expr1, expr2, ..., exprn) General Functions Conditional Expressions : CASE expression DECODE function Conditional Expressions MULTIPLE ROW FUNCTIONS : AVG COUNT MAX MIN STDDEV SUM VARIANCE MULTIPLE ROW FUNCTIONS THANK YOU : THANK YOU