Oracle

To view the name and size of a table space Copy Code code as follows: Sql>select T.tablespace_name, round (SUM (bytes/(1024*1024)), 0) ts_size From Dba_tablespaces T, dba_data_files d where t.tablespace_name = D.tablespace_name

Usage of Lpad in Oracle Pad translation: Filling Lpad function, add the specified string to the left of the string, using: Www.jb51.net Lpad (string, intercept length, added string). It is not accurate to add a string, but it is more accurate to

To generalize Oracle's basics, to sum up, Oracle is made up of instances and databases. The structure is as follows: An Oracle database consists of an instance, a database: * The database consists of data files (including Oracle data, index,

How do I return a table variable in Oracle's function? Too late, too much theoretical knowledge will not say, the following simply said to achieve it!.. 1, create the Table object type.To return a Table object in Oracle, you must customize a

1. Various procedures for application-level shutdown. 2. Stop Oralce Listening process: $lsnrctl stop 3. Under the exclusive system user, back up the control file: Sql>alter database backup controlfile to trace; 4. Under exclusive system users,

1. Stop the database using Sql*plus Copy Code code as follows: $ sqlplus/nolog Sql> Connect/as SYSDBA sql> shutdown [Immediate] Sql> exit 2. Stop Listener Copy Code code as follows: $ lsnrctl Stop

The original statement is this: Select SUM (sl0000) from XSTFXPS2 where Dhao00 in ( Select dhao00 from Xstfxps1 where Trunc (ywrq00) =trunc (sysdate) and khdm00= ' 500000003913 '); Time used: 00:02:49.04 　　 Execution Plan -------------------------

Software Environment: 1. Operating system: Windows Server 2. Database: Oracle 8i R2 (8.1.7) for NT Enterprise Edition 3, Installation path: c:oracle Implementation method: 1, D:>set Nls_lang=american_america. USACII7 Or D:>set

To make things simpler, I set up a unified checking database account on multiple Oracle data, and the account has access to only a few specific views (the SQL generated view that needs to be queried), as follows: Root>sqlplus/as SYSDBA Entering the

Write a batch file first, give an example. Copy Code code as follows: Set rq=%date:~0,10% Exp System/system password @ Local Service name file=d:\backup\bak%rq% Full=yes log=d:\backup\bak%rq% buffer=65536 C:\progra~1\winrar\rar.exe A-DF

The two very universal netizens more concerned about the question summary answer. The difference between in and exist From the perspective of SQL programming, in intuitive, exists not intuitive more than one select, In can be used for various

Copy Code code as follows: If you have multiple tables in the-->FROM clause, select the table with the least number of record bars as the underlying table --> parsing WHERE clause is a bottom-up filter condition must be in order

How do you get the maximum date for Oracle in your development application? This article will provide such a method of obtaining a friend that needs to be referenced under SQL code Copy Code code as follows: --Created on 2010/06/08 by NAN

If one of the data in the table is deleted in Oracle, it can also be rolled back by a rollback operation (rollback) If you want to clear a Table, but do not want to be able to rollback operations, you can immediately release resources, then need to

Serveroutput is a sqlplus configuration parameter, not a database configuration parameter, modifies and saves sqlplus configuration parameters, so you do not have to reset each time you open the Sqlplus. Set the method as follows: 1. sql> Set

Prompt when deleting users in Oracle: Oracle cannot delete current connection users can use the following statement SQL code Sql> Copy Code code as follows: Select username,sid,serial# from V$session; USERNAME SID serial# ---------------

Note the point: 1. If open in Pl/sql and other tools, directly modify the following code [Italic bold section] to perform 2. To ensure that the path exists, such as "D:\oracle\oradata\Oracle9i\" is the path you want to save the file exists /* is

1. Install the required patch pack for the oracle11g, install the CD-ROM on all, access to the CD's server directory: (preferably through Oracle's official documentation to determine which packages need to be installed) 2. Modify the user

Sometimes it is not clear that all allowable values for some parameters can be obtained from the following two methods 1. Directly input the wrong value, let the error to hint Copy Code code as follows: Sql> alter system set

Sql:charindex (' String ', field) >0 charindex (' Administrator ', Muserid) >0 Oracle:instr (field, ' String ', 1,1) >0 InStr (Muserid, ' Administrator ', 1,1) >0 In the project to use the Oracle INSTR this function, by the way carefully learn