Oracle

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

Oracle restores data from a table to a point in time OraclesqlExecute the following SQL to restore data from the Test_temp table to 2011 04 29 11:06:00Note that it is important to delete all data first, otherwise it may result in duplication of

1. Querying partial field properties of a tableSelect T.*, c.comments from user_tab_columns T, user_col_comments c where t.table_name = C.table_name and t.colum N_name = C.column_name and t.table_name = ' El_lesson ' and T.column_name in ('

Scenario Description: Sometimes we may not know a user's password, but also need to do some of the user's identity to do some operations, and can not modify the user's password, this time, you can use some tips to complete the operation.Original

-- Create ACL BEGINDbms_network_acl_admin. Create_acl(ACL =' Email_server_permissions.xml ', Description=' Enables network permissionsfor the E- mail server ', Principal =' Ljz ', Is_grant =TRUE, Privilege=' Connect '); END; ?--

DefinedSet SERVEROUTPU on is an output method that enables Oracle to use its ownDbms_output.put_line (' XX ');Scope of Useused in PL/SQL COMMAND window,sql PlusPermanently validIn order to not need to enter set Serveroutput on each time you can

Monitoring scripts executed by Oracle SQL statements! [@[email protected]]--Find the method for bad sql:SELECT * FROM (select Buffer_gets, Sql_textFrom V$sqlareawhere Buffer_gets >500000ORDER BY buffer_gets Desc) where rownum--Perform the number of

View tablespace objects in ORACLE and objects in oracle How Does ORACLE view the database objects stored in the tablespace? You can use the following script to simply query the objects stored in the table space: SELECT TABLESPACE_NAME       AS

Oracle BASICS (iii) Database Management This article introduces the basic operation commands for Oracle databases: add, delete, modify, and query. The following describes how to manage databases.Database role Introduction Data Administrator: at

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

(Summary) Oracle 11g Common Management commands (user, tablespace, permission), oracle11g 1. Start the oracle database: Switch from root to oracle:Su-oracle Enter the sqlplus environment. The nolog parameter indicates not to log on:Sqlplus/nolog Log

Oracle creates restore points before sensitive operations We all know that there is a snapshot taking function in the vmwarevm. We can save the status of the system at this time. When an unexpected event occurs on one side, we can also restore the

Oracle password management allows a user to log on up to three times If a user fails to log on three times in a row, the user is locked for two days. After two days, the user can log on again.Create a profile file:Update account: After three logon

Oracle user management 1. Create a new user (normal)Create user Username identified by passwordFor example, create a user named James with the password xm2. Change the password of an ordinary user as an administrator (when a common user forgets his/

PLSQL cannot directly connect to a 64-bit Oracle11g Database After the Oracle 11g Database is installed today, plsql cannot be used to connect to the database. The Database drop-down box in the plsql client logon window is empty. See:     

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

Configure network services in Oracle For Oracle, whether connecting to a local database or remotely connecting to a server database, you must configure a network service on the local machine to connect. You may not understand why.Take SqlServer for

Modify logon authentication mode in oracle By configuring the sqlnet. ora file, we can modify the oracle login authentication method.SQLNET. AUTHENTICATION_SERVICES = (CNT); operating system-based authenticationSQLNET. AUTHENTICATION_SERVICES =

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.

The fifth day of oracle LearningZookeeper 1. Review in the previous section2. maintain data integrity3. Manage Indexes4. manage permissions and Roles 1. Skills in maintaining oracle Data Integrity2. Understand the index concept and create an index3.