Oracle

1. Check whether it is an archive modeSQL>log list; Database Log Mode No Archive modeautomatic Archival disabledarchive destination log sequence Current log sequence 2. Close the databaseSQL>log list;

If...then...elsif implementation of multi-branch judgment statementsIts syntax is as follows:If ThenPlsql_sentence_1;Elseif Thenplsql_sentence_2;...ElsePlsql_sentence_n;End If;There is no condition behind the last else, which is more

When Oracle changes the machine name, it causes the service to not start properly and can be resolved by the following actions: Listener in the Listener.ora file in the 1.oracle\product\10.2.0\db_3\network\admin directory Instead of your new machine

1 , build a test table [C-sharp]view plaincopyprint? CREATE TABLE Edw_int ( Agmt_no VARCHAR2 (+ BYTE) not NULL, Agmt_sub_no VARCHAR2 (4 BYTE) not NULL, Need_repay_int number (22,2), Curr_period Number (4) Not NULL ); CREATE TABLE

has been using Oracle, recently studied the next MySQL, first listed MySQL strange features1. The time of millisecond accuracy cannot be stored.2. If there is a varchar, char will automatically become Varhar.3. Timestamp time range is smaller than

From:http://www.cnblogs.com/yjmyzz/archive/2013/11/01/3400999.html"Odp.net Managed" has been released for some time, recently there is a new project, want to try to use, refer to the Garden article: ". NET Oracle Developer Gospel--odp.net Managed

1. Start the CDB and PDB databasesSql> select Con_id,dbid,name,open_mode from V$pdbs;con_id DBID NAME Open_mode---------- ---------- ------------------------------ ----------2 1226396669 pdb$seed READ only3 411454583 DB12CCD MountedSql> Alter

Oracle Stored procedures:CREATE OR REPLACE PROCEDURE getcity ( citycode in VARCHAR2, ref_cursor out sys_refcursor/ * This sys_refcursor type is in the Sys.standard package */) Asbegin OPEN ref_cursor for SELECT * from tb_city_

CREATE OR REPLACE FUNCTION number_to_bit (v_num Number) RETURN VARCHAR is V_rtnVARCHAR(8);--Note return column lengthV_n1 Number; V_n2 Number;BEGINv_n1:=V_num; LOOP v_n2:=MOD (V_N1,2); V_N1:= ABS(TRUNC (v_n1/ 2)); V_RTN:=To_char (V_N2)||V_rtn;

MVC makes simple business more complicated.I do not know if you are using the MVC pattern to develop the project when you feel very troublesome, a simple delete and change the action is involved in a number of file operations.Take a data increase as

trunc (D1[,C1]) returns the date D1 the first day of the period (parameter C1)D1 Date Type, C1 is character (parameter), C1 default is J (i.e. current date)C1 the corresponding parameter table:This week Sunday: day or Dy or D (Weekly order: Days,

Oracle table partitioning is divided into four types: range partition, hash partition, list partition, and composite partition.One: Range partitioningis to partition partitions based on the range of values of a field in a database table, for example:

There are four main functions in Oracle that support regular expressions:1,regexp_like: Similar to the function of like2,REGEXP_INSTR: Similar to the function of INSTR3,REGEXP_SUBSTR: Similar to the function of SUBSTR4,regexp_replace: Similar to the

Oracle has a high-speed buffering concept, which is to store executed SQL statements, which Oracle does a lot of work when executing SQL statements, such as parsing SQL statements, estimating index utilization, binding variables, reading blocks, and

Oracle data types correspond to. NET 2011-02-24 10:02:16Tags: C # oracletype Oracle data type. NETOracle connections Add a different reference, there will be different data types and some other differences, the work encountered in the temporary

When using an Oracle database, you often encounter an operation that requires that all objects of a user be re-imported. Here are two commonly used methods to facilitate the use of people.First, useDropUserCascade;  can delete the user and all

1, the default processing Oracle in order by default is considered null is the maximum value, so if it is ASC ascending is the last, desc descending is ranked in the top2. Use the NVL function Nvl function to convert an input parameter to a specific

Oracle SQL BASICS (3)-index/trigger/view operations1. index. create index idx_name on fdh_client_info (name); -- create unique index uni_idx_id on fdh_client (id); -- create index union_idx_name_addr on fdh_client (name, address); -- Union index B.

Difference between EDB and Oracle in partition pruning practices A problem occurred two days ago. To create a partition table in the EDB database, you need to use the partition Local index and partition pruning. However, you cannot use the partition

Oracle External table1. Introduction to external tables External tables are used after Oracle9i. An External table is a type of table that is defined in the database and data does not exist in the database. You can select, join, or sort External