Oracle

Oracle Data Structure DeploymentCase: -1, query dbf file location Select Tablespace_name, File_id,file_name, round (bytes/(1024*1024), 0) Total_space from Dba_data_files ORDER by Tablespace_name; SELECT * from Dba_data_files;--/home/

I have not encountered an array of this type before, and recently encountered the need to solve the problem of arrays, find a bit about the use of arrays, now sorted down.Arrays in Oracle are divided into fixed arrays and mutable arrays.One, fixed

First, the View(a) What is a viewA view is a database object, a virtual table that is exported from one or more data tables or views, and the data for the view is not really stored in the view, but is stored in the referenced data table, and the

Five, single-line function(a) Character functionsCharacters commonly used function explanation:(1) To find the length of the stringStatement:select length(‘ABCD‘) from dual;The results shown are:(2) substring of string SUBSTRStatement:select substr(‘

Iv. synonyms(a) What are synonymsA synonym is essentially an alias for a specified schema object. Synonyms provide a degree of security by masking the names and owners of objects and providing location transparency for remote objects in a

Before writing SQL, you know that MySQL multi-field fuzzy queries can use [charlist] wildcard characters, such as:SELECT * from PersonsWHERE city like ' [aln]% 'However, when querying in this way in Oracle, it is not possible to query the resultsYou

DECLARE Str Varchar(Ten);--define a string variable strBEGIN forIinch 1..10000000Loop-- INSERT into Fw_test (NAME) VALUES (' BBB ' + i);D ecode (' 1 ', ', ', ', ' DECODE ', ' 2 ', ', ', ', ' DECODE ', ' 3 ', ', ', ' 2 ' | | ' 3 '))) NVL2 (' 1 ',

EnvironmentOS: CentOS 7.4; hosts: L134; IP: 192.168.1.134 Oracle安装文件目录：/opt/oracle_install ORACLE_BASE：/data/app/oracle ORACLE_HOME: /data/app/oracle/product/11.2.0/db_1 oraInventory: /data/app/oraInventory Oracle数据目录：/data/app/oradata/ Method

We create a new database tablespace operation on a local Oracle or on VirtualBox Oracle:Create and authorize through the system account/*--Create TABLE spaceCreate Tablespace YujkdataDataFile ' c:\yujkdata200.dbf '--Specify the path to the DataFile

MySQL differs from OracleArticle Category: DatabaseFriday went to a company to interview, the company manager asked about the difference between MySQL and Oracle, did not summarize before, the answer is not very good, just by feeling, first summed

1. Stored Procedures and storage functionsDescription: A subroutine stored in a database that is called by all user programs called stored procedures, stored functionsDifference: The storage function can return the value of a function through the

There are two ways to run an Oracle database: Archive (ARCHIVELOG) and non-archive (NO ARCHIVELOG). In non-archive mode, the log switch overwrites the previous redo log files directly and does not generate an archive log. The database runs under

1. Turn off all Oracle services. Can be turned off in the Windows Service Manager;2. Open the registry: Regedit Open path:Hkey_local_machine\system\currentcontrolset\services\Remove all service names starting with Oracle under this path, which is a

Alter any index to modify permissions on arbitrary indexesAlter any role to modify permissions for arbitrary rolesAlter ANY SEQUENCE permission to modify any sequenceAlter any snapshot permissions to modify any snapshotAlter any TABLE permission to

1. Develop WindowsFeature (program) in the Linux extension interface (in fact, from the Windows2008 before the release of the trial, it was found secretly hidden a UNIX interface option).2. The Windows Store can be downloaded to Ubuntu for

Data file related knowledgeTo see how many data files are in the system we can view them through a Dynamic Data dictionary or a static data dictionary: View data files from a static data dictionaryView data files with a Dynamic Data

I. Tree-like index features1. Low height2. Store column values3. Orderly structureLet's look at the structure of the index first.The above structure diagram illustrates that the index is composed of root (root block), Branch (STEM) and leaf (leaf

Use data pump technology for logical backupsLogical Backup OverviewA logical backup is the process of creating a logical copy of a database object and depositing it into a binary dump file. Essentially, logical backup and recovery is actually the

Remember to implement MD5 encryption, in Oracle 11g and 12c there are different ways, in 12c is simpler, remember directly have predefined functions.But in the 11g to implement the need to do some additional processing, the following gives a MD5

Issue Background Description:One day the customer has a demand, given a number of mobile phone numbers or phone numbers, to find out the relevant call records, as well as some related information.Customer-given called number:The results of the query