Friday, 17 October 2014

CEIL and FLOOR Function in Sql

 CEIL and FLOOR:-


SELECT
     CEIL(109.19)  ceil_val,
       FLOOR(109.99) floor_val from dual;
      
      
ROUND:-
      
       ROUND( number, decimal_places [, operation ] )
      
       SELECT ROUND(125.315, -2) from DUAL;
      
       SELECT ROUND(6.2,-2) from DUAL;
      
     
      SELECT INVOICE_AMOUNT FROM AP_INVOICES_ALL
     
        SELECT INVOICE_NUM,ROUND(INVOICE_AMOUNT) FROM AP_INVOICES_ALL WHERE INVOICE_AMOUNT = '15629.33'

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete