Oracle

The installation process for Red Hat Enterprise Linux 7.1 was introduced in the previous article, with minimal installation.See http://xdwqs.blog.51cto.com/4758880/1621643Oracle Enterprise Linux is a company-class Linux distribution supported by

For Oracle, use code FirstThis article is good:Http://www.cnblogs.com/wlflovenet/p/4187455.htmlAdd:The article mentions machine.config need to have:If you only install Oracle managed drivers through NuGet in VS, there is no.At first I do not care,

If you mistakenly delete the data file test.dbf of test in a tablespace, and then the next time you restart the database, the database cannot be opened (open) .always error: sql> ALTER DATABASE open;ALTER DATABASE open*ERROR at line

When deleting the data table often encountered foreign key constraints cannot be deleted, we can delete the database table through the following steps, it is recommended to delete the library before the database backup, develop good habits. 1.

Package left file:is varchar2varchar2); End S02_zfrzpt_ys_mid; Package right File:CreateOrReplace package body S02_zfrzpt_ys_midIsProcedure Start_cal (strgranularityInchVarchar2,--1st, 2,3,4: month; 5: quarter; 6: Half year; 7: Year

Package left file:CreateOrReplace Package Call_detailsIsStrdatarangeVARCHAR2 (1):=‘1‘; Numrow_numNumber5):=1; Numcol_numNumber5):=1; Total_currencyVARCHAR2 (2):= 01 ' Package right File:CreateOrReplace package body Call_detailsIsProcedure Start_cal

SELECTUPPER(F.tablespace_name) Tablespace name, D.TOT_GROOTTE_MB table space Size (M), D.TOT_GROOTTE_MB-F.total_bytes "used Space (M)", To_char (ROUND ((D.TOT_GROOTTE_MB-F.total_bytes)/D.TOT_GROOTTE_MB*100,2),‘990.99‘"Use ratio", f.total_bytes "free

2, the database connectionUsing Sqlpluse to connect to the database, the tnsping Test command detects whether the database test can be connected2.1, the database in the local1 sqlplus userName/password@orcl--ORCL for Oracle database SID2 Sqlplus

--The first step, query the Istaudit database file ID, file pathSelectFile#,nameFrom V$datafilewhereLower (name)Like‘%istaudit.dbf‘;--The second step is to query the maximum module of the Istaudit database fileSelectMax (t.block_id)From Dba_extents

A check constraint is an inspection constraint that, when using a check constraint, checks every data entered, and only records that meet the criteria are saved to the table, guaranteeing the validity and completeness of the data.Check constraints

Sometimes we encounter problems that the database is not able to connect to, and of course there are many reasons for this problem, one of which is because the database service is not started.Here's how to start the Oracle database service:Very

Method OneReturns a null representation string that returns a value greater than or equal to 1 with a non-numeric characterSelect LENGTHB (LTrim (' 1248346 ', ' 0123456789 ')) from dual;OrSelect LENGTHB (RTrim (' 1248346a ', ' 0123456789 ')) from

Optimize common oracle SQL statements 1. execution efficiency caused * Minimize the use of select * For queries. When you use * For queries *,The database parses and converts * to all columns. Select count (si. student_id)From Student_info si

Add notnull constraints to oracleWhen creating a table, add the not null constraint to the column in the following format:Column_name data_type[Constraint constraint_name] not nullConstraint constraint_name indicates the name specified for the

Oracle mobile tableOracle mobile tableWhen creating a table, you can specify a storage space for the table. If not specified, oracle will store the table to the default tablespace. You can move a table from one tablespace to another as needed.

Create a log file in oracle The syntax for creating a log file is as follows: Alter database database_name add logfile [group group_number](File_name [, file_name [,...]) [SIZE number] [reuse]; The syntax is described as follows; Group group_number

Oracle object typeOracle object typeObject Type In PL/SQL, object-oriented programmers are based on object types. The object type is a user-defined Composite data type. It encapsulates the data structure and processes and functions used to

[Lone sword] Oracle knowledge point sorting (1) Table space, users, and oracle knowledge pointsLink navigation for this series: [Lone sword] Oracle knowledge point sorting (1) Table space and users [Gu JIU Jian] Oracle knowledge point sorting (2)

[Dan JIU Jian] Oracle knowledge point sorting (7) database common objects: Cursor and oraclecursorLink navigation for this series: [Lone sword] Oracle knowledge point sorting (1) Table space and users [Gu JIU Jian] Oracle knowledge point sorting (2)

[Gu JIU Jian] Oracle knowledge point sorting (10) % type and % rowtype and common functions, % type % rowtypeLink navigation for this series: [Lone sword] Oracle knowledge point sorting (1) Table space and users [Gu JIU Jian] Oracle knowledge point