Oracle

The oracle sequence statement may be used during development. This article describes how to reset the oracle sequence statement. For more information, see Oracle reset sequence Statement 1 SQL code Copy codeThe Code is as follows: DECLARE N NUMBER (1

The oracle table demo operation statement may be used during the development process. This article will introduce it. If you need it, refer SQL code Copy codeThe Code is as follows: -- Created on 2010/07/29 by WANGNAN Declare -- Local variables here

How can I get the maximum Date of oracle in the development application? This article will provide such a method for obtaining information. For more information, see SQL code Copy codeThe Code is as follows: -- Created on 2010/06/08 by NAN

I. Environment Description Source database: IP Address: 192.168.137.100 Sid: catalog Username: rman Password: rman Target database: IP Address: 192.168.137.101 Sid: orcl Username: rman Password: rman 2. Create a tnsname for the source database on

1 \ flash the table back to a certain time point: Enable the row movement function before the flash back operation SQL code Alter table emp enable row movement; Execute the flash back statement:SQL codeFlashback table emp to timestamp

I. Query 1. query the usage of oracle tablespace Select B. file_id File ID, B. tablespace_name tablespace, B. file_name physical file name, B. Total bytes, (B. bytes-sum (nvl (a. bytes, 0) already in use, Sum (nvl (a. bytes, 0) remaining, Sum (nvl

SQL code-- Obtain the current SCN Copy codeThe Code is as follows: select dbms_flashback.get_system_change_number scn1, Timestamp_to_scn (sysdate) scn2 from dual; -- Converts SCN to a successful time.Copy codeThe Code is as follows: select to_char

SQL code Copy codeThe Code is as follows: create table test (a VARCHAR2 (20), B VARCHAR2 (20), c NUMBER, d VARCHAR2 (20 )) Insert into test VALUES ('a1', 'b1', 1, 'T ');Insert into test VALUES ('a3 ', 'b3', 3, 'T ');Insert into test VALUES ('a4 '

As a DBA, one of the common scenarios is: Create a tablespace: Copy codeThe Code is as follows: createtablespaceThink Datafile '/u01/app/oracle/oradata/orcl/think. dbf'

If Oracle has two users A and B, if A wants to access the table owned by B, the statement should be: Copy codeThe Code is as follows: SELECT * from B. TABLENAME. I want to ask, can I modify the Oracle settings to change the language in which A

Serveroutput is the configuration parameter of sqlplus, not the configuration parameter of the database. Modify and save the Configuration Parameter of sqlplus, so you do not need to reset it every time you open sqlplus. The setting method is as

1. Add a text box to the corresponding position in the report page layout, which is generally Download Right-click a link in the PL/SQL editor and add the following content: Copy codeThe Code is as follows: function B _13FormatTrigger return boolean

This article describes how C # connects to the Oracle database. Through the Oracle. DataAccess. dll in instant client and ODP.net, We can conveniently deploy. net applications or sites without installing the Oracle client. Next we will introduce

1. Basic Concepts Two features: complete the constraints of complex business rules that are difficult to complete due to database integrity constraints; monitor various database operations to implement audit functions. Triggers are divided into:

Learning oracle 10g r2 concepts in the afternoon Leave a note here. Oracle manages the storage space in the database data file. The unit is data block ). A data block is the smallest (logical) data unit in a database. The minimum physical storage

Recently, many projects require batch operations. The client passes a set of IDS separated by commas (,) to the database, and the stored procedure needs to separate them and process them one by one. The previous processing methods are as follows: 1.

TO_DATE format (take the time: 2007-11-02:45:25 as an example) Year:Yytwodigits two-year display value: 07Yyythreedigits: 007Yyyyfourdigits four-digit year display value: 2007 Month:Mmnumber: 11Monabbreviated Character Set indicates the displayed

Oracle stored procedure basic syntax Stored Procedure1 create or replace procedure stored PROCEDURE name2 IS3 BEGIN4 NULL;5 END; Row 1:Create or replace procedure is an SQL statement that notifies the Oracle database to CREATE a stored PROCEDURE

Last week, I wrote an article on connecting the oracle client to the server, solving the troubles of installing it in my own book. In the past, my computer and server were in the same LAN, so every time they were remote servers, they were not the

To sum up the basic knowledge of oracle, oracle is composed of instances and databases. The structure is as follows: Oracle databases consist of instances and databases: * A database consists of data files (including oracle Data, indexes, table