Oracle

Oracle Modify Field namesALTER TABLE name rename column Old field name to new field nameOracle modifies field type and lengthALTER TABLE name modify field name data typeIf you modify the data type such as modified by VARCHAR2 to int and the field

in theOracle Database, the Oracle system variable function is a commonly used function that shares the usage of the Oracle system variable function. There are a variety of Oracle functions, one of which is the system variable function, which

Environment:os:oel5.6rac:10.2.0.1.0There are currently rac1,rac2,rac3 three nodes, the following is a detailed procedure for deleting RAC3 nodes1. Delete The DB instance on the RAC3 node[Email protected] ~]$ dbca-silent-deleteinstance-gdbname racdb-

1 Creating a Stored procedureCreate or replace procedure Job_proc isBeginInsert into YY (Yid) values (sysdate);End2 Create JobDECLAREJOB Binary_integer; --Task IDV_begin DATE; --Start timeV_interval VARCHAR2 (50); --Time

Create a temporary table spaceCREATE Temporary 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'on NEXT 32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL;Create a user table spaceCREATE'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TEST_DATA01. DBF'onNEXT 3

Oracle error ORA-00604 recursion SQL Level 1 error ora-00942 table or attempt to not exist ORA-06512 In line 11, ora-00604ora-00942 The error is as follows:   I searched for many methods, but there was no solution, but finally I found a good

Oracle implements find_in_set sorting for mysql! Oracle implements sorting similar to MYSQL find_in_set, function decode: Select * from tb_info_game where gameid in (, 18) order by decode (gameid)By default7 # zbphp.com Reference CDSN post: http:/

Oracle cross-database query Distributed Query of replicated table data Method 1: Currently, most databases require distributed queries. The following describes how to configure cross-database access in oracle. For example, there are two database

Oracle left Outer Join tests For more in-depth left outer join, we did some tests. There are several forms of external join writing. We can track the final SQL conversion form through 10053. -- Initialize data Create table( Id number, Age

Create a partition table in Oracle 1. Create partitions by month Create table T_MHDP ( ID VARCHAR2 (50) not null, FLT_AIRCODE VARCHAR2 (4 ), FLT_NUMBER NUMBER (7 ), FLT_DATE DATE ) Partition by range (FLT_DATE) ( Partition PART201105 values less

Oracle minus usage Create two tables: Create table guotest1 ( SName varchar2 (10 ), Gender varchar2 (10) ) Create table guotest2 ( SName varchar2 (10 ), Gender varchar2 (10) ) Insert data: Insert into guotest1 values ('A', 'M '); Insert into guotest1

Oracle modifies the default character encoding -- View the Oracle database character set: SQL code Select userenv ('language') from dual; Query results: SIMPLIFIED CHINESE_CHINA.AL32UTF8 -- Modify the character set of the oracle database: (in SQL

Install Oracle12c on Fedora20 This article will guide you to successfully install Oracle12c in the Fedora20 environment.Preparations before installation Edit the/etc/hosts file and add the local name   Edit the/etc/selinux/config

Oracle Performance Analysis 3: TKPROF Introduction Tkprof is a command line tool that comes with Oracle. It is mainly used to convert the original trace file to a formatted text file. The simplest way to use it is as follows: tkprof

How does Oraclecloudcontrol12c modify the sysman password? Oracle Cloud Control 12c was deployed on a virtual machine a few days ago, and the login password was forgotten. The main reason is that Oracle-related Software provides stronger security

Oracle: dump File Import error: only DBA can import files exported by other DBAs Export the dump file of a table from schepaa (DBA permission) and import it to scheab (non-DBA permission). An error is returned. Use the OB tool to set scheaa to DBA

How to update a patch (RollingPatch) in the OracleRAC Environment) The Oracle RAC database environment has many similarities and differences with the single-instance database environment. You can use opatch to update database patches. However,

Checking for oracle home incompatibilities failed, incompatibilities An error is reported during Oracle software installation: Error cause: This error is mainly caused by the last installation failure of oracle, but the directory files left

From ORA-27300, ORA-27301 to ORA-00064Recently, due to the increase in the number of sessions, you need to adjust the session, that is, to adjust the process parameter. Look at is a relatively simple problem, but encountered a ORA-27300, ORA-27301.

Application of Oracle virtual Index When performing SQL optimization, you may need to add an index to test whether it can help improve the performance. If the table is very large at this time, it will be very troublesome to create an index, in this