Oracle

in the process of using Oracle, there are all sorts of problems, all sorts of bugs, and ORA-12899 is the problem I've been having when I imported data into my local machine. But fortunately has solved this problem, now share, the solution; appears

create Table Manager ( userid number , username VARCHAR2 () not NULL, password VARCHAR2 () not null ); create sequence seq_manager;INSERT INTO Manager (userid, username, password) VALUES (Seq_manager.

Common functions: Substr and InStr 1.SUBSTR (string,start_position,[length]) to substring, return string Explanation: String Meta string Start_position starting position (starting from 0) Length optional, number of substrings For example:substr

28.2.4 Install Oracle 11g Oracle 11g provides a graphical installation interface that allows users to complete the installation process by moving and clicking the mouse. The specific installation steps are shown below.(1) Extract the Oracle 11g

The traditional fetch into only one data at a time, using the fetch bulk collect into can get all the data from the cursor at once, use the limit clause to limit the number of data bars taken at a time 1, fetch bulk collect into Begin Declare

Original post address: http://blog.csdn.net/nsj820/article/details/5755685 Oracle9i introduces the merge command, which enables you to perform both inserts and updates operations on a table in one SQL statement. The merge command selects rows from

Reference Source: http://download.csdn.net/detail/guoquanyou/3614666 Add table Student to Oracle database CREATE TABLE Student (STUDENT_ID Number (6) is not NULL PRIMARY KEY,Student_name VARCHAR2 (Ten) is not NULL,Student_age Number (2) Not

--Lists the number of employees and departmental numbers for which wages are higher than the average wage in each department, and the select * from EMP E1 by department number, (select round avg (SAL), 2) Sal,deptno from EMP Group by Deptno) E2

1, Add the field Alter table Student Add age number (5);  2, modify the field ALTER TABLE student Modify age number (10);  ALTER TABLE table2 Rename column result to RESULT2;  3. Delete field Alter table student Drop column age;   4, empty the table

There is a lack of packet detection during Oracle installation and the following practices are detected: Os:linux Redhat 6.6 64-bit LIBAIO-0.3.105: OS with libaio-0.3.107-10.el6.x86_64.rpm: RPM-IVH libaio-0.3.107-10.el6.x86_64.rpm OS with libaio-

Oracle Generation Random Number: Select To_char (sysdate, ' YYYYMMDD ') | | Lpad (Round (Dbms_random.value (1,999999999)), 9,0) from dual; To_char (sysdate, ' YYYYMMDD ') is a date, that is, the date of the current day, || is the

/* CursorsPurpose: To process a SELECT statement to return multiple rows of data Use steps:1. Define CursorsCURSOR cursor_name is select_statement2. Open cursorOPEN cursor_name3. Extract DataFetch cursor_name into variable1,...--Fetch one row of

Ora-01033:oracle initialization or shutdown in progress is usually caused by corruption of the ORACLE database file, following are the problems and resolutions that occur: Symptom One : sysdba can log in, but in use, the database is not open, only

How do I see the current number of connections to Oracle? Just use the following SQL statement to query. SELECT * FROM v$session where username Is isn't null Select Username,count (username) from V$session where username is isn't null GROUP by

1. First create a table lengzijiantest with only one field in the table f_id CREATE TABLE lengzijiantest ( f_id number not NULL ) 2. Insert a piece of data INSERT into lengzijiantest values (1) 3. Now

I haven't seen much of Oracle's technical documentation for a long time, and today I read an Oracle Response time optimization and method R. This is the classic book of Optimizing Oracle Performance Classics. The main idea. R represents response

B-tree Index A B-Tree index has only one root node, which is actually the topmost branch node in the tree. You can use the following figure to describe the structure of the B-tree index. where b represents the branch node, and L represents the leaf

1. Create test table and serial number [SQL] view plain copy print? CREATE TABLE Job_test (ID integer,add_time date); SQL] View Plaincopyprint? Create sequence seq_tm_idMinValue 1MaxValue 99999Start with 61Increment by 1Cache 20; 2, the creation

@echo Start Backup .... @echo This program uses ZIP compression, after the backup of the file can be used RAR or zip decompression. Set INSTANSE=ORCL Set Username=user Set Password=password Set Extname=rar Set year=%date:~0,4% Set

When you use GROUP by Cratetime, but one day there is no data, there will be no data one day. So using the following SQL, you can count out every day. Select To_date (' 2015-06-01 ', ' yyyy-mm-dd ') +level-1 as time