Oracle

ORACLE10G is a server, if the machine installed oracle10g, there is no need to install Oracle client, as long as the DNSis configured, you can use Plsql devement connection Of course you can also install oracle10g and Oracle client at the same time

System in the Fund company table (Fundcompany)CREATE TABLE FC (CompanyID varchar2 () primary key,Name VARCHAR2 (+) is not NULL,Content Clob NOT NULL,Money Number (10,2),State number (1,0) check (state=0 or state=1));Fund table in the system

--Non-null constraintALTER TABLE Studen MODIFY (studentname not NULL);--Unique constraint (Social Security number)ALTER TABLE student ADD CONSTRAINT uk_student_identitycard UNIQUE (Identitycard);--Default constraint (address)ALTER TABLE Student

One: Via System.Data.OracleClient (need to install Oracle client and configure Tnsnames.ora)1. Add a namespace System.Data.OracleClient reference2. Using System.Data.OracleClient;3.String connstring = "User Id=ifsapp; Password=ifsapp;data

Purpose: Cloning an Oracle Home, can eliminate multiple machines to repeatedly install Oracle software1. Stop related processes[Email protected] bin]#./crsctl Stop Cluster-all2. Packing Dbhome_1 Catalogue[Email protected] 11.2.0]#

Hugepages uses large-page memory instead of traditional 4KB memory pages, resulting in fewer management virtual addresses, faster mapping from virtual addresses to physical addresses, and improved overall memory performance by discarding swap-in for

I. Operations on the tablespace 1, creating tablespace (Create Tablespace)--' hpdb_tablespace ' specifies tablespace name--' e:\hpdb.dbf ' specifies tablespace data file name--Size Specifies the initialization size of the tablespace--Autoextend on

Overview of common related viewsDba_sys_privs: Querying system permissions owned by a userUser_sys_privs: system permissions owned by the current userSession_privs: All permissions owned by the current userRole_sys_privs: system permissions owned by

2.Oracle self-provided method: using Oracle.DataAccess.Client;Prerequisites: Install Oracle or Oracle client and install Oracle client.·· 1. Create a new console application in VS2010 (C #);·· 2. Right-click, reference, select

Beginner Oracle, a lot of statements can't remember, write here memo.1. View data files for a table spaceSelect file_namefile name, Tablespace_name table space name, bytes/1024x768/1024x768size m,maxbytes already used/1024x768/1024x768/1024x768Total

1 Oracle Data Types2 Character Type3 Char[(Size[byte|char])]: Maximum 2000 bytes, default 1 bytes4 varchar2(Size[Byte|char]): Maximum 4000 bytes5 nchar[(size)]: Multi-byte encoding (Unicode) Maximum of 2000 bytes6 nvarchar2 (size): Maximum is 4000

Transferred from: http://www.hellodb.net/2009/12/hash_partition.htmlIn the interview often ask a question, please list the hash in the database internal application, the principle of hash is simple, but it can be said in the database is everywhere.

Format: add_months (Date,number) that is add_months (date, number)The Add_months function returns a new date by adding a specified number of months to the input date. If a negative number is given, the date of the month before the duty period is

After successfully installing the Oracle 11g database, you will find that your computer is running slower, that your computer is running faster with a lower-profile PC or even a very card-enabled Oracle service. So, how do you do it

Oracle NET1. The client obtains the specific connection information of the server through the @ora10g name to the Tnsname.ora file.2. The client sends a link request to the server via the description in the Tnsname.ora server side3. After the server'

Restore 0.92 database to 1.92, restore time July 131. Query the required control log7-2-7-4 -r-b-L "CNT "(2nd, 3 steps can be parallel)2. Start restoring the control fileAccess to Rman, database up to nomount use Backup files to control file

Below is Oracle's master quote: Oracle Database developers should follow is to do everything they can in SQL. What they cannot does in SQL, they should does in PL +. And what they cannot does in PL/SQL, they should do in whatever language

A tablespace is a logical division of a database, and a table space can only belong to one database.All database objects are stored in the specified table space. But the main storage is the table, so called table space. There is at least one table

One, database backup1. Enter the databaseSqlplus system/Passwordsqlplus username/[email protected] assysdba2. Create directory D:\temp\dmp (DPDATA1 database name)Create directory dpdata1 as ' d:\temp\dmp ';(Delete directories drop directory dpdata1;)

Basic query statements SELECT [DISTINCT] column_name1,... | * FROM table_name [WHERE conditions] formatting in sql*plus change display field name: COLUMN column_name HEADING new_name    (note that