Results for INITCAP


1 to 14 of 14 results.


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

INITCAPLOWER LPAD

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 54 of 177

INITCAPSyntax initcap::= Text description of initcap Purpose INITCAP returns char, with the first letter … capitalizes each word in the string: SELECT INITCAP('the soap') \"Capitals\" FROM DUAL; Capitals --------- The Soap

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 80 of 177

NLS_INITCAPdifferent return value from the function: SELECT NLS_INITCAP ('ijsland') \"InitCap\" FROM DUAL … ; InitCap ------- Ijsland SELECT NLS_INITCAP ('ijsland', 'NLS_SORT = XDutch') \"InitCap\" FROM DUAL … ; InitCap ------- IJsland See Also: Oracle9i Database Globalization Support Guide for information on sort sequences

Heterogeneous Connectivity Administrator's Guide, 9i Release 2 (9.2.0.2)

Using Heterogeneous Services Agents

Oracle Database Server SQL Construct Processingdatabase: SELECT \"COL_A\" FROM \"test\"@SYBS WHERE \"COL_A\" = INITCAP('jones'); The non-Oracle database … system database does not recognize INITCAP, so the Oracle database server does a table scan of test … \" = INITCAP('jones'); In this case, the Oracle database server and the gateway cannot compensate for the

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

Modeling and Design

Non-Supported SQL Functionality for LOBsMiscellaneous SQL functions: INITCAP, NLS_INITCAP, DUMP, TRANSLATE, VSIZE, DECODE

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Linguistic Sorting

Special Uppercase Letters… The UPPER, LOWER, and INITCAP SQL functions cannot handle these special characters. The NLS_UPPER

SQL Reference, 9i Release 2 (9.2.0.2)

Expressions, 2 of 14

About SQL ExpressionsSET clause: SET last_name = 'Smith'; This SET clause has the expression INITCAP ( last_name … ) instead of the quoted string ' Smith ': SET last_name = INITCAP(last_name); Expressions have several forms

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

Objects, Collections, and OPAQUE Types

Selecting Data from a Nested Table Using a Nested Iteratormods = ; #sql projs = {SELECT a.id, a.name, initcap(a.owner.ename) as \"owner\", a.start_date … , CURSOR ( SELECT b.module_id AS \"moduleId\", b.module_name AS \"moduleName\", initcap

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

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle9i SQL Reference -- Contents

Oracle9i SQL Reference -- ContentsGROUP_ID GROUPING GROUPING_ID HEXTORAW INITCAP INSTR LAG LAST LAST_DAY LAST_VALUE LEAD LEAST LENGTH LN

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle9i SQL Reference -- Index

Itest, 5-4 INITCAP function, 6-77 INITIAL parameter INITIAL parameter of STORAGE clause, 7-59

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle9i SQL Reference -- Index

S-71 GREATEST, 6-72 GROUP_ID, 6-72 GROUPING, 6-74 GROUPING_ID, 6-75 HEXTORAW, 6-77 INITCAP, 6-77 INSTR

Generic Documentation Master Index, 9i Release 2 (9.2.0.2)

Oracle9i Database Master Index: I (Release 2 (9.2))

Oracle9 i Database Master Index: I (Release 2 (9.2))) INIT.ORA. (Concepts) INITCAP function (SQL Reference) initdb_name.ora file ACTIVE_INSTANCE_COUNT

Generic Documentation Master Index, 9i Release 2 (9.2.0.2)

Oracle9i Database Master Index: S (Release 2 (9.2))

Oracle9 i Database Master Index: S (Release 2 (9.2))) GROUPING_ID (SQL Reference) GROUP_ID (SQL Reference) HEXTORAW (SQL Reference) INITCAP (SQL





Was this page helpful?

Integrated Cloud Applications & Platform Services