Important Code Samples
Tuesday, August 23, 2016
How to update first character upper case in Oracle
select upper(substr(CTY_CITY,1,1))|| substr(CTY_CITY,2,length(CTY_CITY)-1) as Ax from AGM_M_COUNTRY_CITY;
update AGM_M_COUNTRY_CITY
set CTY_CITY = upper(substr(CTY_CITY,1,1))|| substr(CTY_CITY,2,length(CTY_CITY)-1);
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)
Postgress - Read a XML file from a postgress table XML column
SELECT xmltable.* FROM xmldata, XMLTABLE('//ROWS/ROW' PASSING data COLUMNS id int PATH ...
System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
if more than 65535 files in your temp folder, this error can occurs, To resolve this, remove all temporary files in C:/Windows/Temp ....
How to update first character upper case in Oracle
select upper(substr(CTY_CITY,1,1))|| substr(CTY_CITY,2,length(CTY_CITY)-1) as Ax from AGM_M_COUNTRY_CITY; update AGM_M_COUNTRY_CITY set ...
Sender Parameter/ Common functions (C#)
Common text box validation function for all the text boxes within the same form. Using Sender parameter to handle. private void tex...
