Oracle

I. Overview　　1. What are views (view)　　　　views The logically related collection of data (which is a virtual table) extracted from the table.　　2. Why use a View1. Control access2. Simplify your query　　3. Classification of views　　　　Second, view

There is no workaround for libclntsh.so.11.1 errors when executing Oracle programs under root.First determine the directory where the libclntsh.so.11.1 is located:[Email protected] ~]$ Locate libclntsh.so.11.1/usr/local/oracle/product/11.2.0/dbhome_1

ReasonAfter some verification, found that the source of the problem is not on the plsql, but on our Oracle, because our Oracle database character set does not support the Chinese cause, since we know the reason, it is good to do, we configure our

Date Processing Time Date type The date datetime type, which contains the time portion of the year, month, day, hour, minute, second, not containing the number of decimal digits and time zone of the second. Valid data range is January 1, 47

Hee HeeMicrosoft Windows [version 10.0.16299.125] (c) Microsoft Corporation. All rights reserved. C:\users\zhouk>sqlplussql*plus:release 11.2.0.1.0 Production on Fri December 20:01:03 2017Copyright (c) 1982, Orac Le. All rights reserved. Enter the

Query for WHERE statement--WHERE clause--The Enquiry department number is 10 of all employeesSelect * fromEmpwhereDeptno= Ten;--employees in the enquiry department with a salary of 3000Select * fromEmpwhereSal= the;--find the employee with number

Examples of conversion functions for Oracle Show--Automatic type conversionSelect 1+'1' fromdual;--preceded by a string that is automatically converted to the date typeSelectAdd_months ('January-July on -2017',2) fromdual;--to_number To_char

This document contains almost every aspect of Oracle cursor use, and all passes the test--declaring cursors; cursor cursor_name is select_statement--for Loop Cursors--(1) Defining cursors--(2) Defining cursor variables--(3) Use this cursor with a

Introduction to 1.Oracle databases What is the difference between a database system and a database management system?parsing: Database system = Database management system +oper+ operator + hardwareOracle Database management systemCore products of

1.Oracle ArchitecturePart One: Memory level>SGA (Shared pool, data buffer, log buffer)> Core process (Pmon Process Monitor/smon System Monitor/DBWR (write process) LGWR log write process CKPT checkpoint)Part Two: HDD levelFiles: Log files, data

Source: https://www.cnblogs.com/linjiqin/archive/2012/01/15/2323030.htmlFirst, what is the waterline (high water Mark)?All Oracle segments (segments, where, for ease of understanding, suggest segment as a synonym for a table) have a limit on the

1.sid:Format one: Oracle JDBC Thin using an SID:Jdbc:oracle:thin: @host:p Ort:sidExample:jdbc:oracle:thin: @localhost: 1521:ORCLThis format is the simplest and most usedYour Oracle SID can be obtained through a command:Sqlplus/as SYSDBASelect value

Test environment above Oracle database performance parameter settings1. Close the Recycle BinAlter system set Recyclebin=off2. Modify the size of the redo logThe default size of 11g is 50m if redo file compares small OLTP logs more than the case

--Retrieve data from one hours agoSELECT * from sys_system_dictionary as of timestamp sysdate-1/24ORDER BY ID The use of the as of timestamp method is very convenient, but in some cases we recommend using the as of SCN to execute flashback

You are welcome to exchange technical issues with us:Email: [email protected]Blog Park Address: Http://www.cnblogs.com/jiangxinnjuGitHub Address: Https://github.com/jiangxincodeAddress: Https://www.zhihu.com/people/jiangxinnju

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is

2011-05-10 14:57:53Category: LinuxFirst, the memory structureSGA (System Global area): Shared by all service processes and background processes;The PGA (Program Global Area): is proprietary to each service process, background process, and each

Oracle Flashback: Automatic disk-based backup and recovery that restores a table to a point in time or SCN.1. View the Flash back zoneSql> Show parameter db_recovery_file_dest; View the details of the Flash back zoneSql> select flashback_on from

Long: variable long string data, longest 2g,long with VARCHAR2 column, can store long text up to one long column in a tableLong RAW: variable Long binary data, up to 2GCLOB: Character large object CLOB used to store single-byte character dataNCLOB:

Small table hotspot disks with abnormal methods for conversion of large data volumes, abnormal hot spots   I encountered a strange problem. There are two tables, which are about 0.3 billion of the Data. Table A has the A1 field, table B has the B1