First, what is a businessTransactions are used to guarantee the consistency of data, which consists of a set of related DML statements that are either all successful or fail altogether in the group's DML (data manipulation language, additions and
I. Using profile to manage user passwordsOverview: Profile is a collection of commands that are password-constrained and resource-constrained, and when a database is established, Oracle automatically establishes a profile called default. When the
Grouping functionsIn a grouping function, if there is a find item grouped, the other items must also be grouped, for example, the following statement will be an error because Sal is grouped, and ename is not grouped:1. Show the highest paid
As we all know, there is a snapshot in the VMware virtual machine function, we can put the system at this time to save the state, the side of a contingency event, or restore the system, Oracle also has similar features.First create a student
As mentioned above to create a data restore point, the premise of data recovery is that we use the Delete command when deleted, delete will write the log during the deletion (so that our data can be recovered), of course, the write log will cause
Oracle uses virtual column rownum to query the number of records between a specified number.The first line of Rownum=1For example, we want to query the first five records, you can useSELECT * FROM table name where rownumBut if we use rownum>5, we
1. Parse tables and indexes (analyze does not rebuild the index)Analyze table TableName COMPUTE statisticsEquivalent to analyze table TableName compute statistics for table for all indexes for all columnsStatistics for table exist in views:
1. View instance name: Show Parameter instance_name2. Check to see if the database archive is open: Archive log list3. View SPFile parameters: Show Parameter SPFile4. View Log file location: Select Group#,member from V$logfile5. View archived files:
Create userOverview: In Oracle, to create a new user using the Create USER statement, you typically have DBA (database administrator) permissions to use.Create User by password;(Oracle has a problem, the password must start with a letter, if it
Oracle database installation to reserve 5G space, Oracle Common version· Oracle8, oracle8i: where "I" means the Internet, which means that Oracle is starting to evolve to the network,· Oracle9i: Is the stable version of Oracle8i, but also now see
1. View the current user's basic information
SELECT * FROM User_users
2. View the role of the current user
SELECT * FROM User_role_privs
3. View System permissions and table permissions for the current user
Oracle grouping Query
Grouping FunctionsIn the grouping function, if a search item group exists, other items must be grouped. For example, the following statement reports an error because sal is grouped, but ename is not grouped:
1. display the
Oracle merge Query
1). UnionThis operator is used to obtain the union of two result sets. When this operator is used, repeated rows in the result set are automatically removed.
2). union allThis operator is similar to union, but it does not
Quick oracle data deletion
The above describes how to create a Data Restore point. The premise for data recovery is that we use the delete command to delete the data during deletion, delete writes logs during the deletion process (so our data can
Oracle user management instance
User Roles in oracle are divided into predefined roles and custom roles.A role is a combination of common permissions to form a role.Authorization/Role Assignment CommandGrant permission/role to userCommand for
The seventh day of oracle LearningZookeeper
1. Review in the previous section2. Advanced PL/SQL3. oracle View4. oracle triggersObjectives:1. Master advanced PL/SQL usage (the paging Process Module and the order process module can be compiled ...)2.
Oracle retrieves data from each table and saves it to another table.
Obtain data from each table and save it to another table:
CREATE VIEWPARAMETER_viewWITHTall(SELECTP. PI_NO, -- product serial numberP. SERIALNO, -- product no.P. PI_NAME, --
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