Oracle

I. Differences in data types between Oracle database and other databases1, Number: formerly int, Oracle:number: Unqualified, Numbers (3): 3-bit characters, 3 bytes.  Number (6,2): 4-bit integer, 2-bit decimal, 6-byte length. English numerals are one

Many friends in the development project not everyone with a database, but a separate host as a development database server, so that our developers need to connect it. The first is to enter Oracle's Net mananger;   The next step is to make a

(1The code for the lock table query is in the following form:Select Count(*) fromV$locked_object;Select * fromV$locked_object; (2) to see which table is lockedSelectB.owner,b.object_name, A.session_id,a.locked_mode fromV$locked_object A,dba_objects

1. Set the output lengthSegment_name---------------------------BYTES----------Tz01_login_data20971520Tz02_ep_gather131072Tz03_aaa65536Question: How to set the output format so that the first column is displayed: Segment_name, the second column shows

In general, it is not recommended to assign DBA authority after an Oracle normal user is created. So what permissions are generally assigned?First of all, an Oracle general user, our general requirements are:1. Be able to create the table structure,

PRIMARY KEY constraintSELECTUser_cons_columns. Constraint_name as constraint name,User_cons_columns. table_name as table name,User_cons_columns. column_name as column name,User_cons_columns. POSITION as LocationFromUser_constraintsJOIN

/*Divided into four steps*//*1th Step: Create a temporary table space*/CreateTemporaryTablespace user_temp Tempfile‘D:\oracle\oradata\Oracle9i\user_temp.dbf‘Size 50m AutoextendOnNext50m maxsize 20480m extent management local;/*2nd step: Create a

1 /*The default DB instance here is ORCL, creating a permanent tablespace for ORCL, zone custom allocation, and automatic management of segments*/2 CREATEtablespace ORCLTBS01 datafile3 'D:\app\darkdog\oradata\ORCL\ORCLTBS01_1.DBF'SIZE 50M;4 5

1. Copy the table structure and its data:CREATE TABLE Table_name_new as SELECT * from Table_name_old2. Copy only the table structure:CREATE TABLE Table_name_new as SELECT * from Table_name_old where 1=2;Or:CREATE TABLE table_name_new like Table_name_

Ten restart steps for Oracle Database This article describes in detail the ten restart steps for Oracle databases. 1. Stop various applications at the application layer. 2. Stop the listening process of oralce: $ Lsnrctl stop 3. Back up the control

Oracle multi-Table queryOracle multi-Table query: one-to-many data is placed in one field. Select id, zhzxm, fzhzxm, ltrim (max (sys_connect_by_path (xm, ','), ',') xmfrom (select id, zhzxm, fzhzxm, xm, row_number () over (partition by id order by

Only one entry is left for Oracle to delete duplicate dataSQL statement for querying and deleting duplicate records 1. Search for redundant duplicate records in the Table. duplicate records are based on a single field (Id) select * from table where

Oracle date insertionHow to insert data of the date and time type in Oracle:Create table t (mydate date );SQL> insert into t values (to_date ('2017-1-30 12:20:33 ', 'yyyy-MM-DD HH24: MI: ss '));SQL> select to_char (mydate, 'yyyy-MM-DD HH24: MI: ss')

Issue of CDB User Creation and tablespace allocation in Oracle12c Database   In Oracle12c, the concept of database plug-in is added, that is, PDB, which allows a database container (CDB) to carry multiple plug-ins. Database pulling (PDB ). CDB is

Introduction to oracle trunc Functions 1. TRUNC (for dates) The date value intercepted by the TRUNC function for the specified element. The syntax format is as follows: TRUNC (date [, fmt]) Where: Date: A date value. Fmt date format, which is

Introduction to OSFA and data warehouse in Oracle Oracle Financial Services Application (OFSA) technical platform: includes Oracle Warehouse Builder Data Warehouse building tool, Oracle8i Database, Oracle Express multi-dimensional database, Common

Batch import data to Oracle databases SQL * LOADER is large data Repository selection method, because it provides the fastest way (DIRECT, PARALLEL ). Now, let's leave aside its theory and use instances to make You can quickly learn how to use SQL *

Use OCCI to access the Oracle database (3) Now I am writing the code. I don't really want to write it. Let's compile it with an example. In the F: \ PProject \ oci \ 32 \ instantclient-sdk-nt-11.2.0.4.0 \ instantclient_11_2 \ sdk \ demo directory,

Use OCCI to access the Oracle database (2) I have introduced a rough idea in the previous article. Here I mainly introduce the specific methods: Step 1 download the three packages: Step 2: compress the package (overwrite some files to some

Use OCCI to access the Oracle database (1) Recently, I want to check the access to the ORACLE database. I searched the internet for it. It is said that in addition to ADO and OLE DB, OCI is a common method, but OCI is in C-Style, in C ++, there are