Oracle

Disclaimer: Although the title is Oracle, it is also suitable for MySQL InnoDB indexIn most cases, the composite index is better than the single-field indexMany systems rely on new and suitable composite indexes to increase the efficiency

Here is the description of the Oracle constraint in the OCP exam guide:The constraint types supported by the Oracle database is as follows:UNIQUENot NULLPRIMARY KEYFOREIGN KEYCHECKConstraints has names. It is good practice to specify the names with

These issues can be addressed in different ways in the Oracle database due to version differences.There are several ways to implement such a feature:1. Modify the Sqlnet.ora file to restrict access to the IP of the database.2, the use of trigger

Today the customer gave an Excel data, need and my local library data to do contrast, do not want to use the UE initialization, feel very troublesome, finally found a formula on the net slightly modified a bit to solve, memo as follows: Add a

Overview:The lock table is a very easy phenomenon, and it is easy to happen when more than one person is working on a table. Here are the steps to resolve the lock tableLock table Reason:Since the Oracle database maintains data consistency, when one

1. Get system time, current timeSelect sysdate from dual2. Date functionWhen using date calculations in SQL statements, you must use a Date function to convert the string to a date type, unlike using a string directly in SQL Server.to_date ("string",

Set the session format for date in Oracle to ' YYYY-MM-DD HH24:MI:SS 'Alter session set Nls_date_format= ' yyyy-mm-dd hh24:mi:ss ';Set the session format for timestamp in Oracle to ' YYYY-MM-DD hh24.mi.ss.ff 'Alter session set Nls_timestamp_format= '

1, the table's primary key, the foreign key must have the index;2, the data volume of more than 300 of the table should be indexed;3. Tables that are often connected to other tables should be indexed on the connection field;4. Fields that often

Someone in the group asked: how does table A (id,name) Table B (item_id,name,a_id) in Oracle now conform to a. Name=b. The ID of the a table of name is updated to a_id in table BI say this: Update B set a_id=a.id from a inner join B on

Qingli> Cat ql_mon.shNohup $ORACLE _home/bin/sqlplus-s ql_mon_$1.logDeclareInt_count number (10);N Number (10);N_tmp number (10);N_subsid number (18);N_region number (5);V_biztype VARCHAR2 (5);E_my_exception Exception;E_nobiztype_exception Exception;

Do not say nonsense, paste code:1 CREATE OR REPLACE FUNCTIONTo_time (secinch Number)RETURN VARCHAR2 is2 /*Turn the seconds into a time and minute format3 Auth Lzpong 201/09/164 */5 BEGIN6 RETURNTRUNC (NVL (sec,0)/3600)||':'||SUBSTR

If the data in the Oracle data table is not responding when it is being hacked, it is likely that the table is locked. Use the following command to resolve the locking problem.Lock table Status query. Copy and paste directly to it.--Lock Table Query

Write it here so that you can query after you forget the format later.CREATE OR REPLACE FUNCTION temp_func_wyl (pi_aaa100 VARCHAR2, pi_aaa102 VARCHAR2)-Dictionary conversion, convert code values to

1 Configuring operating system environment variables1.1 WindowsPath variable contains route informationCmd〉echo%path%Cmd> Set path=%oracle_home%\bin;%path%Registry value: "Oracle_home", "Oracle_sid" is set correctlyWhole Word Match Search value650)

How to find out which table the foreign key is built onSometimes when a table record is deleted, the foreign key constraint cannot be deleted.If you do not understand the relationships between tables, you can query to which table the foreign key is

You can include the actual character "%" or "_" in the pattern using the exception clause, which determines the escape character. If the escape character appears in the pattern in the character "%" or "_", Oracle will interpret the pattern on this

Situation Description: After the database restarts, with Plsql unable to connect on the prompt connection database ora-28547 Oracle NET management error, Baidu found that the situation and my situation is a bit different, here only to provide

Triggers are stored as separate objects in the database, unlike stored procedures and functions, where the stored procedure and function require the user to display the call to execute, and the trigger is run by an event to start. That is, a trigger

Oracle database to view the log is a lot of methods, we can be implemented according to SQL statements, or through the Log View tool Logminer to achieve, this article we mainly introduce this process, let us come together to understand it.one, the

Oracle to_number, to_char, to_date usage, to_numberto_date TO_DATE converts a string to a date type conversion function in the database.TO_CHAR converts a date or number to a string.TO_NUMBER converts a character to a numberTO_DATEUse the TO_DATE