Oracle

In the previous chapter has introduced a general, here is the main introduction of specific methods:The first step is to download three compressed packages, respectively:The second step, the compression package processing (some files are overwritten

Now start to write code, actually do not want to really write, or take an example to compile it.In the F:\PProject\oci\32\instantclient-sdk-nt-11.2.0.4.0\instantclient_11_2\sdk\demo directory, there are some CPP, I use Occidml.cppThe project is set

$ORACLE _sid decided to spfile DBSDefaultAt the start of the Oracle database times the error is as follows:[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 11.2.0.1.0 Production on Sat 16 19:43:43 2013Copyright (c) 1982, Oracle. All rights

Oracle database table How can I think of MySQL as an integer primary key with auto-add function?If you have to create a tableCREATE TABLE tab{ ID number not NULL PRIMARY key,--primary key.　　　　　　　　　　 .　. } 　　Then, you have to create a

one, inner and outer connections are used to return records that meet the conditions of the connection, and the outside connection is an extension of the inner join, which not only satisfies the record of the join condition, but also returns records

SequenceSELECT * from User_sequences select Last_number from user_sequences where sequence_name= ' t_jgxx_poly_seq '; alter sequence T_jgxx_poly_seq increment by 1; SELECT T_jgxx_poly_seq. Nextval from DUAL;MegerMerge into T_jgxx_poly jgusing T_jgxx_

--Use a subquery to find an indeterminate value--Sub-query and select statementSELECT e.emp_id, E.first_name, E.last_name, EP. Pay_rateFrom Employee_tbl E, Employee_pay_tbl EPWHERE e.emp_id = EP. emp_idand EP. Pay_rate (SELECT pay_rate from employee_

Delete Table duplicate data (T1 table with duplicate data)1. Using distinctCREATE TABLE t2 as select * from T1;CREATE TABLE Tmp_t2 as SELECT DISTINCT * from T2;drop table T2;alter table tmp_t2 Rename to T2 (need to stop business)---------------------

Turn from: http://www.cnblogs.com/252e/archive/2012/09/13/2682817.html Query and delete duplicate records of SQL statement  1, find redundant records in table, Duplicate records are based on a single field (ID) to determine  select * from table

SQL statement for querying and deleting duplicate records1, look for redundant records in the table, duplicate records are based on a single field (ID) to determineselect * FROM table where Id in (select ID from table group Byid have count (Id) > 1) 

Execute under SYS User:CREATE OR REPLACE TRIGGER lms2014Before create or DROP or ALTER on databaseDECLAREBEGINIF ora_dict_obj_owner = ' LMS2014 ' and ora_sysevent = ' DROP ' ThenRaise_application_error (-20002, ' do not allow deletion of objects,

First, IntroductionWhen we need to connect to a remote Oracle database server, we need to install the Oracle client on our own machine.Second, installation steps and ConfigurationReference: http://blog.csdn.net/luiseradl/article/details/7085222The

First, table partition　　(i) Classification of table partitions1. Range partition (range)2. Hash partition (hash)3. List partition4. Compound partition: Range-Hash (range-hash), Range-list (range-list)　　(b) Scope Zoning:A range partition is a

CREATE OR REPLACE PROCEDURE prc_query (p_tablenameinchVARCHAR2,--Table name P_strwhereinchVARCHAR2,--Query Condition P_ordercolumninchVARCHAR2,--sorted column P_orderstyleinchVARCHAR2,--Sort Method P_curpageinch outNumber,--Current Page

The Oracle Wm_concat (column) function allows us to use it frequently, and below teaches you how to use the Oracle Wm_concat (column) function to implement a field merge if you have an Oracle Wm_concat (column) If you are interested in the use of

1. Delete User table spaceOracle has been in use for a long time, adding many user and tablespace. Need to clean up.For a single user and tablespace, you can do this using the following command.Step One: Delete userDrop UserxxcascadeNote: Delete the

Transfer from http://blog.csdn.net/chen_zw/article/details/9292455Recently changed a 64bit computer, so the Oracle database has been replaced by 64bit, but the problem also arose, because Plsql developer temporarily no 64bit version, so can not

Return values of stored functions and functions.Directory I. return values of functions 1. Retrieve the system type data of the Function 2. Retrieve the custom data of the Function 3. Set of user-defined data of the Function Ii. return values of

ORA-01012: not logged on, ora-01012logged On the ORA-01012 of this error, Xi Feifei blog ORA-01012: not logged on which has made some introductions, the reason is not much said, look at his description:   Symptom description:   1) finally found the

Constraints in OracleConstraint type CONSTRAINT_TYPE in Table ALL_CONSTRAINTS:C (check constraint on a table) -- constraints, such as not null, checkP (primary key) -- primary keyU (unique key) -- unique key constraintR (referential integrity) --