Oracle

Oracle Database PL/SQL package 6) package www.2cto.com 1. basic concept package (Package) is used to organize logical PL/SQL blocks or elements (variables, constants, custom data types, exceptions, processes, functions, and cursors, the package is

The Enterprisedb database is compatible with postgresql during installation. The oracle-compatible method is changed to postgresql-based enterprise-level database. 1 www.2cto.com create a user named enterprisedb2 on the OS to create a new dataset

Oracle notes: Tables and fields (2) 2. delete a FIELD in the TABLE: www.2cto.com delete a FIELD: alter table mtable drop column (FIELD) cascade constrains; OR: alter table mytable set unused (FIELD) cascade constrains; Delete multiple fields: alter

Sorting background of NUll values in Oracle sorting: processing of NULL values in Oracle sorting, which is a special value type in Oracle official documentation, by default, it is regarded as the maximum value during sorting. That is to say, when a

Database flash back related statement 1 \ roll back the table to a certain time point: enable the row movement function before the flash back operation of www.2cto.com SQL code alter table emp enable row movement; execute the flash back statement:

Overview of the composition of Oracle clusterware (I) the relationship between clusterware and RAC www.2cto.com in a narrow sense, RAC refers to a "Multi-instance, single database" Environment built with "some cluster components". Here the cluster

Oracle learning 2 (data type and Table query) oracle Data Type: www.2cto.com character type: the maximum char size is 2000 characters, and the space defined by char will be occupied no matter how much content, char queries are very efficient and

The Oracle drop table and delete table recovery operations share these experiences to help the same people who have made mistakes. The first problem is: drop table, remember to restore www.2cto.com without purge: flashback table tableName to before

Oracle order by sorting adds the sorting by pinyin, radicals, and strokes in oracle9i. Set the NLS_SORT value SCHINESE_RADICAL_M to sort SCHINESE_STROKE_M By the beginning (First Order), strokes (Second Order), and heads (Second Order) by the

Pay attention to the two ratio environments in the SQL Execution Plan: www.2cto.com [SQL] sys @ ORCL> select * from v $ version; BANNER -------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2

Recently, someone asked me this question about oracle BEQ processes. I used to see this introduction on a foreign recognition site. In sqlplus, enter conn/as sysdba, at this time, sqlplus starts a server process and uses the ps command to check that

In Oracle, The from subquery instance applies the Oracle table complex query ---------------------------------------------------- subquery example in the word query www.2cto.com from: how to display the employee information higher than the average

About calling the oracle stored procedure with the output parameter CURSOR 1. create Procedure with Out parameter of CURSOR type www.2cto.com Java code create or replace package pa_query as type p_cursor is ref cursor; end pa_query;/create or

Use the oracle system table to get rid of the inefficient graphical interface 1. The system table system parameters of the ORACLE database are stored in the database. You can use SQLPLUS to perform queries using the user SYSYTEM. Several important

Parallel query of Oracle Parallel query allows an SQL SELECT statement to be divided into several smaller queries. the query of each part runs concurrently and then the results of each part are combined, provide the final answer. Www.2cto.com let's

Oralce writes a paging stored procedure with a returned value stored procedure (list result set) Case: Write a procedure, enter the Department number, and return information of all employees of the Department. The analysis of this question is as

Oracle cluster url configuration plsql connection configuration in oracle cluster in plsql and java program connection mode not in cluster plsql connection configuration: www.2cto.com DB1_193 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =

Oracle reset initialization parameter SQL> select * from v $ version where rownum ! Uname-a Linux rac1 2.6.32-200.13.1.el5uek #1 SMP Wed Jul 27 21:02:33 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux www.2cto.com 1, resetSQL> select name, value,

Create or replace function PARSE_FEE_CHINESE (n_0000in NUMBER) 002 RETURN VARCHAR2 AS003 V_CHINESE_NUMBER VARCHAR2 (30): = 'zero errors '; www.2cto.com 004 V_CHINESE_POINT VARCHAR2 (30): = 'round-Robin trillions of RMB '; 005 V_RESULT VARCHAR2 (100):

SQL not in: in SQL queries, select * from t1 where c not in (select c2 from t2) If c2 in t2 has null, the result of this statement may be, only when the NULL value must be filtered out in the subquery can www.2cto.com select * from t1 where c not in