Oracle

Directory structureInit script|----orcl_sql|----init_user.sql|----tab_home.sql |----Tab_user.sql |----init.batInit.bat@echo Off@echo---------------------------------------------------------------------@echo ^| ^| @echo ^|

Transaction:A transaction is a set of related actions performed as a single logical unit of work.These operations require all or none of them to be completed.Reasons for using transactions: Ensure data is safe and effective.Four characteristics of a

First, the System environment settings1. Modify Host NameVim/etc/sysconfig/networkHostname oracledb2. Add IP and host name correspondingVim/etc/hosts192.168.1.128 OracleDB3. Installing dependent PackagesYum-y install gcc gcc-c++ make binutils compat-

1 CREATE OR REPLACE TriggerTrig_solr_index_el_lesson2AfterUpdate ofLessonid, Lessonname, lessongoal, note, TeacherName, Teacherid, Classidname, ClassID, Crtime, statusOr Delete or Insert onEl_lesson3 forEach Row4 Declare5 --Local Variables

SELECT a.table_name table name,c.comments Table notes,A.column_name Field Name,REPLACE (DECODE (A.data_type,' DATE ',' DATE ',' VARCHAR2 ',' VARCHAR2 (' | | A.data_length | | ‘)‘,' Number ',' Number (' | | a.data_precision | | ', ' | | A.data_scale |

1. PL/SQL Interpretation Plan windowAdvantages: AspectsCons: See limited information2. Explain_plan forEasier to optimize for a sentence3, SqlplusEnter the command in Sqlplus:Set Autotrace onSELECT * from EMP;After the data is displayed, follow the

Issue 1: Hint OraOps10.dll cannot be found.Workaround: Click Security in the properties of the Client_1 folder, and set the permissions of the authenticated users to all.Issue 2: After obtaining the model, it is found that the obtained binary is

Oracle's SQL statement optimizationOptimization of SQL statements1. The Oracle optimizer cannot use indexes when using is NULL or is not NULL in the WHERE clause.2. For connected columns, even if the most one is a static value, the optimizer does

The following error occurred while connecting to the database (two libraries were created, one is ORCL and the other is prod): sql> conn / as sysdbaconnected to an idle instance. SQL > Startupora - 00119 : Invalid specification for

1 administrator identity into the CMD environment, execute the DBCA command, in the boot of the popup window, complete the instance creation2 if the appropriate character set is not selected during the creation process (preferably with the default

When your application has called the stored procedure, and the node has dozens of or hundreds, the wrong is not a very troublesome thing, this time, I suggest to write to the database, below is a demo I do.1. Create an error log record tabledrop

Table version and flash back featureUsers may frequently create and delete the same table multiple times, such as:CREATE TABLE TEST (COL1 number);INSERT into TEST VALUES (1);CommitDROP TABLE TEST;CREATE TABLE TEST (COL1 number);INSERT into TEST

Oracle hierarchical query and Oracle hierarchical Query The syntax for Oracle hierarchical query is as follows: The following are based on two questions: 1. according to the chronological order, the English names of the twelve constellations are

Oracle -- Transaction, oracletransaction Transaction: A transaction is a group of related operations performed as a single logical unit of work. All or all of these operations are required to be completed. Reason for using transactions: ensure data

Use of Oracle memory database Timesten (1)Timesten Installation ...Development Environment Information192.168.57.80/opt/timesten/TimesTenDaemon pid 12239 port 53396 instance ttgjdsTimesTen server pid 12248 started on port 53397Start and Stop the

Difficulties and key points encountered during the installation of OracleRAC (2) (1) install dependency packages In addition to system configuration parameters, installing Oracle in Linux is another Trivial operation. This installation encountered

Oracle remote database connection Solution Background: the Oracle server is installed on the server, and others use PL/SQL for remote connection. Many regions, because the Oracle database is too large, installed on the local machine will lead to

Summary of paging query for oracle, mysql, and SqlServer Databases Database Paging query statement Description MySql "QUERY_ SQL limit ?,? "

Oracle 11G creates tablespaces, users, configuration listening, and TNS, 11 gtns Recently, I have been installing various versions of the oralce database for testing, 11 GB, 32-bit, 64-bit, 12C. Every time I go through the tablespace, what about

Oraclebetweenand Boundary Problems -- Create a table create table test_hsj (id int primary key, num varchar2 (12), regDate date) select * from test_hsj; -- insert test data insert into test_hsj values (1, '1', to_date ('2017-05-01 ', 'yyyy-MM-dd')