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 LTRIM


1 to 14 of 14 results.


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

LTRIMNLS_INITCAP

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 68 of 177

LTRIMSyntax ltrim::= Text description of ltrim Purpose LTRIM removes characters from the left of char … : SELECT LTRIM('xyxXxyLAST WORD','xy') "LTRIM example" FROM DUAL; LTRIM example ------------ XxyLAST WORD

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 109 of 177

RTRIM, then you must enclose it in single quotes. RTRIM works similarly to LTRIM. Both char and set can be any … DUAL; RTRIM examp ----------- BROWNINGyxX See Also: LTRIM

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

Modeling and Design

SQL and PL/SQL VARCHAR2 Functions/Operators Now Allowed for CLOBsand || LENGTH() and variants (See Table 7-7 ) SUBSTR() and variants (See Table 7-7 ) TRIM(), LTRIM

Utilities, 9i Release 2 (9.2.0.2)

Field List Reference

Combinations of SQL Operators(:field1),'N/A', '0')" field1 CHAR(10) "NVL( LTRIM(RTRIM(:field1)), 'unknown' )"

Utilities, 9i Release 2 (9.2.0.2)

External Tables Access Parameters

trim_specfrom the field. LRTRIM, LTRIM, and RTRIM are used to indicate that characters should be trimmed … from the field. LRTRIM means that both leading and trailing spaces are trimmed. LTRIM means that … LTRIM) LOCATION ('foo.dat')); Alvin, Tolliver,1976 Kenneth, Baer, 1963 Mary, Dube, 1973

Reference Guide, 9i Release 2 (9.2.0.2)

Data Types, Reserved Words, and Functions

Microsoft Access FunctionsCODE Len LENGTH REPLACE IN PLACE Like * Log LOG NO ACTION LTrim LTRIM NO ACTION LTrim$ LTRIM NO ACTION

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

Migrating From LONGs to LOBs

VARCHAR2 and CLOB in PL/SQL Built-In FunctionsCONCAT, || LPAD, RPAD LTRIM, RTRIM, TRIM LIKE REPLACE LOWER, UPPER NLS_LOWER, NLS_UPPER NVL Comparison

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

Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations, 9i Release 2 (9.2.0.2)

Microsoft SQL Server, Sybase Adaptive Server, and Oracle Compared

Built-In Functions) lower(char_exp) Converts uppercase characters to lowercase characters. ltrim(char_exp) ltrim

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

Selecting a Datatype

Migrating LONG Datatypes to LOB Datatypes, LENGTHB, LIKE, LOWER, LPAD, LTRIM, NLS_LOWER, NLS_UPPER, NVL, REPLACE, RPAD, RTRIM, SUBSTR, SUBSTRB

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle9i SQL Reference -- Contents

Oracle9i SQL Reference -- ContentsLOCALTIMESTAMP LOG LOWER LPAD LTRIM MAKE_REF MAX MIN MOD MONTHS_BETWEEN NCHR NEW_TIME NEXT_DAY

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

Tuning PL/SQL Applications

Reasons for PL/SQL Performance Problems, SUBSTR, INSTR, RPAD, and LTRIM. Do not hand code your own versions. Built-in functions are more

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Creating the Extensible Optimizer Methods; cval NUMBER; colname VARCHAR2(30):= rtrim(ltrim(col.colName, '"'), '"'); statsexists BOOLEAN:= FALSE … ; stmt VARCHAR2(1000); junk INTEGER; colname VARCHAR2(30):= rtrim(ltrim(col.colName … ; colname:= rtrim(ltrim(args(3).colName, '"'), '"'); The first (column) argument of the function in