Oracle

[Root@localhost server]# rpm-qa binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc-gli Glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp Bc-common libstdc++ make Numactl-devel Sysstat

Open Oracle's DBCA View the Acyx instance you just created in the Windows service Log on using Pl/sql developer Pop up the following prompt box Start Service Oracleoradb11g_home1tnslistener Try again using Pl/sql Developer login,

2008/03/07Skate A variable can be defined in a cursor, and the following is an example of the procedure of my Update column order Create or replacePROCEDURE TEST as--v_id varchar2;--V_num number;--v_x number;I number (10,0): = 1;v_id VARCHAR2 (32);V_

SELECT tablespace_name table Space, To_char (ROUND (bytes/1024, 2), ' 99990.00 ') | | "Actually, To_char (ROUND (free/1024, 2), ' 99990.00 ') | | ' G ' existing, To_char (ROUND (bytes-free)/1024, 2), ' 99990.00 ') | | ' G ' use, To_char (ROUND (10000

When installing Oracle 9i encountered this areasqueries error, this time must not panic (at that time in the client loaded db, out of a sweat-_-!! , Baidu will know, is the installation directory of Oracle with Chinese characters caused .The

Oracle namespace Source: http://hi.baidu.com/yinyuman/blog/item/ac65da2a785ae526d42af1cf.html Don't know if you have noticed such a problem in the course of learning, when you create a table named Test. Maybe a few days later, when you do an index

Select Sys_context (' USERENV ', ' TERMINAL ') TERMINAL, Sys_context (' USERENV ', ' LANGUAGE ') LANGUAGE, Sys_context (' USERENV ', ' SESSIONID ') SESSIONID, Sys_context (' USERENV ', ' INSTANCE ') INSTANCE, Sys_context (' USERENV ', ' ENTRYID ')

 No output parameters: DeclareJobno number;BeginDbms_job.submit (Jobno,What => ' sp_alert_info; '--sp_dayend as the name of the stored procedure--interval => ' TRUNC (sysdate) + 1 + 17/(24) '--Define time intervalInterval => ' TRUNC (sysdate, '

1, start the database: Oracle@suse92:~> Sqlplus/nolog Sql*plus:release 9.2.0.4.0-production on Fri 20 02:29:37 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Sql> Connect/as SYSDBA Connected to a idle instance. Sql>

Simple and practical, not much nonsense said: [SQL] view plain copy Select Substr (' A, ', 2,1) from dual;substr (' character to intercept ', length of character, character length-1) Extended: [SQL] view plain copy Select substr

CREATE OR REPLACE TYPE ty_object as OBJECT (Col_name VARCHAR2); / CREATE OR REPLACE TYPE ty_table as TABLE of Ty_object; / CREATE OR REPLACE FUNCTION str2table (v_str in VARCHAR2, v_delimiter in VARCHAR2) --

xflag=0;While [$xflag-ne 10]TodoValue= ' Sqlplus-s dbusername/uspass@xxxx Set heading off;Set feedback off;Set pagesize 0;Set verify off;Set echo off;Select Service_sn from rule_phone_sell_activity where Rownum=1 and flag=0 and sell_type=1;ExitEOF

--Monitoring whether the job performs an abnormal or stopped behavior CREATE OR REPLACE PROCEDURE p_job_monitoring as BEGIN For V in (SELECT JOB, WHAT, failures, broken From User_jobs T WHERE t.failures > 15 OR t.broken = ' Y ' OR t.next_date >

I just finished the system today. wrote an Oracle data Connectivity test but reported a bad version number in class file error, the online discovery is a JDK setup problem. MyEclipse defaults to jdk5.0 and the environment I run is set jdk6.0

http://space.itpub.net/7104/viewspace-133950 Statistics of records for all tables in Oracle CREATE TABLE A(USERNAME VARCHAR2 (20),TableName VARCHAR2 (50),JS VARCHAR2 (10)) Create or replace procedure P_getcountAsMicount INTEGER;T_owner VARCHAR2 (40)

Package DB; Import java.sql.Connection; Import Java.sql.DriverManager; Import Java.sql.ResultSet; Import java.sql.SQLException; Import java.sql.Statement; public class Oracletest { /** * @param args * @throws

Run the page, the name of the project in Myeclipse>project facets>web>web context-root/project name Eclipse >properties for Order-front. Web project Settings >context root/ Com.zy.dao: interface Com.zy.dao.imp: Instantiating Com.zy.service:

Example 1: Query the manager (manager) in each department who has the lowest payroll HR SELECT * FROM(Select T1.MANAGER_ID as employee number, T2.first_name as employee name, t2.salary as salaryFrom Hr.departments T1Join Hr.employees T2 on

Select A.*,level from T_customer aStart with customer_id = ' AABB10000010 'Connect by Prior customer_id = parent_cust_id Select A.*, LevelFrom T_industry AStart with industry_id = ' B03 'Connect by Prior industry_id = parent_id--connect StringSelect

First, the degree of minutes and seconds turn point degree Select T.lon,substr (T.lon,0,instr (T.lon, ' ° ')-1),substr (T.lon,instr (T.lon, ' ° ') +1,instr (T.lon, ' ′ ')-instr (T.lon, ' ° ')-1),substr (T.lon, ' T.lon,instr ') +1,instr (T.lon, ' ″ ')