Oracle

Oracle if else if statement was written to the Oracle stored procedure some time ago. originally written as www.2cto.com if 1 = 2 then null; elseif 1 = 3 then nullend if; In the PL/SQL editing environment, elseif does not change color, indicating

Oracle Study Notes database to obtain random n records recently in the company's Internet of vehicles service system, met a demand, need to obtain random n records from the database. I have referred to the solution provided in SQL cookbook. I will

Step 1. telnet to the remote database server CMD> telnet to the remote database IP address www.2cto.com 2. Switch to the Database User DQXXDBS01: /> su-oracle 3. Use a super user to access the database $ sqlplus "/as sysdba" 4. view the parameters,

Oracle SQL Test 1 SQL code www.2cto.com id sname smoney sprovince 1 zhangsan 2098 A 2 lisi 3000 B 3 wangwu 6789 C 4 liumazi 4587 C 5 dongjiu 3298 B 6 shiga 4567 A id: contract id sname: Name smoney: Performance sprovince: Region create table test

Oracle 4 equivalent SQL code www.2cto.com SELECT COUNT (1) FROM (SELECT k001 FROM (SELECT k001 FROM kbib GROUP BY k001) k where not exists (SELECT 1 FROM (SELECT k003 FROM calb group by k003) c WHERE k. k001 = c. k003) select count (1) FROM (SELECT

[SQL] www.2cto.com -- 19-1: create or replace function cur_datetime RETURN VARCHAR2 is begin return TO_CHAR (sysdate, 'yyyy "year" MM "month" DD "day" HH24 "Hour" MI "Minute" SS "seconds" '); END;/-- 19-2: create or replace function get_sal (name

Oracle views authorization and data dictionary views oracle views authorization: www.2cto.com all_tab_privs. the grantor grantee Authorizer TABLE_SCHEMA table is in which mode the TABLE_NAME table name PRIVILEGE grants the GRANTABLE permission.

The oracle object unlock operation queries the locked object select * from v $ locked_object; www.2cto.com queries the locked table select B. owner, B. object_name,. session_id,. locked_mode from v $ locked_object a, dba_objects B where B. object_id

Oracle index statement sorting 1. create an index www.2cto.com create [unique] index index_name on table_name (col_1, col_2 ,...) tablespace tabspace_name; 2. alter index index_name pctfree 30 storage (initial 200 k next 200 k); 3. manually assign

An analysis of the evolution of the RAC architecture from a single instance to RAC. The architecture is also built by the RAC cluster and Clusterware cluster. (1) The significant changes of SGA www.2cto.com SGA are saved by a GRD: ① PCM Lock

Database paging query keyword SQL code www.2cto.com 1. select * from (select. *, rownum rc from table name where rownum = startrow common paging syntax for oracle. Assume that select * from (select t. *, rownum from (select * from table1 where

The typeid field of the oracle keyword table is not long ago. When you import the oracle database, you cannot create a table because it contains a field named after the oracle keyword. Www.2cto.com: How was the table created successfully? With

Oracle Database Partition technology Partition introduction Partition refers to dividing a very large table or index into smaller, easy-to-manage logical fragments-partitions according to the value of a column. Partitioning a table or index does not

In Oracle, loop www.2cto.com is the simplest loop statement in plsql. This loop statement starts with loop and ends with end loop, this loop will be executed at least once, that is, the first loop is used to judge the case: Write a process, enter

Oracle tablespace query settings select s. tablespace_name, round (sum (s. bytes/1024/1024), 2) as Space, round (sum (s. bytes/1024/1024)-nvl (d. fr, 0), 2) used, nvl (round (d. fr, 2), 0) free, decode (round (sum (s. maxbytes/1024/1024/1024), 2), 0,

In Oracle, how does one merge two tables with different columns and different rows into one? SQL: www.2cto.com select s. stagename sname, sum (nworkhours) nworkhours, sum (OVERHOURS) OVERHOURS, sum (nworkhours + OVERHOURS) from T_WorkDetails w,

When creating a table in oracle, you must first Delete the table. oracle syntax does not include the drop table table_name if exists form in mysql syntax, but we can save the country by using the orale stored procedure to achieve the same effect,

Oracle imp import to the specified tablespace 1. create tablespace example_tablespace datafile 'e :\****. dbf 'size 10 m reuse autoextend on next 1 m maxsize unlimited; www.2cto.com 2. create user username identified by password default tablespace

If file is not specified for exp, the default path is the current path of CMD. When executing the exp command in the morning, the FILE path is missing. The command is as follows: www.2cto.com C: \ Users \ Administrator> exp scott/scott @ orcl file =

Oracle RAC startup sequence process owner -- Process ---- log location www.2cto.com $ LOG_HOME = $ GRID_HOME/log/hostname/root ----/etc/init. d/init. ohasd run --- $ LOG_HOME/ohasd. log root ----- orarootagent. bin ------ $ LOG_HOME/agent/ohasd root