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
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
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
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
If you use the DTs data import and export tool provided by sqlserver, you should note that the table names in Oracle are in upper case, while SQL Server is in lower case by default, and should be changed to upper case during conversion, otherwise,
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
SQL optimization should be adjusted from five aspects:1. Remove unnecessary full table scans for large tables2. cache full table scan for small tables3. Verify the use of optimized Indexes4. Verify the optimized Connection Technology5. minimize the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.