Sql

Search

INITCAP in Oracle example

LOWER: It shows the entire word in lower case.
UPPER: The string is converted to all-caps.
INITCAP: The first letter of each word capitalised, and all other letters in lower case.


SELECT LOWER('ENGLAND') AS LOWER_VAL FROM dual; -- output: england
SELECT UPPER('England') AS upper_val FROM dual; -- output: ENGLAND
SELECT INITCAP('Once upon a time...') AS testvalue FROM dual; -- output: Once Upon A Time…

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql display max value
Sql :: sql datitime to date
Sql :: how to count the number of rows in sql
Sql :: expo sqlite
Sql :: oracle current session details
Sql :: mysql show create table
Sql :: postgresql default value
Sql :: sql update multiple rows
Sql :: truncate oracle
Sql :: postgresql if else endif
Sql :: sql select if not exists
Sql :: multiple replace value mssql
Sql :: sql find all different values in column
Sql :: add foreign key to existing table postgres
Sql :: ORA-01090: shutdown in progress - connection is not permitted
Sql :: mysql find duplicate rows multiple columns
Sql :: ignore case in string sql
Sql :: creating sqeuence in oracle database
Sql :: osm2pgsql mac
Sql :: mysql count unique in group statement
Sql :: generate random & unique mysql string
Sql :: POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
Sql :: import mysql database command line
Sql :: redo files log oracle
Sql :: connect to mysql c# connection string C#
Sql :: sql alter column
Sql :: mysql get only the field names in a table
Sql :: sql insert data
Sql :: cast in sql
Sql :: arithmetic operators in sql

Search

SQL

INITCAP in Oracle example

ADD CONTENT