Results for TRIM


1 to 20 of 127 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Reference, 10g Release 1 (10.1)

TRIM

TRIMSyntax trim::= Description of the illustration trim.gif Purpose TRIM enables you to trim leading or … , then the TRIM function returns . Both trim_character and trim_source can be any of the … hire date of the employees in the hr schema: SELECT employee_id, TO_CHAR(TRIM(LEADING 0 FROM hire_date

DML Reference, 10g Release 1 (10.1)

TRIM

TRIMThe TRIM function enables you to trim leading or trailing characters (or both) from a character … string. You can also trim leading characters using LTRIM and trailing characters using RTRIM. Return … Value The data type of the string you are trimming (that is, trim-source ). Syntax TRIM ([{{LEADING

Reference, 10g Release 1 (10.1)

ORDSource Methods

trim( )Format trim(ctx IN OUT RAW, newlen IN INTEGER) RETURN INTEGER; Description Trims a data source. Parameters

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Blob Cl a ss

trim()Truncates the BLOB to the new length specified. Syntax void trim( unsigned int newlen); Parameter

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Clob Class

trim()Truncates the CLOB to the new length specified. Syntax void trim( unsigned int newlen); Parameter

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

16 Large Objects (LOBs)

16.4.16 TRIMPurpose Truncates the LOB value. Syntax EXEC SQL [AT [:]database] LOB TRIM:src TO:newlen. Host

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

TRIM ProcedureTRIM procedure decreases the length of the LOB to the value specified in the newlen parameter. If … you attempt to TRIM an empty LOB, then nothing occurs, and TRIM returns no error. If the new length

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

13 Large Objects (LOBs)

13.4.16 TRIMPurpose Truncates the LOB value. Syntax EXEC SQL [AT [:]database] LOB TRIM:src TO:newlen END-EXEC

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

18 Collections

18.4.5 COLLECTION TRIM[:]database] COLLECTION TRIM:num FROM:collect [[INDICATOR]:collect_ind]. Variables num (IN) A host scalar … returned. A warning is returned if a TRIM removes any elements from the current slice.

SQL*Plus® User's Guide and Reference, 10g Release 1 (10.1)

13 SQL*Plus Command Reference

SET TRIM[OUT] { ON | OFF}SET TRIMOUT is not supported in i SQL*Plus Determines whether SQL*Plus puts trailing blanks at the end of each displayed line. ON removes blanks at the end of each line, improving performance especially when you access SQL*Plus from a slow communications device. OFF enables SQL*Plus to display trailing blanks. TRIMOUT ON does not affect spooled output.

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

F Embedded SQL Statements and Precompiler Directives

F.47 LOB TRIM (Executable Embedded SQL Extension)usage notes as well as keywords, parameters, and examples, see "TRIM". Related Topics See the other LOB statements.

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

F E mbedded SQL Statements and Directives

F.14 COLLECTION TRIM (Executable Embedded SQL Extension)TRIM". Related Topics See the other COLLECTION statements.

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

F E mbedded SQL Statements and Directives

F.57 LOB TRIM (Executable Embedded SQL Extension)usage notes as well as keywords, parameters, and examples, see "TRIM". Related Topics See the other LOB statements.

User's Guide and Reference, 10g Release 1 (10.1)

5 Using PL/SQL Collections and Records

Decreasing the Size of a Collection (TRIM Method)This procedure has two forms: TRIM removes one element from the end of a collection. TRIM(n … . print_numlist(n); -- If too many elements are specified, TRIM raises the exception … removed by DELETE, placeholders are left behind. TRIM counts these -- placeholders as it removes … . n.TRIM(2); print_numlist(n);

Programmer's Guide, 10g Release 1 (10.1)

OCI Collection and Iterator Functions

trim_num (IN)Number of elements to trim.

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-30000: missing either trim specification or char expression in TRIM… This binding cannot be re-validated. ORA-30000: missing either trim specification or char expression in TRIM

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-30001: trim set should have only one characterCause: Since FROM is specified in TRIM function, either trim specification (TRAILING, HEADING, BOTH … ) or trim character or both must be specified. Action: Add either trim specification (TRAILING … , HEADING, BOTH) or trim character or both. ORA-30001: trim set should have only one

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

ExceptionsTable 45-56 TRIM Procedure Exceptions Exception Description VALUE_ERROR lob_loc is NULL. INVALID_ARGVAL Either: - new_len LOBMAXSIZE

Error Messages, 10g Release 1 (10.1)

14 ORA-19400 to ORA-24276

ORA-22167: given trim size [ string ] must be less than or equal to [ string ]function. ORA-22167: given trim size [ string ] must be less than or equal to [ string ]

Error Messages, 10g Release 1 (10.1)

32 OCI-00601 to OCI-31154

OCI-22167: given trim size [ string ] must be less than or equal to [ string ]function. OCI-22167: given trim size [ string ] must be less than or equal to [ string ]


Was this page helpful?