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
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
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,
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
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.
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
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',
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 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
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
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
[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
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_
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 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 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
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
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
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