Oracle

CommandDescriptionCrsctl start hasStart the database has service.CRSCTL Stat res-tCheck the status of each service (DG, monitor, asm instance, etc.) in ASM.SRVCTL Status ASMView the ASM instance state, normally the ASM instance of the master standby

Syntax for adding a field: ALTER TABLE tablename Add (column datatype [default value][null/not null],....);Modify the syntax of the field: ALTER TABLE tablename modify (column datatype [default value][null/not null],....);Syntax for deleting a field:

Examples of common methods for single-line functions are shown:--[1] character functions--Query the names of all employees in lowercase, uppercase, and uppercase letters--select ename from emp;--lower () lowercase upper () uppercase Initcap () first

Javama: summaryHttps://www.cnblogs.com/joeblackzqq/archive/2011/03/19/1988915.htmlFirst of all: Baidu above the search information, are garbage information, and examples are copied each other, there is no reference value,The most annoying is the

Create Tabletm_app_main_bak as SELECT * from Tm_app_main;Update Tm_app_main Set id_no = ' 110000 ' | | SUBSTR (id_no,7), unique_id = ' I ' | | ' 110000 ' | | SUBSTR (unique_id,8), cellphone = ' 12345678901 ';Select P.abode_detail from

View tablespace usage first for probability 1SELECT UPPER(f.tablespace_name) "tablespace name", D.TOT_GROOTTE_MB "table space size (M)", D.TOT_GROOTTE_MB-f.total_bytes "used Space (M)", To_char

First, what is a sequence　　A sequence is an object used to generate a unique, sequential ordinal. The sequence can be ascending or descending, and the Oracle user wants to create a sequence that has the role permission to create the sequence.Ii. SQL

Import= cx_oracle.connect (' user name/password @ip/servicename'#1 parameters = Cx_oracle.connect (' username ' ' password ') ip/servicename'#3 parametersOpen the Tnsnames.ora under the D:\app\username\product\11.2.0\client_1\NETWORK\ADMIN

DUMP function is a useful for this purpose.Sql> Select Dump (C1) from test;DUMP (C1)---------------------------------------------typ=96 len=4:48,49,53,48typ=96 len=4:48,48,49,48typ=96 len=4:48,48,53,48typ=96 len=4:48,49,48,48Where:TYP is the Oracle

Sql_trace is a powerful auxiliary diagnostic tool provided by Oracle for SQL tracing. In the diagnosis and resolution of daily database problems, Sql_trace is a very common method. 1. Enter the host of the database with Putty or other host tools.2.

------------------------------------------type conversion function------------------------------------------------Automatic type conversion, ORACLE can automatically change the following according to the specific situation:* String to Numeric*

Problem encountered: Ojdbc.jar packet errorReason: Because Oracle's Ojdbc.jar is charged, there is no such resource in the MAVEN central repository, and can only be loaded into the project by configuring a local library.Workaround:(if MAVEN is

2000 byte in Oracle, not 2000 characters, 1 characters in Oracle may be 1 byte to 4 byte, depending on the setting of the database character set.For the GBK character set, 128 characters in the ASCII code are stored using 1 bytes, the other

Step one, install VMware Tools:The full screen interface is more convenient to install Oracle.①umount? /media/centos 7 x86_64②vmware--Virtual Machine Options--Installation tools③ Auto Mount④ into?/media/vmware\ tools/unzip the package under the

Recently I have been asked if I have oracle11g database official reference documents, I think, this is not available on the official website can be downloaded, doubts, asked after the know, his official website to find, but when not found. Do not

SQL Duplicate Record Query methodAugust 14, 2008 Thursday 21:01 SQL Duplicate record query1, look for redundant records in the table, duplicate records are based on a single field (Peopleid) to determineSELECT * from Peoplewhere

Temporary tables in Oracle can be divided into session-level temporary tables and transaction-level temporary tables.The role of temporary tables: for large amounts of data we just need to query a subset of the result sets so that we can use

　　Other database objects:Sequence (SEQUENCE)Indexing (Index)Views (view)1. Sequence (SEQUENCE)Corresponding Database dictionary: user_sequences　　　　Role: A database special object used to produce a unique valueTo create a sequence syntax:Create

Overview:When the amount of data in the table is increasing, the query data slows down and the performance of the application degrades, so you should consider partitioning the table. After the table is partitioned, the logical table is still a

I. BACKGROUNDFollowing the Oracle Backup Restore Practice (link address: http://kaliarch.blog.51cto.com/8966921/1978151), due to business growth, frequent backup restores have a greater space requirement for disk space, The basic 500G per week of