Oracle

Temporary tables in Oracle can be divided into session-level temporary tables and transaction-level temporary tables.The role of temporary tables: for large amounts of data we just need to query a subset of the result sets so that we can use

　　Other database objects:Sequence (SEQUENCE)Indexing (Index)Views (view)1. Sequence (SEQUENCE)Corresponding Database dictionary: user_sequences　　　　Role: A database special object used to produce a unique valueTo create a sequence syntax:Create

In an Oracle database, setting ID auto-increment is not as simple as MySQL, and a sequence needs to be set in Oracle.Now give the way, specifically as follows:First step: Create a tableCREATE TABLE Contestdb ( TID number () PRIMARY KEY,

Overview:When the amount of data in the table is increasing, the query data slows down and the performance of the application degrades, so you should consider partitioning the table. After the table is partitioned, the logical table is still a

1 Visibility The visibility of the index (visibility) refers to whether the index is visible to the CBO optimizer, that is, whether the CBO optimizer considers the index when it generates the execution plan, and can be considered an attribute of the

I. BACKGROUNDFollowing the Oracle Backup Restore Practice (link address: http://kaliarch.blog.51cto.com/8966921/1978151), due to business growth, frequent backup restores have a greater space requirement for disk space, The basic 500G per week of

SELECT * from Sh_gonghuo_renyuan as of timestamp to_timestamp (' 2017-11-17 16:00:00 ', ' yyyy-mm-dd hh24:mi:ss ');--3, recovering deleted and committed dataALTER TABLE Sh_gonghuo_renyuan enable row movement;--flashback table Sh_gonghuo_renyuan to

Premise:1, please be sure to install Oracle at win at least 5 times.2. Be sure to master the basic Linux commands.Prepare the Oracle linux64-bit installation package (official download of 2 compressed files)Ready virtual machine VMware and Linux

Today the Data group someone response website can not open normally, after checking Oracle database remote connection is not on, message: Ora-00257:archiver error. Connect internal only, until freed. Maybe the archivelog is full . Before learning

1 Create or Replace functionWork_plan_mask (P_schemaVARCHAR2, p_tableVARCHAR2)2 3 return Varchar2 as --data control, specifying that certain people can only view information within their purview4 5V_predicateVARCHAR2( +) := '1=2';6V_personcode

1 First modify the/etc/oratab file to add the following line:Ycr:/u01/app/oracle/product/12.1.0/dbhome_1:yAn explanation of the/etc/oratab file is as follows:# This file was used by ORACLE utilities. It's created by root.sh# and updated by either

#!/bin/sh#start Mutli Oralce Instance#create by Zwy#date 2017-10-25Port_cnt= ' Ss-lnp|grep 1521|wc-l 'if (($port _cnt {Lsnrctl Start &Port_cnt= ' Ss-lnp|grep 1521|wc-l 'while (($port _cnt Do{Echo ' Ora lsnrctl is not running 'Lsnrctl Start &Port_cnt=

Select table_name from User_tables; The current user's tableSelect table_name from All_tables; All users ' tablesSelect table_name from Dba_tables; including system tablesSelect table_name from dba_tables where owner= ' user name

Oracle Notes (14) User managementSQL statements are divided into three categories: DML, DDL, DCL, before the DML and DDL have been explained, now the DCL operation, DCL mainly represents the database control statements, control is the operation of

(+) in Oracle is a special usage, (+) represents an outer join, and is always placed on the side of a non-primary table.For example, left OUTER join:Select A.A,B.A from A left JOIN B on a.b=b.b;Equivalent toSelect A.A,B.A from a b where a.b = b.b (+)

Previously obtained Oracle database backups are typically DMP files, creating tablespaces and users directly using IMP or IMPDP import.This time I encountered a special situation, the other side of the data provided to me is the use of Sqlplus

Oracle generates non-repeated ticket numbers and LPAD, RPAD and NEXTVAL function parsing, and lpadnextval SELECT TO_CHAR (SYSDATE, 'yymmdd') | LPAD (REFUNDSEQ. NEXTVAL, 6, '0') AS RES_ORDER_NO FROM DUAL The statement splicing time is consistent with

Solution for failing to open the entire database due to accidental deletion of pdb data files in oracle 12c, 12 cpdb Preface Recently, a colleague accidentally deleted the data files of a plug-in Database (PDB), and the results showed that the

Methods and precautions for using forced indexes in Oracle, oracle Indexes Oracle forced Index In some scenarios, ORACLE may not automatically take the index. In this case, if the business is clear, you can try to use a forced index to test the

Oracle uses Dblink and oracle uses dblink The DBLINK database link is a schema object in a database, allowing you to access objects in another database. The dblink qualifier allows you to reference objects in a database other than the local database.