Teaches you how to fix the Oracle listener that has been kissed by the optimization master.

Symptom: The Windows optimizer optimizes Oracle when optimizing the registry, so that the listener cannot be found. The solution is as follows: ◆ 1. in the registry, HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesOracleOraHome92TNSListener The

Unveil the mystery of Oracle 10 Gb manual database creation

Recently, many new Oracle beginners or those who upgraded from the old version of Oracle to 10 Gb asked questions about how to manually create a database in Oracle 10 Gb. Today, we are free to write down the whole process of manual database creation

Oracle faq one thousand [801 to 900]

801. ALL_DIM_HIERARCHIESDisplays the dimension levels. 802. ALL_DIM_JOIN_KEYDescribes the connection between two dimensions. 803. ALL_DIM_LEVEL_KEYDescribes dimension columns. 804. ALL_DIM_LEVELSDescription dimension level. 805.

Oracle Decode and CASE Sample

Create table testabc (A Number,B Date); Insert into testabc (a, B) values (1, TO_DATE (1-MAY-2010/, DD-MON-YYYY/HH24: MI ));Insert into testabc (a, B) values (1, TO_DATE (2-MAY-2010/, DD-MON-YYYY/HH24: MI ));Insert into testabc (a, B) values (1,

Oracle tablespace space management

  Table space: Provides the logical structure of the space used by the database. Its physical structure is a data file. A table space can contain multiple data files. Local table space management (LMT)-a new table space management mode that appears

Query which user connections are currently available in the Oracle database

  DBAs are sometimes used.   SQL code SELECT s. Osuser OS _User_Name, Decode (Sign (48-Command), 1, To_Char (Command ), 'Action Code # '| To_Char (Command) Action, P. Program Oracle_Process, Status Session_Status, s. Terminal, S. Program, s.

Oracle plsql cursor

  Create or replace procedure test_proc is V_corpid corpinfo. corpid % type: = '20140901 '; Vv corpinfo % rowtype; -- Define a cursor Cursor one is Select * from corpinfo where corpinfo. corpid like v_corpid; Begin -- Traverse cursor 1 Open

Oracle row-to-Column

How to Write specific SQL statementsIn this example, subjects are not fixed and dynamic.Create table test (name char (10), km char (10), cj Number)Insert into test values ('zhang san', 'China', 80)Insert into test values ('zhang san', 'mat',

Oracle Table query

1. SQL * Plus does not care about the case sensitivity of SQL commands. SQL * Plus is case sensitive only when detecting text values;2. All values in the varchar2 and char columns are characters, including 11 and 2. The values stored in these

Oracle sequence Learning

Oracle sequence Learning I. Create a sequenceCreate sequence [user.] Increment by Start with [Maxvalue | nomaxvalue][Minvalue | nominvalue][Nocycle]  it can be positive or negative, but cannot be 0. If this clause is not available, the default

Oracle-DBA Summary

1. Data Dictionary 1.1 query the data dictionary. Dictionary ----- this dictionary contains all dictionary InformationSQL> select * from dict where instr (comments, 'index')> 0; ----- query all data dictionary names related to indexes.1.2 set the

ORACLE Procedure Stored Procedure syntax

Summary of ORACLE Procedure Stored Procedure syntax subroutines and packages: subroutines are named PL/SQL blocks that can contain parameters and can be called at any time as needed. PL/SQL has two types of subprograms: process and function. A

Use PL/SQL to execute OS commands

Use PL/SQL to execute OS commands [SQL] create or replace and compile java source named ExeSysCommand as import java. io. *; public class ExeSysCommand {public static String ExeCmd (String args) {Runtime run = Runtime. getRuntime (); Process process

Configure table space, create users, and import Databases

Configure table space, create users, and import Databases --- Cmd go to the dos interface sqlplus/as sysdba ---- create table space --- create tablespace ciqpspace DATAFILE 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ CIQP when creating the

Examples of common Oracle maintenance statements

Oracle maintenance commonly used statement instance Article as a friend interested in oracle, will certainly be interested in this article oracle maintenance commonly used statement examples. View the table space name and size: Select t. tablespace_

Summary of issues frequently seen during SQL plus * execution of SQL files

Use sqlplus to execute *. summary of common problems in SQL Files case 1 Description: After using sqlplus to log on to the database, enter @ file name full path to execute *. SQL file example: assume there is a test. the path of the SQL file is/home/

Oracle Data Pump usage (1)

Oracle Data Pump usage (1) Oracle Data Pump expdpimpdp I. Data Pump export steps: 1. Create a directory (I created it using a system user, scott user does not have permission) create directory dump1 as 'e:\dump' ;  2. Authorize scott user grant read,

Oracle migrates fields between tables through the Stored Procedure

Oracle implements field migration conditions between tables through the stored procedure: two tables: ITPUB_TEST1 field id, value ITPUB_TEST2 field id, funcid, action ITPUB_TEST2 funcid associated with id in itpub_test1. Task: migrate the action

Index usage of order

Order by index usage problem: id is PK select a,b,id from adf where rownum  The result is 'ORDER BY' first, and then execute rownum select a,b,id from adf where rownum  The result is to execute rownum SQL> select * from t; ID ID1 ---------- 1 2 2 2 4

Use union all to display the total

Union all is used to display the total items in a total project. Generally, a column is calculated and the total is displayed at the end of the column. The conventional method is to use union all to establish meaningless connections. Example: SQL

Total Pages: 2147 1 .... 2089 2090 2091 2092 2093 .... 2147 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.