Oracle

Select * from V $ nls_parameters; SQL> alter session set nls_date_language = 'simplified Chinese '; Session altered SQL> select to_char (sysdate, 'yyyy-mon-day') from dual; To_char (sysdate, 'yyyy-MON-DAY' ------------------------------

The following shows an implementation method of Oracle. Two steps are required: 1. Create sequence create [or replace] sequence sequence_identity start with initial seed increment by step maxvalue upper bound [nomaxvalue] nocycle [empty] 2. Create

Delete a user using the Oracle command line: CopyCode The Code is as follows: connect/As sysdba; Shutdown abort; Startup; Drop user user1 cascade; Exit Oracle command line User Creation: copy Code the code is as follows: create user user1

If you have a cold backup, but one of the data files is missing, but you have all the archives, if you want to restore the data files, you can refer to the following example: CopyCode The Code is as follows: [Oracle @ jumper eygle] $ sqlplus "/As

The update in an oracle SQL statement can be used with sequence to update the continuous numbers of values of a field without having to traverse and update database records one by one using a cursor. For example, update Sample Set ID =

Insert view conditions: 1. if a view is generated based on a basic table, this is called a non-join view. All non-join views can be updated, that is, they can be performed on the view, insert, update, delete operation. 2. for a connection view,

We all know that before 9i, It is very troublesome to obtain statements for creating tables and indexes. We can use export with rows = No, but its output cannot be used directly due to format issues. Another method is to write complex scripts to

In general, there are not many chances to use fetch in batches, but we 'd better get familiar with this feature provided by Oracle, and maybe it will be used at any time. CopyCodeThe Code is as follows: declareCursor C1 is select * From t_depart;

[Q] How to query special characters, such as wildcards % and _ [Q] how to insert single quotes to database tables [Q] how to set transaction consistency [Q] How to Use the cursor to update data [Q] How to customize exceptions [Q] convert

Configuration environment: 1. Data Base: Oracle 8i R2 (8.1.7) for NT Enterprise Edition 2. installation path: C: Oracle Implementation Method: 1. D:> set nls_lang = american_america.usacii7 Or D:> set nls_lang = american_america.we8iso8859p1 D:> set

Machine: Select instance_name from V $ instance; Select name from V $ database; Select name from V $ datafile; Log query mode: Archive log list; Shutdown immediate; Startup Mount; Change the log archive mode: Alter database archivelog; Alter

This brings many benefits, but it also requires learning new concepts, commands, usage, and management tasks. So before you invest in your production system, let's look at what it solves, what it manages, and what it looks like. Why create it? The

-- Create an incremental Sequence Create sequence lzeam_sp_loop_eq_seq minvalue 1 increment by 1 start with 1 Test: Select lzeam_sp_loop_eq_seq.nextval from dual -- Create a trigger Create or replace trigger lzeam. lzeam_sp_loop_eq_trigger

1. Start-> Settings-> Control Panel-> management tools-> services Stop all Oracle services. 2. Start-> Program -> Oracle-orahome81-> Oracle Installation products-> Universal Installer Unmount all Oracle products, but the universal installer cannot

Once the Oracle database is successfully installed, the related database information is displayed: Global Database Name: Oracle System identifier (SID): Oracle Server parameter file name: C: \ oracle \ product \ 10.2.0 \ db_1/dbs/spfileoracle. ora

Create or replace procedure procsendemail (P_TXT VARCHAR2,P_SUB VARCHAR2,P_SENDOR VARCHAR2,P_RECEIVER VARCHAR2,P_SERVER VARCHAR2,P_PORT number default 25,P_NEED_SMTP int default 0,P_USER VARCHAR2 default null,P_PASS VARCHAR2 default null,P_FILENAME

(1) OracleServiceSID Database Service, which automatically starts and stops the database. If a database is installed, its default start type is automatic. The service process is ORACLE. EXE, the parameter file initSID. ora, the log file SIDALRT.

1. Basic StructureCreate OR REPLACE PROCEDURE(Parameter 1 in number,Parameter 2 IN NUMBER) ISVariable 1 INTEGER: = 0;Variable 2 DATE;BEGINEND stored procedure name2. select INTO STATEMENTSave the select query result to a variable. You can store

Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Many database administrators are concerned about how to maintain excellent performance of Oracle databases. Based on my experience, we

Recently, due to insufficient hard disk space in the unit database, I checked many articles and tested them. I learned some experiences for your reference. First, I saw an article on the internet, how to Shrink Undo tablespaces and release space