Oracle

Today, I suddenly found that the TNSListener service could not be started. After I started it in the service console, I refreshed it and automatically returned to the stopped status. No error was reported. In addition, SPL PLus can be used normally.

Recently, many new Oracle beginners or those who upgraded from the old version of Oracle to 10 Gb asked questions about how to manually create a database in Oracle 10 Gb. Today, we are free to write down the whole process of manual database creation

Oci_bind_by_name (resource stmt, string ph_name, mixed & variable [, int maxlength [, int type]) The first thing to note about this function is the maxlength parameter. You need to take a closer look at the descriptions in the manual:The length

In fact, in addition to the commonly used asmcmd command to manage the asm disk group, you can also manage it through ftp. By default, the ftp port is disabled. The specific operation steps are as follows: Db1-> sqlplus/as sysdbaSQL> @?

Since the oracle service is set to manual, you need to start the service each time you use it.Today, the connection failed after the startup,(1) command line sqlplus, connection failure prompt:ERROR:A ORA-01034: ORACLE not availableORA-27101: shared

801. ALL_DIM_HIERARCHIESDisplays the dimension levels. 802. ALL_DIM_JOIN_KEYDescribes the connection between two dimensions. 803. ALL_DIM_LEVEL_KEYDescribes dimension columns. 804. ALL_DIM_LEVELSDescription dimension level. 805.

The following article describes how to use SQL * Loader to export Excel-related data to the Oracle database. The main purpose is to insert the actual application data in excel-related files into the Oracle database, the following describes the

Create table testabc (A Number,B Date); Insert into testabc (a, B) values (1, TO_DATE (1-MAY-2010/, DD-MON-YYYY/HH24: MI ));Insert into testabc (a, B) values (1, TO_DATE (2-MAY-2010/, DD-MON-YYYY/HH24: MI ));Insert into testabc (a, B) values (1,

Exception in thread "main" java. lang. InternalError: Can't connect to X11 window server using '192. 168.3.10: 100' as the value of the DISPLAY variable.At sun. awt. X11GraphicsEnvironment. initDisplay (Native Method)At sun. awt.

I. Data Control Statement (DML) 1. INSERT (INSERT the record statement into the data table) 　　 Insert into Table Name (field name 1, field name 2 ,......) VALUES (value 1, value 2 ,......); Insert into Table Name (field name 1, field name 2 ,......)

Oracle POLICY learning 01 -- 1. create test table 02 create table TEST_POLICY03 (04 USERNAME VARCHAR2 (10), 05 password number (10) 06); 07 insert into t_policy values ('A', 30 ); 08 insert into t_policy values ('B', 20); 09 insert into t_policy

In Linux, sqlplus cannot use the up or down key. The first step is to install the readline package on the installation disc of readline centos. Find and install all packages starting with readline. [Root @ oracle11g ~] # Rpm-ivh readline *  Step 2:

Summary of ORACLE Procedure Stored Procedure syntax subroutines and packages: subroutines are named PL/SQL blocks that can contain parameters and can be called at any time as needed. PL/SQL has two types of subprograms: process and function. A

Use PL/SQL to execute OS commands [SQL] create or replace and compile java source named ExeSysCommand as import java. io. *; public class ExeSysCommand {public static String ExeCmd (String args) {Runtime run = Runtime. getRuntime (); Process process

An interesting test SQL> show recyclebinrows will be truncatedORIGNAME_PLUS_SHOW_RECYC OBJECTNAME_PLUS_SHOW_RECYC OBJTYPE_PLUS_S-------------------------------- ------------------------------ --------------EMP_1

Configure table space, create users, and import Databases --- Cmd go to the dos interface sqlplus/as sysdba ---- create table space --- create tablespace ciqpspace DATAFILE 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ CIQP when creating the

Oracle foreign key table search SQL code Select B. table_name primary key table name, B. column_name primary key column name,. table_name foreign key table name,. column_name foreign key column name From (Select. constraint_name, B. table_name, B.

Subpartition template I have never known about the subpartition template. I tried it today. It is quite fun and useful. You do not need to fill in subpartitions when adding partitions during maintenance. The following is an example: Create table

Oracle Database Programming: You can use a cursor in PL/SQL to obtain data using a cursor in PL/SQL. A cursor can be divided into an implicit cursor and a display cursor. A cursor is directly associated with a database equivalent to a global

Step 1. step 1. shut down the database normally. 2. place the database in the mount status. 3. change the database to archivelog mode. 4. open the database 5. close the database normally and make a full backup sQL> conn / as sysdbaConnected to an