Oracle

OTL use method 1 source http://otl.sourceforge.net/http://otl.sourceforge.net/otlv4_h.zip () 2 install 2.1 Windows XP, vc6.0, oracle8.1.61) unzip the downloaded installation package to C: /program files/Microsoft Visual Studio/vc98/otlv4_h/otlv4.h. 2

  If you want to query all the tables in the database, you can querySelect * From dba_tables If you want to query the tables of a user in the database, you can also log on to the user and then query:Select * From user_tables   To import External

The sdo_geom.sdo_buffer function is used for buffer query. It has three parameters: Param1: the geometric element to be queried. Param2: the geometric elements used for filtering. Param3: used to control the buffer radius value, buffer arc

Run the DBV command to check whether the data file contains bad blocks before recovery.DBV file = D: \ oracle \ oradata \ mydb \ ronly. DBF blocksize = 8192You can view the data file number and block number of the bad data block to perform a full

The following problems occur during installation:Checking Network Configuration Requirements...Check complete. The overall result of this check is: not executedProposal: Oracle supports installation on a system with a public IP Address Assigned by

Depressed, extremely depressed, yesterday installed oracle11g, and then installed PlSql8, open any project page to report the following error, it is inexplicable, This is the C drive machine. config. How can this problem be solved! My system is win7

Some problems occurred when using ORACLE in the actual project. The problem is avoided through the work und. I wrote this article to make it easy to use! 1. ORA-01403: no data found-NO DATA FOUND A. Add an exception to handle the exception. Code

Oracle 9i Server Oracle 9i includes processes, memory structures, files, and other componentsThe Oracle 9i server is composed of an Oracle instance and an Oracle database.An Oracle instance is composed of background processes and memory structures.

Unmount Oracle 9i under XP Keywords: oracle Environment: Windows XP + oracle 9i 1. Stop all Oracle services: Choose Control Panel> Management Tools> services> stop all oracle services.2. Uninstall the program: select the oracle Universal

Oracle Spatial has a function that converts geometry to GML. The function name is sdo_util.to_gmlgeometry (GEO ). This GEO is SDO. geometry type, but the return value of this function is clob type geometry. Of course, we can use the to_char function

When executing a stored procedure that returns a ref cursor parameter, the Microsoft Oracle provider requires that the ref cursor be bound as an OracleParameter object of type OracleDbType. Cursor. The DataDirect provider for Oracle does not require

1. delete a tablespace Drop tablespace TableSpaceName [including contents [and datafiles]2. delete a user Drop user User_Name CASCADE3. Notes for deleting a table When deleting all data in a TABLE, the truncate table name must be used. Because when

Preface Aside from a few questions, I am a little satisfied with all the series of blog posts. For my own monograph, I will post an Oracle blog every day, and other blog posts will be posted in my spare time. Click Database Configuration

Make sure that the directory where the installation file is located does not contain Chinese characters, otherwise there will be various problems! Since it is a learning and testing environment, these two items are free. Next, ignore. Of course, we

Artifact SQL Plus SQL puls is an artifact. Apart from its powerful functions, SQL plus is available in severe cases. When SQL plus is unavailable, the system is finished. Let's recall how many accounts are available in our system? Sytem/Sys. use

I. analysis function overOracle provides analysis functions starting from 8.1.6. The analysis function is used to calculate a group-based aggregate value. Different from the aggregate function, it returns multiple rows for each group, the aggregate

Error: ORA-26041: DATETIME/interval data type conversion error. When a problem occurs, you are running a non-English language environment and loading an Oracle that contains a DATE or DATETIME data type in batches. To avoid this problem, set the

UsingSystem; UsingSystem. Data; UsingSystem. Text; UsingSystem. Windows. Forms; UsingMicrosoft. Office. Interop. Excel; UsingSystem. Data. OleDb; // Reference-com-microsoft excel objects 11.0. NamespaceWindowsApplication5 {

SQL generation Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> -- 1. Create a table in tablesCreate table tb_users(Id number (4 ),UserName varchar2 (20 ),Password varchar2 (20))-- 2. Sequence

Calling a stored procedure through a JOB in oracle DB: Create or replace procedure addage Is Begin Insert into test_work_age (work_age_id, work_age_code, work_age_name, created_date) Values (114, '20140901 ',''); End addage; ------------------