Oracle

The content of this article mainly comes from: http://lbyzx123.javaeye.com/blog/829235   1. Create the script file Oracle10g under/etc/init. d/with the following content:   #! /Bin/bash # Whoami # Root # Chkconfig: 345 51 49

A small test was conducted: Create Table vipr_airport_rule1(Airline varchar2 (2) not null,Airport varchar2 (3) not null,Start_time date not null,End_time date not null,Num number not null) Try to insert data: Insert into vipr_airport_rule1

call the stored procedure with returned result set: /*** Call the stored procedure with returned result set ** @ Param procname * @ Param * @ return * @ throws sqlexception * @ throws nofreeconnectionexception */Public datasource execuceproc

Front-end UI process (written in vc6) to UTF-8 Chinese to back-end serviceProgram(Linux GCC). The data is written to the Oracle database in the background, and then the data is retrieved and displayed in the background. No encoding/decoding

Microsoft. netframeworkdataproviderfororacle (. netfororacle) is a. netframework component. This component provides great convenience for us to access the Oracle database using. net. Developers who use. NET and Oracle are sure to be happy because

What is the relationship between last_date and next_date in the job and interval? Does last_date indicate the start time and end time of the job. Is next_date the start time of the job or the end time plus interval? If a job is executed for a long

PHP operations on Oracle databases (OCI data abstraction layer)OCI (Oracle 8 call-Interface) is a built-in database abstraction layer function in PHP.The following are examples of common tasks for connecting to an Oracle database to operate a

I recently obtained some spatial data, so I found some knowledge about Oracle spatial databases. The following is a summary: Oracle Spatial is a combination of object data types, type methods, operations, functions, and processes. A geographical

Flashback version query is not a new feature of Oracle, but the 10g and 11g functions are enhanced on the basis of 9i, which may be used in some occasions. The following example shows his concept; Connected to Oracle Database 11g Enterprise Edition

1. Export tool exp 1. It is the directory for storing the next executable file in the operating system/ORACLE_HOME/bin The exp export tool compresses data backup in the database into a binary system file, which can be migrated between different

2005/07/22 Event: I first checked the stored procedure and carefully read the PL/SQL code to find that there was no error, this made me very strange. At this time, I did not dare to directly use toad debugging on the user's system, so I asked the

Create Table image_lob (t_id varchar2 (5), t_image BLOB ); Create or replace directory images as 'e: \ image '; Select * From image_lob; Create or replace procedure ima_insert (TID varchar2, filename varchar2, v_path varchar2) F_lob bfile; -- file

  Address: http://www.cnblogs.com/caizhanshu/articles/1153277.html Web site: http://www.diybl.com/course/7_databases/oracle/Oracleshl/20110315/554478.html? Username = xing_sky & Password = yu900923   1. dbms_outputFunction: used for input and output

Many people, especially those who do not like Oracle, must learn from Oracle and think that Oracle occupies a lot of memory.I really don't like installing oracle on a physical machine. Most of them are Windows users, and most of them are

1 set operation Definition: displays the results of Multiple SQL statements in a logical integrated operation.By default, set operations are sorted by the first column of the First query in ascending order, except for Union all:Minus: Get

(1) Insert into table_name [(column [, column...])] select_statementOnly one table can be inserted at a time, but the performance is higher than writing multiple insert statements. In addition, Oracle also provides create table table_name as select..

1. Oracle Database User Management1. Differences between sys and system users(1) The importance of stored data is different:Base tables and views of all ORACLE data dictionaries in SYS are stored in SYS users. These base tables and views are crucial

Introduction: When a new user is created, the user does not have any permissions and cannot perform any operations. If you want to perform a database operation to be determined, you must grant the system permission to it. If you want to access

Functions are the same as functions and views in SQL Server classification. -- Search fields to be set: expertname, expertdomain, hitcountsdata, workhistory, eduhistory, projecthistory, award, researchpaper, researchpapermonograph, expertallinfo--

IMP username/password file =/home/newbak. DMP full = y imp alpha/123456 file =/home/db20120308.dmp full = ysql> grant create user, drop user, alter user, create any view, drop any view, exp_full_database, imp_full_database, dBA, connect, resource,