You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for TRUNC


1 to 20 of 44 results. Previous page Prev  Next next page
Results per page:   20  | 40


Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

OCCI Classes and Methods, 14 of 22

trunc()parameter specified. Syntax const Number trunc(int decplace) const; Parameters decplace The number of

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 155 of 177

TRUNC (date)Syntax trunc_date::= Text description of trunc_date Purpose The TRUNC (date) function returns date … omit fmt, then date is truncated to the nearest day. See Also: "ROUND and TRUNC Date Functions" for the … permitted format models to use in fmt Examples The following example truncates a date: SELECT TRUNC

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 154 of 177

TRUNC (number)Syntax trunc_number::= Text description of trunc_number Purpose The TRUNC (number) function returns … truncate numbers: SELECT TRUNC(15.79,1) "Truncate" FROM DUAL; Truncate ---------- 15.7 SELECT TRUNC(15.79,-1) "Truncate" FROM DUAL; Truncate ---------- 10

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

TRUNC (number)WIDTH_BUCKET Character Functions Returning Character Values Character functions that return character values return values of the same datatype as the input argument. Functions that return CHAR values are limited in length to 2000 bytes. Functions that return VARCHAR2 values are limited in length to 4000 bytes. For both of these types of functions, if the length of the return value exceeds the limit,

Objects for OLE, 9i Release 2 (9.2.0.2)

Trunc (OraNumber) Method

Trunc (OraNumber) MethodFeedback Trunc (OraNumber) Method Applies To OraNumber Description Truncates an Oracle number at a … the decimal point. Usage OraNumber. Trunc decplaces Remarks The result of the operation is stored in

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 176 of 177

ROUND and TRUNC Date FunctionsTable 6-4 lists the format models you can use with the ROUND and TRUNC date functions and the units … truncated to the day with a time of midnight. Table 6-4   Date Format Models for the ROUND and TRUNC Date

Enterprise Manager Database Tuning with the Oracle Tuning Pack, 9i Release 2 (9.2.0.2)

Tuning SQL Statements

Use TRUNC differently to enable indexesUsing the truncate command (TRUNC) on an indexed column disables the index. Rewriting your query so … the following example, trans_date is an indexed column, but the index is disabled by the TRUNC … command. SELECT account_name, trans_date FROM transaction WHERE TRUNC(trans_date) = TRUNC(sysdate) The … account_name,

Utilities, 9i Release 2 (9.2.0.2)

Field List Reference

Combinations of SQL OperatorsEXTERNAL "TRUNC(RPAD(:field1,6,'0'), -2)" field1 POSITION(1:8) INTEGER EXTERNAL "TRANSLATE(RTRIM

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

TO_YMINTERVALTRUNC (date) TZ_OFFSET Conversion Functions Conversion functions convert a value from one datatype

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 104 of 177

ROUND (date)Also: "ROUND and TRUNC Date Functions" for the permitted format models to use in fmt Examples The

Objects for OLE, 9i Release 2 (9.2.0.2)

Methods

Methods(OraNumber) Sub (OraNumber) Tan (OraNumber) Trunc (OraNumber)   Copyright © 1994, 2002 Oracle Corporation

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

ROW_NUMBER, TO_CHAR(TRUNC(SUM(amount_sold), -6), '9,999,999,999') SALES$, ROW_NUMBER() OVER (ORDER BY TRUNC(SUM

XML Developer's Kits Guide - XDK, 9i Release 2 (9.2.0.2)

XSQL Pages Publishing Framework

Producing XML Datagrams from SQL QueriesFlightSchedule WHERE TRUNC(ExpectedTime) = TRUNC(SYSDATE) AND Arrived = 'N' AND Destination = ? /* The … Due FROM FlightSchedule WHERE TRUNC(ExpectedTime) = TRUNC(SYSDATE) AND Arrived = 'N' AND Destination

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Fundamentals of PL/SQL

Built-In FunctionsSINH SQRT TAN TANH TRUNC ASCII CHR CONCAT INITCAP INSTR INSTRB LENGTH LENGTHB LOWER LPAD LTRIM … TZ_OFFSET TRUNC DEREF REF VALUE TREAT BFILENAME DECODE DUMP EMPTY_BLOB EMPTY_CLOB GREATEST LEAST

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Loading and Transformation

Transformation Using SQL, customer_id, TRUNC(sales_date), 'S', promotion_id, quantity, amount FROM sales_activity_direct … (product_id, today, product_cost, product_price) SELECT TRUNC(s.sales_date) AS today, s.product_id … s.product_id = p.product_id AND trunc(sales_date)=trunc(sysdate) GROUP BY trunc(sales_date), s.product_id

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Selecting a Datatype

Time Format: ADD_MONTHS SYSDATE SYSTIMESTAMP TRUNC. When applied to a DATE value, it trims off the time portion so … values and comparing them, you can check whether they refer to the same day. You can also use TRUNC

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

RANK and DENSE_RANKthe unit sales. (Note that the TRUNC function is used here only to create tie values for this query … (TRUNC(SUM(amount_sold),-6), '9,999,999,999') SALES$, TO_CHAR(SUM(quantity_sold), '9,999,999,999 … ') SALES_Count, RANK() OVER (ORDER BY trunc(SUM(amount_sold), -6) DESC, SUM(quantity_sold) DESC) AS … , calendar_month_desc, TO_CHAR(TRUNC(SUM(amount_sold),-6),

XML Developer's Kits Guide - XDK, 9i Release 2 (9.2.0.2)

XSQL Pages Publishing Framework

Transforming XML Datagrams into an Alternative XML Format, TO_CHAR(ExpectedTime,'HH24:MI') AS Due FROM FlightSchedule WHERE TRUNC(ExpectedTime) = TRUNC(SYSDATE

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Selecting a Datatype

Date Formatfunction TRUNC to ignore the time component. Displaying the Current Date and Time Use the SQL function

SQL Reference, 9i Release 2 (9.2.0.2)

Expressions, 2 of 14

About SQL Expressionsresult to CHAR datatype: TO_CHAR(TRUNC(SYSDATE+7)) You can use expressions in: The select list of the