Reference documentsDocument 1:HTTP://BLOG.ITPUB.NET/24104518/VIEWSPACE-730682, character format, need to clean up a bitLiterature 2:http://www.cnblogs.com/fengyun627/archive/2009/07/27/1532551.htmlLiterature
Oracle View Add notesCopyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.Create or replace view Oes_material_series_ref asSelect T.productgroup, O.idnrk materialcode, T.seriescodeFrom
The three complex type variables that are frequently encountered in the actual project. Combine some of the project examples to do a collation, the specific following:
Record type: A record type can contain one or more members, and each
In the first two chapters, we learned some basic SQL language query statements, that is, the database query Language DQL, today we want to introduce the database operation language DMLDatabase, in addition to our query, the main thing is the daily
At the same time, modify Tnsnames.ora, Listener.ora the two files in the host behind hosts are modified to 127.0.0.1 and then restart Oracleservicexe, Oraclexetnslistener servicesListener.ora file revised toSid_list_listener = (Sid_list = (Sid_desc =
The installation process is relatively simple. Follow the steps to go. Here is a reminder to use PL/SQL to operate Oracle. It is best to install 32-bit Oracle programs. The reason is that the web says PL/SQL only supports 32-bit Oracle, assuming
1. Use rownum you must include the first record, and if you do not include the first record, the result will not be returned. Because RowNum is a pseudo-column, it is a column that is added after the result set. And it was arranged starting from 1.2,
Declare --Defining VariablesV_enamevarchar2(5); V_sal Number(7,2); begin --Executive SectionSelectEname,sal intoV_ename,v_sal fromEmpwhereEmpno=&AA; --Display the user name in the consoleDbms_output.put_line ('the user name
1. Subqueries Solve the problem: When a simple query query does not reach the results, you can use a subquery to enrich the conditions of the query to achieve the purpose of displaying the results.The format of a subquery: include it with a
1. What is a primary key ?A: You can uniquely and fully identify a combination of data columns and rows in a data table, only one and cannot be empty.2, what is the foreign key ?A: A foreign key for another table exists in one table.3 . Differences
1. MERGE into usesMERGE into is a new feature that appears only after Oracle 9i. So what is this feature?To put it simply, it is: "There are updates, none are inserted"From this sentence, it should be understood that when merge into operates an
Oracle-07-Data Type example & query Current System Time & create table syntax
I,
Explanation: number (6, 2) specifies four digits for the integer part and two digits for the fractional part. Therefore, the three digits for the integer part 123.456
Oracle Database elementary learning, oracle Database elementary
SQL query statement on the first day
CMD--SQLPLUS ---- account soctt password tiger, enter the SQL database after the input is complete, it shows that the connection is successful.
OracleEBSLOV Speed Optimization
I. symptom
When the SQL statements of our EBS LOV are complex, or the data volume is large, the LOV pop-up display speed, or directly fill in the ticket number and move it to another input box (when the Validate
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service