Monday, June 13, 2011
2009-2010 database programming with SQL-introduction to computer
This section continues the discussion of features and focus on those which are most often. The functions are very powerful feature of SQL and can be used to do the following: perform calculations on data, modifying the individual elements of data handled, manufactured for groups of rows, the format of dates and numbers for display and conversion of data types for columns. This section also introduces a replacement of the variables and how they are used in Oracle Application Express. And finally the section offers students the opportunity to examine the market of it work and careers that they may be interested in prosecution. Lesson 1: the event and the manipulation of characters • select and apply functions on a single line, which perform case conversion and/or signs of manipulation. • Select and apply functions for the handling of the case of character INITCAP, upper and lower in the SQL query. • Select and apply character manipulation functions CONCAT, SUBSTR, length, INSTR, LPAD, RPAD, UPHOLSTERY and replace in SQL query. • Write flexible applications use substitution variables. Lesson 2: number of functions • select and apply the number one line function ROUND, TRUNC and MOD in the SQL query. • Distinguish between the results obtained when TRUNC has various ...
Website: academy.oracle.com | File size: 92 kb
Number of pages: 10
Download 2009-2010 database programming with SQL-introduction to Computer .PDF
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.