Oracle

2010-3-10 http://localhost:5500/em/How to start Starting service: (1) dbconsole (2) Oracleservice; (3) Tnslistener In IE input: http://localhost:5500/em, the following error occurred: "The database state is currently unavailable. This may be

Select (Length (CSRQ)-length (replace (CSRQ, '-', ')) from dual; SELECT T.*,to_number (SUBSTR (R.pointstr,instr (R.pointstr, ', ', -1,1) +1,length (R.POINTSTR))/1000 as resultFrom Res_serverinfo T, Res_servicescope RWHERE Is_number (T.MAXRESID) =

Configuring system resources for Oracle in SOLARIS10 Wen/Huppis Haratu Summary:       In this version of SOLARIS10, System resource configuration management has changed significantly compared to previous versions. such as Oracle, in the process of

For example, the following error occurred, how to solve it? SELECT Job,what,log_user,to_char (last_date, ' yyyy-mm-dd HH24:MI:SS '), To_char (Next_date, ' Yyyy-mm-dd HH24:MI:SS '), Interval,failures,broken from User_jobs; JOB WHAT log_user to_char

Select ' Exec dbms_stats.unlock_table_stats (' | | | ') Username ' ' | | | table_name| | ""); From User_tablesReplace the username with the user who exported the source database.Copy the results of the above query and execute it in the username

EXEC Dbms_job.broken (23,false);Commit Select T.*, t.rowid from Dba_jobs t; Select T.*, t.rowid from Sys.user_jobs t; Select Job, Last_date, next_date, broken, interval, failuresFrom User_jobs; When a job returns an error at run time, Oracle

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 ')

The first method: Log in with the system account like Sys as SYSDBA 1, view the database lock, diagnose the source and type of the lock: select Object_id,session_id,locked_mode from V$locked_object; or use the following command: Select

1. First put the top 4 packages under the Lib folder 2. Configure XML, placed in the SRC directory ommentgenerator> Rator targetpackage= "src. Map "targetproject=" src "> 3. Write Execution

Before Oracle9i, Chinese is sorted according to binary encoding. In oracle9i, according to pinyin, radical, stroke sorting function. 1, set the Nls_sort parameter value Schinese_radical_m sorted by radical (first order), stroke (second

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

1. View Oracle Max Connection numberSql>show parameter Processes #最大连接数2. Modify the maximum number of connectionsSql>alter system set Processes=value Scope=spfileRestart the databaseSql>shutdown ForceSql>start Force3. View the current number of

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

When we test the data or do some kind of large amount of data, we can use the statement for mass insert, My test, 100,000 data insertion time of 7 seconds or so, 1 million record insertion time of 65 seconds, 2 million inserted into 150 seconds.

--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 >

SUBSTRING, this function is used to find a string of strings, the function of the use of high frequency. Sample string: "2011-11-17" The function to ask for a string in Oracle is: SUBSTR The syntax for the SUBSTR function is: substr (String,

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

I have a table table_a inside there is a field where the user's number is saved, and the number is separated by commas, for example: 379,380,386,390,503 I do query select * from user where user_id in ( 379,380,386,390,503); is correct. But when I

Oracle detects a few previous records based on a record in the table My watch is: Info_m1_tran Preferred to first navigate to this record in the table rownum, I sorted according to data_time ASC then the rownum value of the existing records will not