Oracle basic concepts and comparison with informix
I. ConceptsUser: informix directly uses the user management system of the operating system. Generally, root and informix are used as super operators to manage other users. Oracle has its own user
The racle database system is a complex software system. Without understanding its internal structure principles and relationships, it is impossible to design and Compile High-Quality application software systems or manage a complex application
In the normal development, to repeat the data often used to, I novice, contact Oracle also soon, the development of small knowledge points, record, the birds can bypass, if there is wrong, please correct me.To duplicate records can use distinct,
NonsenseIt's been about N years since the last time I contacted Oracle database, and the way Oracle works and some of the dots is special, it feels like a wonderful thing! Recently regained memory, has been tossing Oracle, because Oracle is
I. Oracle case
1. Oracle instancesSystem global area (SGA) and background process are used as database instances.
2. Oracle DatabaseA collection of physical files (data files, control files, online logs, parameter files, etc)
3. system global area
Oracle uses two types of cursor: explicit cursor and implicit cursor. No matter how many records are returned by the statement, PLSQL implicitly
Oracle uses two types of cursor: explicit cursor and implicit cursor. No matter how many records are
The racle database system is a complex software system. Without understanding its internal structure principles and relationships, it is impossible to design and Compile High-Quality application software systems or manage a complex application
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
How to count the total number of records deleted after execution of the delete statement in PLSQL.
Oracle uses two types of cursor: explicit cursor and implicit cursor. No matter how many records are returned by the statement, PL/SQL implicitly
Yesterday I saw a colleague using the PL/SQL developer tool to move text data to Oracle tables, with two texts, one with 300,000 records, and 70,000 records.In the process of import, the error record also needs to click Confirm. But use black
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.