Oracle

The database version installed on my local machine is Oracle 11g R2. When I connect to the database today, the following error is reported: Oracle not available ORA-01034 ORA-27101-shared memory realm does not exist I found several solutions

ArticleDirectory Basic syntax Examples Coalesce and nullif Functions Conclusion The difference between the expression and the as expression after the case and the end is the most obvious -- Oracle Select

Analysis:1. when installing Oracle, Oracle creates a directory named "Current ip_orcl" under F: \ oracle \ product \ 10.2.0 \ db_1 by default, this directory stores information such as the configuration of the Oracle database named orcl.2. by

If you need to reprint it, please indicate the source! (Thank you first ......) Configuration of Oracle TAF TAF is short for transparent application failover. Generally, the application TAF is in the OPS/RAC environment. The purpose and idea of

1. Start the case without loading the database You can start the instance without loading the database. This is generally done only when the database is created:Startup nomount 2. Start the case and load the database You can start the instance and

Oracle date functions:There are many date functions in oracle, such:1. add_months () is used to increase or decrease the number of months from a date value.Date_value: = add_months (date_value, number_of_months)Example:SQL> select add_months

Use Oracle Database 10 GInternal ETL infrastructure Http://www.oracle.com/technology/global/cn/obe/10gr2_db_single/bidw/etl2/etl2_otn.htm -- Some basic concepts and types of CDC are introduced in Change Data Capture (1. This article mainly

The global_name of the three databases is as follows: Orcl16.com 192.168.100.16 (primary database, that is, data source) Orcl8.com 192.168.100.8 (copy database) Dtgdb.com 192.168.100.150 (copy database) Set initialization parameters for the three

The first block 0 in an oracle file is the OS block header. No information is found in the database. It records OS information, file size, and other information: SQL> select file_name,bytes from dba_data_files; FILE_NAME

Create a Pipelined table function in oracle. I am tired of it. Remember it and save the trouble. 1. Create a type first: Create or replace type smpl_metadata AS OBJECT ( Smpl varchar2 (2000 ), Lauren varchar2 (2000 ), Grade varchar2 (2000) ); 2.

About Non-equal signs in Oracle:In Oracle, <> ! = ~ = ^ = They all mean no. Can be used. But it's strange. When I want to take out products whose price is not 180000: (price is Number type) SELECT id, name FROM product where price <> 180000; When

The full uninstall mode for Oracle 11g servers and clients has changed with the previous versions: 1. Preparations before uninstallation: Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services. Ii. Batch unload: Run

The ORACLE tutorial is: Security Policy of Oracle Database. ---- Oracle is a relational database management system with powerful functions and excellent performance. It plays an important role in today's large database management systems. In the MIS

The permission system of the oracle database includes system permission and object permission. Database system privilege allows users to execute specific command sets. For example, the create table permission allows users to create tables, and the

Delete deletes a large table. It is not released between time and space. It is very slow because it occupies a large amount of system resources and supports rollback. The space is also occupied by this table. Truncate table Name (tablespace is

SQL> show all -- View all 68 system variable values SQL> show user -- display the current connected user SQL> show error -- Display error SQL> set heading off -- disable the output column title. The default value is ON. SQL> set feedback off --

1. INSERT (INSERT the record statement into the data table) Insert into Table Name (field name 1, field name 2 ,......) VALUES (value 1, value 2 ,......);Insert into Table Name (field name 1, field name 2 ,......) SELECT (field name 1, field name 2

The ORACLE tutorial is to optimize the Oracle downtime and database recovery. Here we will discuss the steps to minimize Oracle downtime. Various types of downtime-planned or unplanned-always happen. a dba should have the correct backup policy so

The ORACLE tutorial is about three File Upload technologies in Oracle. There are multiple ways to upload files to the database or Server File System in Oracle. Here we mainly introduce the following three types: The mod_plsql module of Oracle HTTP

1. select * from emp; 2. select empno, ename, job from emp; 3. select empno number, ename name, job from emp; 4. select job from emp; 5. select distinct job from emp; 6. select distinct empno, job from emp;Note: Because employee numbers are not