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' ------------------------------

Write a circular deletion process. Create or replace procedure delbigtab (p_tablename in varchar2, p_condition in varchar2, p_count in varchar2) As Pragma autonomous_transaction; N_delete number: = 0; Begin While 1 = 1 Loop Execute immediate

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,

Today I found a good website that displays Oracle syntax. If there are too many contents, we will not extract them one by one. Record them here for your convenience. Http://www.ss64.com/ora/ The directory is as follows: An A-Z index of Oracle

It is very important to develop a database application and select a good database. This article compares three types of databases: SQL Server, Oracle, and DB2. It provides some reference for you to select a database. Openness SQL ServerIt can

First, create a stored procedure get_clob: T_name: name of the table to be queried; f_name: name of the field to be queried; u_id: Primary Key of the table, query condition; l_pos: Start position of the truncation; l_amount: truncation

However, there is a simple method to execute the CMD command: SQL> host net user User Accounts for \ PC-ATQHJ4UG1SDA ---------------------------------------------------------------------------- _ Vmware_user _ admin Administrator ASPnet guest

The ORACLE tutorial is: parsing the planned Stability of Oracle 8i/9i. Starting from Oralce8.1, Oracle has added a new feature called Stored Outlines, or Plan Stability ). This feature brings three benefits. First, you can optimize the processing of

The ORACLE tutorial is: how to determine the repeated records of Oracle database tables. As an Oracle database developer or DBA, you will often encounter this problem in practice: when trying to create a unique index for a column or several columns

(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.

Recently, many people in the group have discussed oracle Security Issues. Today I have found some materials to learn more. Obtain the attributes of the current Oracle SESSION (useful for determining the SQL Injection environment) The SYS_CONTEXT

//************************************** *********************************// Function name: of_zy_yzfy for n_medicare_minihis// Function Description: Submit the doctor's advice when the doctor's advice is entered// Function parameters:// 1.

Conversion of date and time in c shell perl php: seconds and human readable date scalar localtime and seconds since '00: 00: 00 1970-01-01 UTC' Scalar localtime 26-byte string and seconds since '00: 00: 00 1970-01-01 UTC' (The number of seconds

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

The ORACLE tutorial is: Oracle Data Table Partitioning policy. This article describes the table to be partitioned by the hospital information system through statistical analysis. Select the partition key for the table to be partitioned, that is,

The ORACLE tutorial is: Comparison between Oracle and SQL Server in enterprise applications. My company not only owns Oracle databases but also SQL Server databases, so I often encounter two problems that people ask me. The first is usually "can

The ORACLE tutorial is: Oracle-based object-oriented technology basic analysis of the developer's network Oracle. I. Overview An object is a new feature of Oracle8i and later versions. An object is actually an encapsulation of a set of data and

The ORACLE tutorial is: Research on the backup and recovery policies of Oracle databases. Abstract restoring lost database files depends largely on the backup policy used. Based on the flexibility of recovery, this article discusses the backup and