Upper to Lower Case in Vi

posted Apr 12, 2013, 2:20 PM by Sachchida Ojha   [ updated Apr 12, 2013, 2:34 PM ]
Oracle database all table names and schema name are in upper case but when you run the same file in Greenplum , all table names and schema names are in lower case.  For example I have a parameter files that contains schema in and table name for HR schema from oracle

oraclehr.txt

HR EMPLOYEES
HR DEPARTMENTS
HR LOCATIONS

In Greenplum we want it to be

hr employees
hr departments
hr locations.

to do this, you need to open the oraclehr.txt in vi and run

:%s/.*/\L&/

Conversely, :%s/.*/\U&/ will change all the characters to uppercase.

also

Open the file in vi

press Esc then

for uppercase: gggUG
for lowercase: ggguG


Comments