Oracle

The meaning of several Oracle nameDb_name:Database name: Show parameter Db_name,db_name There is also a very important role is to dynamically register the monitoring, whether or not specified service_name, or the value of service_name, Pmon will use

materialized views for data replicationOne of the main functions of materialized views is for data replication, Oracle's advanced replication capabilities are divided into two parts, multi-master replication and materialized view replication.

How Oracle's DATE type is displayed depends on the Nls_date_format initialization parameterThe Nls_date_format parameter can be set at several levels1. Database level-If you want everyone to see data in some format, run Sql>alter system set nls_date_

1. What is an exception?A: Exceptions are errors that occur when the program is running! Short run-time error. After an exception occurs, the statement stops executing and control shifts to the exception handling section.Some exceptions are

Private voidsavebinary (InputStream in, Long userId, String fieldName) {SQL SQL=NewSQL ("INSERT into EEAS_USER_ATTH (id,content,user_id,atth_name) VALUES (SEQ_EEAS_USER_ATTH. Nextval,?,?,?) "); Sql.addparameter (NewParameter (Datatype.blob, in));

A. Forget the login password for users other than SYS and system users.Log in with the SYS (or system) user.CONN Sys/pass_word as SYSDBA;Use the following statement to modify the user's password.ALTER USER user_name identified by Newpass;Note:

A data dictionary is an important part of the Oracle database, where metadata (matedata) is stored, and Oracle RDBMS uses the database to manage object information and security information. The database administrator can obtain information about

Common heap Table deficiencies:table Update has log overheadTable Delete Defectivetable record too large retrieval slowindex Back table read cost is largeorderly insertion difficult to read out in order Delete produces the most undo, redo also the

Materialized view of Http://www.cnblogs.com/Ronger/archive/2012/03/28/2420962.htmlOracleIn the near future, according to the project business needs to the Oracle materialized view has the contact, searches on the net on this aspect information,

--Test dataCREATE TABLE Rowtocol_test asSelect year,1 Month, ' Department 1 ' dept,50000 expenditure from dualUNION ALL Select 2009, 2, ' Department 1 ', 20000 from dualUNION ALL Select 2009, 2, ' Department 1 ', 30000 from dualUNION ALL Select 2010,

Flashback technology has a flashback table, a flashback delete, a flashback query, a flashback transaction query, a flashback transaction, a flashback database, and a flashback data archive. Among them, the flashback query, Flashback transaction

Sequence: is a database object provided by Oacle to produce a series of unique numbers.L automatically provide a unique valueL Shared objectsL mainly used to provide primary key valueL Loading sequence values into memory improves access efficiencyTo

Serial number Function description Shortcut keys Note 1 Hide Query Results F2 2 View Object Details F4 3 Clear Screen F7 4 To

Using Oracle's Sql*net v.2 to connect clients and servers, you need to configure each client and server.     The files that need to be configured on the server are: Listener.ora,/etc/services, and the Tnsnames.ora file needs to be configured on the

Use commands to create an oracle11G Database This document describes how to create an oracle database that complies with the OFA specification using the create database Command of the oracle database. 1. Set the environment variable (vi.

Oracle Database experience series-Article 11) change the date display type of the query results in SQL developer in oracle 11g r2, that is, the setting of the session date type:Alter session set nls_date_format = 'yyyy-MM-DD HH24: MI: ss ';Oracle

PLSQL _ performance optimization series 03_Oracle Parallel concurrency, plsql03_oracle 2014-09-25 BaoXinjian I. Summary For a large task, the general practice is to use a process for serial execution. If the system resources are sufficient, you can

Concurrent execution of mongolerman's backup of a single file If a file is a file of several gigabytes or tens of thousands of megabytes, You Need To parallelize the backup of the file. Generally, one channel can only read one file, however, you

Oracle login connection I. Login 1. Use the client Directly configure in database: IP: 1521/orcl The IP address is the IP address to connect. 1521 indicates the port of the database to be connected. Orcl indicates the Instance name of the

Oracle learning-literacyPreface I have been dealing with Oracle databases over the past few days. Since I have not learned much about Oracle before, I just used Oracle as a data source. I don't know much about it. For example, databases, database