Oracle

--ifelseDECLAREV_num number;  BEGIN v_num: = 100; If V_num > then--elsif v_num > and then--ELSE--END IF; END; --with parameter stored procedure create OR REPLACE PROCEDURE delete_subscriber (p_subid in number) is V_mem VARCHAR2 (+): = ' ';

"One" configuration ODBCWin7: Control Panel (View by: small icon) → administrative tools → data source (ODBC)Under the ODBC Data Source Administrator panel, under Default User DNS, click the Add buttonSelect "Oracle in Oraclient11g_home1" ( provided

Recently do data analysis, need to use the cumulative function, found that the powerful Oracle really, with over (order by field)Example:The last column in the data table is the cumulative effectAccumulate sql:Select T.acc_pedal_pos,count (*)

First, the query encoding format:Select Userenv (' language ') from dual;Second, set the encoding format to UTF-8(1)--View the Oracle database character set first:Select Userenv (' language ') from dual;Query Result:Simplified Chinese_china. Al32utf8

I remember a colleague asked me this, said the interview before the problem encountered, the following I introduce three ways.First we create a test table here to add the appropriate test data.CREATE TABLE Test (ID number,name varchar (10));INSERT

This is a summary of the recent study of their own experienceI. Oracle's object-orientedSQL is a collection-oriented one that everyone knows, but there is no denying that there are many places in Oracle today that embody object-oriented thinking.

*The 1,java Web project can be deployed to Tomcat, or it can be mapped to a project's actual directory by configuring Server.xml, so there is no project under Tomcat's WebApps directory, the following is the configuration in Server.xmlContextPath= "/

1. Tools: Download Oracle Client Address:Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html such asSelect the corresponding version,Http://www.oracle.com/technetwork/topics/winsoft-085727.html find the corresponding

--Create a stored procedureCREATE OR REPLACE PROCEDURE xxxxxxxxxxx_p (--parameter in represents the input parameter, The--out represents an output parameter, and the type can use a legitimate type in any

One, a stored procedure with a cursor　　There are two types of cursors as arguments:　　1. Declaring the system cursor type Sys_refcursor1) The cursor acts as a parameter to the stored procedure:--A stored procedure with a cursor create OR REPLACE

Each table in Oracle has a ROWID, which is a 18-bit character string, for example: Aaangbaabaaao/kaaa. The string it contains consists of a-z,a-z,0-9,+,/of these characters. is 64 binary.Where A-Z corresponds to the 0-25,a-z corresponding to the 26-5

http://blog.csdn.net/lili72Background: For historical reasons, some of the company's business is still being used in Oracle . A problem is a lot of trouble. Due to the long-term use of MySQL and hive,Hbase , etc., some Oracle The order slowly is

Oracle object-oriented and set 1. oracle object-oriented We all know that SQL is set-oriented, but it is undeniable that there are many places in oracle that reflect the object-oriented thinking. (This is also a sign that major languages share the

Oracle lock 2: DML operations and locks Oracle automatically acquires row locks and table locks for DML operations. The operation type determines the lock action. The following section summarizes the DML operation locks: SQL Statement

Oracle string operations Select upper ('testmyname') from dual; -- convert to uppercase Select lower ('testmyname') from dual; -- convert to lowercase Select upper (substr ('testmyname'), 5) from dual; -- intercept myname and convert it to

Oracleinstr function usage and (oracle uses instr to replace like) Oracle instr function appeared in the recent project, so I found some information about it on the Internet. Usage of INSTR and SUBSTR in Oracle INSTR usage in Oracle:The format of

Oraclelike fuzzy query In some queries, you may not be sure about the exact value to be queried. For example, when Baidu searches, you can enter keywords to query the relevant results. Such queries are called fuzzy queries.Fuzzy search uses the

Postgres function, postgres date function 1. Data restoration is first considered to be performed in the database, but it is not feasible. External applications are considered to be repaired through jdbc. For example, profile_image_url and

Index (learning notes), index learning notes The tablespace can be omitted. B-Tree Index Reverse Key Index Function Index Bitmap Index Delete Index   B-Tree Index Example 1,Create a table and use the PL/SQL data generator to import 0.1 million

DBA training content notes and dba training content notes014-12-23slow hang lock: three common performance problems: hang. The whole database does not respond and new connections cannot be created. hanganalyze output. whether the dump file has