Oracle

WINDOWS10 Remote Desktop Connection error message:Detailed steps:1. Open the registry, quick input "regedit" (similar to the command prompt input cmd)2. Find the folder path:

Move control Files[[email protected] ~]$ Sqlplus/as sysdbasql> set line 200sql> col name to a60sql> select Status,name from V$co Ntrolfile;                      STATUS NAME------------------------------------------------------------------------------

Asked to calculate the size of the table space for a table, the web looked up some data for Oracle's 3 views. Specific SQL is as followsSelectSegment_name asTableName,round(bytes/ (Select sum(a.bytes) fromDba_data_files A, user_users

Statement of the basic operation:Dml:select, INSERT, UPDATE, DELETE, MERGEDdl:create, ALTER, DROP, RENAME, TRUNCATE, COMMENTDcl:grant, REVOKETransaction control: COMMIT (Release), ROLLBACK (rollback), savepointTo create a table:CREATE TABLE

A script to insert data in batches that you need to work with.DeclareCode_ Number (10): = 100000;Num_ Number (10): = 2000000;Error_message exception;BeginFor I in 100.. LoopNum_: = num_ + 1;Code_: = Code_ + 1;INSERT INTO

The Oracle with statement can implement the same sequence as the Connect by statement:Connect by usageUse RowNum to implement a sequence of 1 to 10.Select RowNum from dual connect by rownumUse the level to achieve a sequence of 1 to 10.Select level

Background: The database has a long-term execution of stored procedures resulting in excessive resource consumption, the following is expected to quickly locate stored procedures, rapid intervention processing, restore database performance.

1. An implicit conversion causes an index to fail. This should be taken seriously. It is also a common mistake in development.Because the table's field TU_MDN is defined as VARCHAR2 (20), the field is passed to Oracle as the number type in the query,

1 /*divided into four steps*/2 /*1th Step: Create a temporary table space*/3 Createtemporarytablespace user_temp4Tempfile'D:\oracle\oradata\Oracle9i\user_temp.dbf' 5 size 50m6Autoextend on 7 Next50m maxsize 20480m8 extent management Local; 9 Ten /*

1. Oracle's command to regain statistical informationexec dbms_stats.gather_schema_stats (ownname ='LCoe739999'gather "for allcolumns size repeat'4)# need to modify ownername options designation and degree generally related to CPU dataYou can

User processps–elf | grep oracleorcl|grep–v grepDatabase processPs–elf |grep ORACLEORCLDaemon processPs–elf |grep OHALarge pool: In the SGA, the large pool is an optional buffer area that administrators can configure as needed, requiring large pools

Paged query with the following SQL, the query is the 6th to 10th dataSelect t.* from (select U.username, rownum row_num from Table_user u where rownum => 5Use the number of pages to indicate:/** * * @paramNumofpage A few data per page

A standard Oracle data file can contain up to 4,194,303 Oracle data blocks. So this also means that the maximum size of a single data file depends on the Oracle block size used. (MOS ID 112011.1) SQL> SELECT TO_CHAR (4194303 * VALUE, ‘9

This article describes how to use the Trim+translate function or the Regexp_like function to determine whether a field in a table is a number1. Use the Trim+translate function:select * FROM table where trim (Translate (column, ' 0123456789 ', ")) is

1. Bulk Delete/batch updateMapperUpdateID= "Updateprjstatebyfprjid"ParameterType= "string">UPDATE table_name Set f_stat = #{f_stat,jdbctype=varchar}, f_s_id = ' 1 ' where pk_id in foreachCollection= "IDs"Item= "id"Open="("Separator=","Close=")"

Tag:listening   acl    Summary    sys   res    sqlplus   gen   mini   sysdba    Service Name   --Modify [[email protected] ~]$ sqlplus / as sysdbasql>  according to business requirements show parameter service_names;name                              

Reprint from Https://yq.aliyun.com/ziliao/123360Create or Replace trigger Logon_ip_controlafter logon on Databasedeclare IP STRING ( -); User STRING ( -); Beginselect Sys_context ('USERENV','Session_user') into user fromdual; SELECT Sys_context

In some databases (for example, MySQL), implement the self-increment ID as long as you specify it when you build the table,But in Oracle, with sequence to implement the self-increment ID,There are several ways to use the self-increment ID:1. Use

Snapshot sql> col begin_interval_time for a30sql> col end_interval_time for  a30sql> select snap_id,     to_char (Begin_interval_time, ' Yyyy-mm-dd hh24:mi:ss ')  begin_interval_time,    to_char (End_interval_time, ' Yyyy-mm-dd hh24:mi:ss ')

Sql> shutdown immediatesql> startup mountsql> alter system set  log_archive_dest_1= ' location=/u01/app/oracle/archive/ mandatory '; Sql> alter system set log_archive_dest_2= ' location=/u02/app/oracle/archive/  Optional ';