Oracle

☆dba_ opening .....Dba_users Database user InformationDba_segments Table Segment InformationDba_extents Data Area InformationDba_objects Database object InformationDba_tablespaces database table Space informationDba_data_files Data File setup

Create a new temporary tablespace Tmpa Create temporary tablespace tempa tempfile '/oracle/tmp/tempa01.dbf ' SIZE 8192M reuse autoextend on NEXT 1024K MAXSIZE UNLIMITED;2. Specify the default temporal tablespace as TmpaALTER DATABASE default

Oracle provides a sequence object that provides self-growing serial numbers from the system, typically used to generate the self-growing primary key or ordinal of a database data record.Here are some common operations on sequence generation,

1.ASCII returns the decimal number corresponding to the specified character;Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual;A A ZERO SPACE--------- --------- --------- ---------65 97 48 322.CHR gives an

The Oracle database has three standard backup methods, namely export/import (EXP/IMP), hot backup and cold standbyReport Exporting a spare is a logical backup, and cold and hot backups are physical backups.First, export / import

Do not know what to do, the data sheet locked, unable to update.Baidu has a variety of methods, summarized as follows.Check the locked table (two sentences are available):SELECT * from v$session T1, V$locked_object T2 where t1.sid=t2.

System permissionsSystem permissions refer to whether the authorized user can connect to the database and what system operations can be performed in the database.System permissions are the right to perform some kind of operation at a system level in

I. Stored procedures and FunctionsStored procedures: Encapsulation of a moduleFunctions: Functions are almost the same as stored proceduresDifference:function must return a value via the return keywordStored procedures:Return value is not

Problem Description:A cell, need to follow the plot, Wendy, unit number, room number, but sort by address description, because the string contains a number, so the result is as follows,Building 1th is supposed to be building 2nd, but the search

1 --Querying table Information2Xxx_tables--contains basic descriptive and statistical information for a table3Xxx_tab_columns--contains descriptive and statistical information for the columns in the table4Xxx_all_tables--contains all the

1, Oracle is a large database and MySQL is a small and medium-sized database, MySQL is open source and Oracle price is very high.2, Oracle Support large concurrency, large traffic.3, the space used to install the difference is also very large, MySQL

What are the available commands for 1> Oradebug? Log into the database as SYSDBA, through Oradebug help can see oradebug commonly used commandsSqlplus/as SYSDBAOradebug Help 2> Tracking Current session informationOradebug Setmypid--Track current

DECLARETYPE cst_table_list is Table of VARCHAR2 (40); TYPE Cst_list is TABLE of VARCHAR2 (40);TYPE Name_list is TABLE of VARCHAR2 (40); TYPE Type_list is TABLE of VARCHAR2 (20);Cst_tab_name cst_table_list:=cst_table_list (); Cst_name

Simply record the process: (in fact, the guidance of the help page is very simple and clear) Download installation files OracleXEUniv.exe, run directly; Most of the steps go directly to the boot, note where the password is required, this

Copying tables-- Copying Tables Create Table as Select * from Product-- duplicate table structure no data Create Table as Select * from where 1 = 2Following a condition that is not established in the where, only the structure of the table is

Download 3 things first: The link forgot, we look for a1 ora+11+g+r2+server+64bit+for+windows.iso (Oracle installation file)2 Plsql3 oracle64-bit clients Instant client v11.2.0.3.0 (64-bit). exeon the next server, install

1 What is a module? Common scenario: A module is a file that contains Python definitions and declarations, and the file name is the suffix of the module name plus the. Py.In fact, the import loaded module is divided into four general categories:1

1. What is NULL?Null means Unknow (unknown), which does not mean whatever the value is.For example, a column in a row does not have any value or null.Oracle agrees that no matter what type of data the field is empty, in addition to the following two

The interface return message is in JSON format, as follows:{"Body": {"Businessinfo": {"c1rate": "25.00", "C2rate": "0.00", "C4rate": "0.00", "C5rate": "0.00", "C6rate": "6.00", " C8rate ":" 0.00 "," D1rate ":" 0.00 "," D2rate ":" 1.00 "," Riskcode ":

One, stored procedures can not be used directly in the Insert,update,delete, you can have a return but the exit process has three types: do not return a value, you can return multiple values, there are three types of parameters, such as: in: Enter