Oracle

Http://www.cnblogs.com/jiguixin/archive/2011/09/09/2172672.html Download Address: Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_client.zip Unzip the downloaded zip file first and run the Setup.exe file. After the fourth

1. preparedstatement stmt =conn.preparestatement ("Select Pkg.fun" (?) from dual "); Stmt.setlong (1,123); Result rs = Stmt.executequery (); if (rs.next) {return rs.getdouble (1); } 2. callablestatement Stmt=conn.preparecall ("{=call

Paging Query format: SELECT * from ( select A.*, rownum RN to (SELECT * FROM table_name) A WHERE rownum = 21 The most inner query select * FROM table_name represents the original query statement without paging. RowNum = 21

Pseudo-column rownum in Oracle Pseudo-column rownum, just like columns in a table, but not stored in a table. Pseudo-Columns can only be queried and cannot be added to the deletion operation. It generates a serialized number for each piece of data

How to query the properties of a job from a database SELECT * FROMUSER_SCHEDULER_JOBS; or call the Get_attribute in the Dbms_scheduler package. --============================================================ The use of--dbms_scheduler --=============

A blob is a binary large object that is written by the English binary Large object, and Clob is written by the big character object, which is the English character Large object. Where a blob is used to store large amounts of binary data, CLOB is

Initialization parameters are divided into 3 classes: Derivation parameters operating system dependent parameter variable parameters Derivation parameter example: Sessions = (1.1 * processes) +5 Operating system dependent parameters: for example,

SELECT A.tablespace_name, FileNum, Total ' Total (MB) ', F.free "Free (MB)", To_char (ROUND (Free * 100/total, 2), ' 990.00 ') "free%", To_char (ROUND (total-free) * 100/total, 2), ' 990.00 ') "used%", ROUND (maxsizes, 2) "MAX (MB)" From (SELECT

--View the use of table space files SELECT MAX (b.file_id) ID, B.tablespace_name table Space, B.file_name Physical file name, b.bytes/1024/1024 size M, (B.bytes-sum (NVL (a.bytes, 0)))/1024/1024 has used M, SUBSTR (B.bytes-sum (NVL (a.bytes, 0))/

Article Source: http://www.yesky.com/399/1855399_2.shtml The CallableStatement object provides a way for all DBMS to invoke stored procedures in a standard form. Stored procedures are stored in the database. A call to a stored procedure is the

[SQL]   View plain  copy  print? /*   *locked   *query locked object and analyse reason,kill it    *   */      select  ' alter system kill session  "'  | |  sid | |   ', '  | |  serial# | |   ';      from  (select distinct a.sid,                    

Oracle architecture is built around this diagram, and to get an insight into Oracle, you have to figure it out. As shown in figure: First, the basic composition: Oracle Server: Typically a instance and a database 1 instance can only correspond to

MDSYS.CS_SRS-----The table defines the name of the coordinate system and its ID values in Oracle spatial, which are all published by Open-gis. The currently defined coordinate system has reached 1018. Mdsys. Sdo_angle_units-----This table defines

Article from: Also can not find the source address where, in short, thank the author of the sharing two important processes that are most overlooked in Oracle There are two processes in the Oracle database that are very small, but they are very

(recommended) Method one: Select Dbf.tablespace_name, Dbf.totalspace "Total (M)", Dbf.totalblocks as total block number, Dfs.freespace "Total surplus (M)", Dfs.freeblocks "Number of remaining blocks", (dfs.freespace/dbf.totalspace) * 100 "free

Remote Import Backup command: Imp cpqlzf/cpqlzf@cpql20080505 file=d:\data\20080505xzfw_new.dmp fromuser=sa touser=cpqlzf ignore=y notes: The CPQLZF is the table space name and the login password; cpql20080505 is the database SID name, the backup

T.money is the left column of the following figure To_char (Round (T.money, 2), ' 0.00 ') is the right column of the following figure To take it apart, round (t.money,2) means rounding the T.money "two digits after the decimal point".

Create a sequence first CreateSequence testincrease_sequence IncrementBy 1--each time you add a few startwith 1--start counting from 1 nomaxvalue--do not set the maximum value, To set the maximum value: maxvalue9999 nocycle--has been accumulated,

1. What's the difference between after and before in a trigger in Oracle?One is triggered before the record operation, and one is triggered after the record operation. 2. What occasions are used separatelyFor example, the definition between the

Crontab timed execution of Oracle stored proceduresRequirements DescriptionWe have an Oracle stored procedure that needs to be executed every month, generate a report, and then send it to the business unit, which we have implemented in the system's