Oracle

PL/SQL block to display detailed information of the employee with the given employee number 1 SQL> Declare 2 v_empno emp. empno % Type;/* declare the variable v_empno, % type: Make the Type of the variable the same as the empno type in the emp table

Method 1 for Oracle to view the table structure. The DESCRIBE command is used as follows: SQL> describe nchar_tst (nchar_tst is the table name): Is the name blank? Type -------- struct name nchar (6) ADDR NVARCHAR2 (16) sal number (9, 2) 2. Use the

The aggregate function in Oracle performs computation on a column in a group of rows and returns a single value. The aggregate function ignores NULL values. Aggregate functions are often used together with the group by clause of SELECT statements,

PMON, RECO, and ARCn PMON: processmonitor process Monitoring of oracle 10g processes performs data recovery when the user process is interrupted (abnormal. PMON is responsible for clearing the data buffer pool and releasing resources used by user

[Oracle] in Oracle, NULL-> null and in: null values are not included in the in result set. A105024 @ O02DMS1> select * from test; id name ---------- ------------------ 1 a B 3 C A105024 @ O02DMS1> select * from test where id in (1 ); id name --------

[Oracle] uses autonomous transactions to implement the audit function. In a transaction (outer transaction), one or several autonomous transactions can be defined. An autonomous transaction can be committed independently without affecting the outer

Oracle learning stored procedure (1) syntax stored procedure creation Syntax: create or replace procedure stored procedure name (param1 in type, param2 out type) as variable 1 type (value range ); variable 2 type (value range); Begin Select count (*)

Oracle Skip Locked [html] Oracle Skip Locked Oracle 11g introduces skip locked. Skip Locked is used to Skip the rows that have been Locked by other query select statements in the query select statement, and only execute the rows that can obtain the

When SQOOP interacts with ORACLE, the user name and table name must be of the same size. Otherwise, no results will be displayed. As follows: [hadoop @ htbbs bin] $. /sqoop list-tables -- connect "jdbc: oracle: thin: @ htbbs: 1521: htdb" -- username

ORACLE uses TNSNAMES. for UNIX platforms, ORACLE first looks for the environment variable TNS_ADMIN. If the environment variable exists, it goes to the directory specified by the environment variable to find tnsnames. ora file. Otherwise, go to the $

Oracle 11g cluster software cannot be started solution step (2) run the following command to view the cluster software status-bash-3.2 #. /crsctl check cluster-all ********************************** * t5220-1: CRS-4535: Cannot communicate with

The reason why a common user (users Group) cannot log on to oracle is a strange problem recently. In windows 2003, when the Administrator logs on to the system, if you use pl SQL dev to enter the account and password to log on to oracle, you can log

Oracle hexadecimal conversion rowid to 36 hexadecimal string FUNCTION FUN_ROWID_TO_36HEX (p_ID in VARCHAR2) return varchar2 is V_OBJECT_ID INTEGER; V_O_S VARCHAR2 (7); V_FILE_ID INTEGER; V_F_S VARCHAR2 (4 ); v_BLOCK_ID INTEGER; V_ B _S VARCHAR2 (6);

Primary Key constraints automatic index creation constraints are used to ensure the integrity of database data. In oracle databases, you can use constraints, triggers, and application code (processes, functions) to achieve data integrity, among the

How to compile invalid objects 1. Find INVALID objects: SELECT object_name, object_type FROM dba_objectsWHERE status = 'invalid'; 2. compile invalid objects: manually COMPILE: alter package pkg1 compile reuse settings; compile with PL/SQL Package:

An Issue of Oracle distributed uard Broker has been studying how to build Data Guard with a Broker. It has been a good job in the past. A strange problem was suddenly found in the past two days, the configuration process is correct, but the

Oracle performance optimization operation (1) select the most efficient table name sequence (only valid in the rule-based Optimizer ): the ORACLE parser processes the table names in the FROM clause in the order FROM right to left. The table written

There are many articles such as Oracle Data lock quick detection and removal on the Internet. I hope to quickly find all row-level locks in a table and remove them together. So I improved it: if you want to use the kill-9 sessionPid method, the view

Set up database links, Count table records, view sessions, and Max sessions. 1. SQL code select 'analyze table' | table_name | 'compute statistics; 'From user_tables where table_name like 'pr \ _ % 'escape '\' and tablespace_name = 'pr _ DATA1 '2.

V $ session permission: Use v _ $ session in the oracle trigger to discuss the problem that a problem occurs when the v $ session record type is referenced when a trigger is created under a non-system user: "tables and views do not exist", but in pl/