Oracle

See which users are connected 　　 Select S.osuser os_user_name, decode (sign (48-command), 1, to_char (command), ' Action Code # ' | | To_char (command)) action, P.program oracle_process, Status Session_status, S.terminal terminal,

ORACLE 11G when exported with export, empty tables cannot be exported. There is a new feature in 11G that does not allocate segment when there is no data in the table to save space Workaround: 1, insert a line, and then rollback will produce

Create or replace view V_wtk_all as Select a.ID, O.short as Finddeptname, u.realname as Findusername, f.name as Findway, O1.short as Problematdeptname, Z.name as Szzz, A.yhnr, s.name as Sszy, k.name as kind, w.name as WHHG, A.zgcs, A.ZGFZR,

We can use the following statement to view the path saved by the list of servers The code is as follows Copy Code Ls-l/ETC/YUM.REPOS.D If the return result is that the folder is empty, then the next

Nonsense not to say more, directly to everyone to paste the code, the specific code as follows: CREATE OR REPLACE FUNCTION f_get_param (In_param in VARCHAR2, In_flag in VARCHAR2) return VARCHAR2 is RES ULT VARCHAR2 (500); V_leng number;

Objective This article gives you a major introduction to the method of creating a self-growing table in Oracle, which uses a sequence. Here's a few words, let's look at the sample code. Sample code CREATE TABLE Tb_student ( ID number

Here's a way to implement Oracle, 2 steps: 1. Create SEQUENCE Create [OR REPLACE] SEQUENCE sequence_identity START with initial seed INCREMENT by step MAXVALUE Upper B Ound [Nomaxvalue] nocycle [empty] 2. Create TRIGGER Create [OR REPLACE] TRIGGER

C Shell Perl php date Time conversion: seconds and human readable date scalar localtime and seconds since ' 00:00:00 1970-01-01 UTC ' Scalar localtime 26-byte string with seconds since ' 00:00:00 1970-01-01 UTC ' (Number of seconds since January 1, 1

Install oracle12c under Linux Centos6.5 64bit: Groupadd oinstall groupadd dba mkdir-p/u01/oracle useradd-g oinstall-g dba-d Oracle (not Be sure to change the home directory to/u01/oracle, which is also available by default. ) Copy the

One of the most important things DBAs do in their daily work is to see how the table space is being used, to see if there is a full table space. The specific methods and steps are as follows: First step: Open Plsql Step Two: Create a new SQL

The Oracle tutorial you are looking at is: Oracle Application Experience (2). ------who is accessing the database? Select C.sid, C.serial#,c.username,a.object_id,b.object_name, C.program,c.status,d.name,c.osuser From V$locked_object A, All_objects B,

The Oracle tutorial you are looking at is: Oracle Database Security Policy Analysis (i). Database security issues have been the nightmare of database administrators, the loss of database data and the intrusion of databases by illegal users makes the

The Oracle tutorial you are looking at is: Oracle performance optimization. We have reason to believe that the new kernel version (2.2.16-3 SMP) should also have a performance boost: Os2:newer minor version kernel TPC Results Load time (Seconds) 9.4

Oracle Common link string format:Jdbc:oracle:thin:@//:/Jdbc:oracle:thin:@::Jdbc:oracle:thin:@How to query SIDs under Linux:In the case of configuring an Oracle environment variable, you can use the Echo $ORACLE _sid if you are not able to query

Administrator user logs into Oracle database1. Create a temporary table spaceSelect name from V$tempfile; Find out the current database temporary table space, mainly using the inside of the storage path;Get one of the records/OPT/ORACLE/ORADATA/ORCL/

First step: Create a self-growing sequenceCREATE SEQUENCE zh_alarm_info_seq--Auto-Grow columnINCREMENT by 1--add a few each timeStart with 1-counting starting from 1Nomaxvalue--Do not set the maximum valueNocycle--keep accumulating, not

First, install the Oracle databaseStep: Reprint a very good document: Http://www.linuxidc.com/Linux/2015-02/113222.htmNote: The installation will check dependencies, some may not find, MO Panic, rpm QA | grep package name, if already exist, install

SQL is the language used to access the ORACLE Database. PL/SQL expands and enhances SQL functions, and introduces stronger program logic.PL/SQL supports DML commands and SQL transaction control statements. DDL is not supported in PL/SQL, which means

Most Web applications today require at least some basic security policy. For example, websites that provide password-protected content, websites with only the backend of administrators, blogs and personal magazines, e-commerce websites, and

Anyone who has used Oracle knows that Oracle has a data type named VARCHAR2, which is used to indicate a string with an indefinite length. VARCHAR2 is also recommended by Oracle. However, VARCHAR2 has a problem: a maximum of 4000 characters can be