Oracle

[Root@chengdu yum.repos.d]# vim Local.repo [Cluster] name=cluster baseurl=file:/mnt/iso/cluster, enabled=1 gpgcheck=0 gpgkey=file:/mnt/iso/rpm-gpg-key-oracle [VT] name=vt baseurl=file:/mnt/iso/vt enabled=1 gpgcheck=0 gpgkey=file:/mnt/

Tom Great God wrote one for viewing Oracle database object space usage.The following shows how to use: – Tools Source CREATE OR REPLACE PROCEDURE show_space (p_segname in VARCHAR2, P_owner in Varc HAR2 default

http://blog.csdn.net/xiyang_1990/article/details/78771962 Here's a way to use the APPEND hint to make it possible to insert hundreds of billions of data in 10 minutes. --Create table CREATE TABLE Tmp_test_chas_lee ( F01 VARCHAR2 (20), F02 number

Original link: http://hi.baidu.com/lgnemo/blog/item/481c0266faff6622aa184cb5.html Oracle database is heavyweight, its management is very complex, Organize the startup and shutdown steps on the Linux platform. After you install Oracle, you need to

1, query the number of Oracle connectionsSelect COUNT (*) from v$session;2, query Oracle's concurrent connection numberSelect COUNT (*) from v$session where status= ' ACTIVE ';3. View the number of connections for different usersSelect

In Oracle, it is not difficult to get the year in the date, such as taking the year out of the sysdate. The common approach is to select To_number (sysdate, ' yyyy ') from dual, and in fact, Oracle has a better way of using the Extract function,

The first oracle that came across the job that distinguishes it from SQL Server is Oracle's left-right connection statement. This thing, or give a chestnut to describe the image of comparison. A user table users (user_id,address), Mobile number

1. Oracle Environment Deployment CentOS 6.6 Install Oracle 11GR2 2. Oracle Basic Knowledge How Oracle databases Create new users. How to view the user name and password in an Oracle database How to view all user names in an Oracle database

Transferred from: http://www.jb51.net/article/19541.htm An example of a cursor if,for Create or replace procedure peace_if Is Cursor Var_c is select * from grade; Begin For temp in Var_c loop If Temp.course_name = ' OS '

First, enter the service. Point Refresh to see if Oracle's Tnslistener service is open. Second, into the CMD run ipconfig look at your IP address, write it down. Then, with everything this small software search Listener.ora, search to this

First of all want to say, in fact very simple SELECT * FROM (SELECT * to teststudent ORDER BY id DESC) where rownum=1; Look at the SQL statement above Execute the parentheses inside the query out all the students, and in descending order, in

When a record is updated or deleted, it cannot be manipulated, or is locked, and sometimes, when we do update or delete on Oracle, there is no time to get the result of the operation, has been in the process of being processed, it is time to

Recently met a lot of people to sysdba how to land annoyed, I provide a simple way of landing-with root logging to the UNIX systembash-2.03$ su-oraclebash-2.03$ SqlplusSql*plus:release 9.2.0.1.0-production onðçæúëä3ôâ30 11:09:07 2006Copyright (c) 198

When you use SQL to query Oracle table data, there are two possible results requirements. Sort the query result set and get the line number before it is sorted After you sort the result set, add line numbers for each row For both of these result

1. Execute the following SQL command via Sqlplus Sql>colcomp_name format A10; Sql>selectcomp_name,status from Dba_registry where comp_name= ' Spatial '; If the result type is the following, the installation is successful (the status is valid or

Sometimes you have to go to the database and sometimes you can't even. It is possible that the current number of connections on the database has exceeded the maximum value that it can handle. Select COUNT (*) from v$process--current number of

Userenv in Oracle () Oracle Userenv functions, Sys_context Get session ID with Userenv, then connect v$transaction connection v$session, check current transaction number with session ID Select T.xid from V$transaction t join v$session s on t.addr =

1. Problem: My computer is not installed oracle10g server, installed oracle10g client, and then there is a free version of the Pl/sql, the use of Sqlplus, you can log on normally, do not appear the client and database character sets inconsistent

C:/>sqlplus/nologSql*plus:release 9.2.0.1.0-production on Wednesday January 19 14:46:21 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Sql> Connect chanet/chanet@oradb;is connected.Sql> CREATE TABLE Image_lob (t_id VARCHAR2 (5)

1, RowNum(1)more slowlySELECTYWLSDM, QYBM, SPZT, CZSJ, CZRYDM fromGH_HSWHEREYwlsdminch(SELECTYwlsdm fromGh_hsWHERESpzt= '2')More quicklySELECTYWLSDM, QYBM, SPZT, CZSJ, CZRYDM fromGH_HSWHEREYwlsdminch(SELECTYwlsdm fromGh_hsWHERESpzt= '2'