Oracle

  To view the permissions of an Oracle user, you must first traverse all the users and then view the permissions of the Oracle user. I hope this article will help you.       1. View All Users:       Select * from dba_users; select * from all_users;

We are all familiar with the recycle bin in windows. You can restore the deleted files to the recycle bin. the Oracle recycle bin works exactly the same, but there are some differences in implementation details. in addition, the recycle bin can only

The boss assigns a task to perform CRUD operations on the Identification table and identification table. There is no difficulty in coding, but there are two places I want to record. First, give the table structure.REPOT_BS ): Name Type Nullable

ORA-14037: partition limit for partition "P2" is too highCreate table PROVINCE_INFO(PROVINCE_ID VARCHAR2 (8) not null,PROVINCE_NAME VARCHAR2 (40) not null,CREATE_DT DATE)Partition by range (PROVINCE_ID )(PARTITION P1 values less than ('8

Today in the use of an insert statement is not too much meaning, after the statement is written correctly executed, did not expect ORACLE to report a ORA-01403: No data found error, after carefully checking the statements, there is no error. Because

1, ERROR:ORA-12560: TNS: protocol adapter error Listener is not started. start listener: lsnrctl start on the server where the database is located.  2, ERROR:ORA-01033: ORACLE initialization or shutdown in progress Oracle is not in the open state

SQL> select * from sys. SHIP_CABINS; SHIP_CABIN_ID SHIP_ID ROOM _ ROOM_STYLE ROOM_TYPE window guests SQ_FT BALCONY_SQ_FT-----------------------------------------------------------------------------------------------------1 102 Suite Standard Ocean 4

Fault description: the following error is reported when the master database is started after the oracle dataguard environment is set up: Wed Feb 8 23:12:38 2012LGWR: Error 16047 creating archivelog file 'standby'Wed Feb 8 23:12:38 2012Errors in file/

1. You can use SQL * Plus statements to change environment parameters. SQL> set linesize 900;/* change the display width. After it is set to 900, a row of data will not be displayed in two rows */ SQL> set pagesize 20;/* set the number of page

Oracle11g modify sga to modify memory_target and other parameters first, otherwise the service will be restarted with an error ORA-00844: Parameter not taking MEMORY_TARGET into account, see alert log for moRe information. To modify the SGA

I. Information in the database cache 1. What is an execution plan? 2. Why share the execution plan? The execution plan generation takes a lot of CPU time, And the optimizer will store the generated execution plan to the shared pool. If you execute

A cool exception, no clue at all, so google. In the past, my database used oracle 11.2.0.1.0 and jdbc used ojdbc 10.2.0.2.0. After several months, no error was reported. Today, even more enchanting events have occurred. The two applications are

Sys @ DEX> select * from v $ statname where name like '% sort % '; STATISTIC # name class STAT_ID----------------------------------------------------------------------565 sorts (memory) 64 2091983730566 sorts (disk) 64 2533123502567 sorts (rows) 64 3

In the past, I remember that Mysql Command terminals can insert or update databases in batches. Write down the PL/SQL Deverloper Method for Batch Data Processing today. 1. log on to PL/SQL Developer2. Choose menu File> New> command window.3, SQL> @

 Paging query statement:Select * from (Select A. *, rownum rn from (Select * from table table_name)Where rownum = 20;Select * from table_name indicates the original query statement that does not flip pages. Rownu = 21 control the range of each

With alias as (select * from *) select * from alias; equivalent to creating a temporary table syntax is with tempname as (select ....) select... example: with t as (select * from emp where depno = 10) select * from t where empno = xxx another simple

Insert into Table Name (Field 1, Field 2) select '1', '2' from dual union all select '3', '4' from dual union all select '5 ', '6' from dual union all select '7', '8' from dual union all select '9', '10' from dual reads all data from a CSV file, it

1. Single-Row Functions (Single-Row function) Single-Row function returns a separate result Row for the table or view queried for each Row, single-row functions can appear in SELECT columns, WHERE clauses, start with and connect by clauses, and

[SQL] usage of int and out in PL/SQL stored procedures 1. Introduction to in and out (1) in procedures and functions, the difference between a process and a function is that a function can return a value without a return value. (2) but both the

Sometimes oracle reports the following error when executing a large transaction: Pl/SQL code ORA-01555: snapshot too old (rollback segment too small) this indicates that the random rollback segment allocated by oracle to this transaction is too