Oracle

Note: The following procedures are tested through the delphi7+oracle9i1, first use Delphi to prepare a DLL program, of course, with VB,VC other languages can also,I recently used Delphi, so the following DLLs using Delphi programming:PROJECT1.DPR

This article is reproduced from: IOException in sending Request::connection refused:connect IO exception: The network Adapter could not establish the connection Unable to contact the agent. Please verify that the URL for this agent is null. --------

CREATE OR REPLACE FUNCTION fn_get_status_str (p_str in VARCHAR2)Return VARCHAR2 asLstr VARCHAR2 (1000) DEFAULT P_str | | ',';Retstr VARCHAR2 (1000) DEFAULT NULL;Tmpstr VARCHAR2 (m) DEFAULT NULL;LREC number;LNO number;LID number;BEGINLOOPLNO: = INSTR

First, Profile functionProfile in Oracle systems is used to limit the database resources that users can use.Second, profile parameters detailed(1) View database resource constraint parametersSql> select * from Dba_profiles; Profile Resource_name

1. System Rights Management1.1 3 Default UsersOracle 9iSYS Change_on_install [as Sysdba]--sqlplus/as sysdbaSystem ManagerScott TrigerOracle 10g aboveSYS Setup when it is installed. [As SYSDBA]Setup when system is installed.Scott Triger is locked by

At the stage of the development project, when the database table for the project has been designed, the next step is to develop it. But there are a lot of tables in a project, and the first step in development is to create the entity classes for the

The steps of the Oracle spatial table learning process are the main things to be covered in this article, as follows: Step1. Create a table where shape is used to store space data CREATE TABLE Mylake (feature_id number PRIMARY KEY, name VARCHAR2 (),

If the business can not stop, there are mainly three kinds of ideas:=======================================================================================================idea 1: According to ROWID fragmentation, reuse rowid sorting, batch

Oracle Table-Building, primary key, foreign key basic syntax -Create TABLE syntax:CREATE TABLE Table name (Field name 1 field type (length) is empty,Field Name 2 field type is NULL); -Add primary keyALTER TABLE name add constraint primary Key name

http://skzr-org.javaeye.com/blog/811491 Goal: Timed export: Use Scheduled tasks to automatically compress: using the command line RAR automatic monthly storage: using cmd Code:   CMD code @echo   must go to the specified path, otherwise it will

Alter any cluster modify the permissions of any cluster Alter any index to modify permissions on arbitrary indexes Alter any roles modify permissions for any role Alter ANY SEQUENCE permission to modify any sequence Alter any snapshot permissions to

Oracle_sid parameter, this parameter is used in the operating system, it is a description of the database we want the default connection instance, for a machine with more than one instance of the case, to be modified before the Conn/as SYSDBA

1, process definition (package, cursor, process) ------------The top return is a record, but returns more than one record to use the following-------------------- --1: The process of returning a result set, in which the Test_cursor cursor is defined

Oracle dblinke+ materialized view the new requirement of synchronizing data items for two databases is to synchronize parts of the two Oracle databases, and now try several methods in the experimental environment, and then record the Dblink and

Oracle Log View one. Path to Oracle log: Login: Sqlplus "/as sysdba" View path:sql> select * from V$logfile; Sql> select * from V$logfile; (#日志文件路径) two. What does the Oracle log file contain: (the number of logs may be slightly different) Control01

-- INSTR (source string, the string to find, starting with the first few characters, to find the ordinal number of matches) if it is not found, return 0. A bit like the Get array subscript Select INSTR in Java (' Ni ... HA,.OWCAO,NIA,.M,

--create Sales TableCREATE TABLE Sales(trans_date date, cust_id INT, sales_amount number); --insert Sale rowsINSERT/*+ APPEND * *Into SALESSELECT TRUNC (Sysdate, ' year ') + MOD (rownum, 366) trans_date,MOD (RowNum, cust_id),ABS (Dbms_random.

Job The parameters: One: time interval execution (every minute, every day, weekly,: Monthly, Quarterly, half-yearly, yearly) interval refers to the interval between the last execution end and the next start, and when the interval is set to NULL,

Http://hi.baidu.com/cuigq_hr/blog/item/ba2bc167ed79022eaa184c34.html 1. A summary of the dates after the Sysdate conversion: Select To_char (sysdate, ' yyyy-mm-dd hh24:mi:ss ') today_date,--the time of the day with the seconds(Sysdate-to_date (' 197

http://www.itpub.net/forum.php?mod=viewthread&tid=1776483&pid=21223451&page=1&extra=# pid21223451 In the actual project, it is often necessary to invoke the cursor returned by another stored procedure in one stored procedure, and this article