how to convert lowercase to uppercase in oracle

You need to convert the lowercase amount to uppercase when you print the contract report for EBS Development.Here is the conversion function I wrote myself.The main idea: first get the decimal position, in the distinction between integer and decimal

Use Database functions to convert the lower case of RMB into the upper case of the invoice: Create or replace function l2u -- converts the lower-case amount to uppercase.(N_lowermoney in number)Return varchar2AsV_lowerstr varchar2 (200); -- lower

Created: Article attributes: original Article submission: T_Torchidy (jnchaha_at_163.com) Oracle web Environment Injection Technology## BY Jianxin# Http://www.loveshell.net/# Preface I am not a professional database administrator, nor a researcher

V. Index Optimization Design 1. Manage organization Indexes The index can greatly accelerate the database query speed. The index maps the logical value in the table to a safe RowID, so the index can quickly locate the physical address of the data.

After the project was ported from Oracle to PostgreSQL (version 9.4), the days went down again, tracked and positioned to determine that the call to the Pgdatabasemetadata.getprimarykeys () interface returned an empty set.It is well known that in

Considerations for migrating data from MySQL to Oracle1. Automatic growth of data type processingMySQL has an auto-growing data type that does not manipulate this field when inserting records and automatically obtains data values. Oracle does not

Oracle String FunctionsRecently changed the new company, and back to the Oracle database, a lot of things have forgotten, just have an impression, these two nights smoked a bit of time, the oracle of the string of some processing functions to do a

How to use Oracle to_char function, oracleto_char The function of the Oracle to_char function is to convert the numeric or date type to the numeric type. The following describes the use of the Oracle to_char function in detail, hoping to help

Functions in oracle are divided into character functions, number functions, date functions, empty processing functions, conversion functions, and other common functions. The following are some SQL functions commonly used in ORACLE: lower () function

Considerations for migrating data from MySQL to Oracle1. Automatic growth of data type processingMySQL has an auto-growing data type that does not manipulate this field when inserting records and automatically obtains data values. Oracle does not