Oracle

Query table field details select column_name, data_type, data_length, DATA_PRECISION, DATA_SCALE from all_tab_columns where table_name = 'tablename' field comment select * from user_col_comments; Table comment select * from user_tab_comments; it

I. 1: ensure that the server can connect to its own database normally; 2: Open the server's Oracle configuration tool Net Manager, local-listening program, add address, host fill in the server IP address, enter any available ports. II. 1. Create a

Only-, 0-9, and ,. create or replace function IS_NUMBER (IN_DATA IN VARCHAR2, -- raw data I IN NUMBER, -- maximum integer bits allowed value J IN NUMBER -- maximum decimal places allowed value 0-cannot have decimal places, -1 do not verify the

select * from (select t. *, rownum rn from (select www.2cto.com col1, to_char (. testTime, 'yyyy-MM-DD HH24: MI: ss') as TestTime, from TestTable A where 1 = 1 lower (col1) like lower ('% col1 % ') TESTTIME between to_date (# testtime1 #,

Today we do not discuss the ORA-600 [kcratr_nab_less_than_odr] error, 11.2 ORA-600 issues are more interesting than the error itself is recording the KST trace for rolling upgrade (Rollback Recovery. Many netizens must ask what is KST? KST is the

Oracle splits strings into arrays and traverses the arrays to insert tables. 1. defines a custom TYPE, create or replace type ty_str_split is table of VARCHAR2 (4000 ); 2. Define a function create or replace function fn_split (p_str IN VARCHAR2,

Oracle External table to import big text data 1, first create the file storage path create or replace directory phone_dir as 'e: \ oracledir'; if it is not in the current user to create a directory, GRANT the permission: grant read, write on

1. execute the delete operation SQL> drop table t; Table dropped. SQL> select * from tab; tname tabtype clusterid ------------------------------- ---------- BIN $ tables = $0 tabletts synonymttss synonym SQL> purge table t; Table purged.

 This morning, a performance test was conducted on a platform of the company. When the database connection was used up, it was necessary to analyze the database access bottleneck problem. The OEM was successfully installed on the database server,

Similar to indexof in oracle, The _ instr function [SQL] does not have the indexof () function in oracle, but an instr () method is provided. Specific usage: select instr ('baoding nanchengqu ', 'city',)-1 from dual; Explanation: 1. 'baoding city

The reason why Oracle SQL Execution is slow and the solution is described in the following article is the reason why Oracle SQL Execution is slow. If the data of a table in Oracle Database is more than 0.2 billion, at the same time, this table also

The Uniqueness index of the Oracle database is represented in the unique index created in the database table test. The EO generated by the test table does not have specific rules corresponding to the unqiue index; when you create a unique key in the

Oracle (5) control statements all programming languages are inseparable from control statements, oracle also provides basic control statements for PL/SQL programming, conditional statements, cyclic statements, sequential control statements ----------

Undo series learning-common scripts for oracle DBAs in the process of maintaining oracle and commonly used scripts related to undo. Some of the previous articles also involve a lot of things. Here is a simple summary. 1) How to query the size of

The database encountered the problem of enq: TX-row lock contention. This morning, we made an awr report and the database encountered a lot of waiting events for enq: TX-row lock contention, it feels strange. Query the wait event in gv $ session

Using Oracle LogMiner to analyze archived log received an alert email today, resulting in a rapid growth of archived log. Unable to determine the cause of the problem. LogMiner is used to analyze the archived log. The main source and network of the

How to enable the Oracle Shared Server has unique advantages in some applications, as shown in the official description: reduce the number of instance processes, increase the number of external service users, reduce the number of useless or idle

We do not need to migrate data from ORACLE to MYSQL. Below I have written three simple MYSQL functions. For your reference. Is it time? [SQL] DELIMITER $ USE 'ytt' $ DROP FUNCTION IF exists' is _ date' $ CREATE DEFINER = 'root' @ 'localhost'

1. table Structure under scott: employee table EMPNo. name type description 1 EMPNONUMBER (4) employee No. 2ENAMEVARCHAR2 (10) employee name 3JOBVARCHAR2 (9) Position 4 www.2cto.com MGRNUMBER (4) lead no. 5HIREDATEDATE employment date 6 SALNUMBER (7,

Oracle Database reports a bug. the table or view does not exist. The table name contains spaces. 1. start: the fields in the SQL code exported through powderDesiger are in lower case, and then oracle.2.bug is imported directly: The table structure