Search
 
SCRIPT & CODE EXAMPLE
 

SQL

upper and lower in oracle sql

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 :: oracle create as select 
Sql :: oracle add datafile to tablespace 
Sql :: is there any command to change postgres password 
Sql :: how to find column in all the tables sql 
Sql :: sql server cannot create database diagram 
Sql :: sql current year 
Sql :: cmd to rename a collumn name in sql 
Sql :: oracle add proxy 
Sql :: get all db sizes in mysql server 
Sql :: An error occurred while installing mysql2 (0.5.3) 
Sql :: like sql 
Sql :: oracle index partition 
Sql :: how to export table data from mysql table in sql format 
Sql :: update with join sql server 
Sql :: node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz 
Sql :: show column from sql server 
Sql :: sql add column int nullable 
Sql :: select from describe sql 
Sql :: sql limit decimal places 
Sql :: sql select max value from multiple rows 
Sql :: pandas to sql index 
Sql :: sql create table statement 
Sql :: how to get id of last inserted row in mysql 
Sql :: sql server sleep 
Sql :: oracle trigger 
Sql :: postgres foreign key multiple columns 
Sql :: sql server concat string and int 
Sql :: psql get table data types 
Sql :: sql date diff 
Sql :: define a variable in mysql from select 
ADD CONTENT
Topic
Content
Source link
Name
5+3 =