Oracle

I. Role of Oracle package 1. Definition and descriptionA. encapsulation of related objects (custom types, functions, stored procedures, etc.)B.ProgramEach part of the package-Package type descriptionDeclaration subroutine-Package subjectDefine

Create a data table space: Create tablespace test_dataLoggingDatafile 'e:/Oracle/product/10.2.0/oradata/testserver/test_data01.dbf'Size 32 mAutoextend onNext 32 m maxsize 2048 mExtent management local;  Create a user and specify the tablespace:

Instr (STR, CHR) --- location where CHR appears 1st times in StrInstr (STR, CHR, 3rd) --- searches for the position where the CHR appears 2nd times in STR starting from the STR character positionInstr (STR, CHR,-3, 2) --- searches for the position

Installation steps:   1. Download the corresponding real-time client package for your platform. All installations require basic or basic lite packages.2. decompress the package to a single directory, such as "instantclient ".3. Set the Database

 In the Windows enterprise operating system, uninstall Oracle 9i: 1. Stop all Oracle services (Eileenhuan supplement: after the service is stopped, uninstall 9i using the uninstall function provided by Oracle. Restart the machine !!) 2. Delete

 I. Official Website description   Http://download.oracle.com/docs/cd/E11882_01/server.112/e26088/functions088.htm#SQLRF00658  Purpose The length functionsreturn the length of char. Length calculates length usingcharacters as defined by the input

Some of the user's system permissions are directly granted, and some are indirectly granted through roles. The role can also grant direct system permissions and other role permissions. In this way, to check the user's system permissions, you must

Sometimes, we need to link the data obtained from different columns. Each database provides methods to achieve this purpose: MySQL: Concat () ORACLE: Concat (), | SQL Server: + The Concat () syntax is as follows: Concat (string 1, string 2,

Oracle form development issues (FRM-40831) Make a fund form for the project. On the query page, you can set the funds based on the date range and other conditions.Can be queried. Other fields are correct during query, butThe following error is

Oracle Database Windows/Unix differencesDifferences between Oracle databases in Windows/UNIX environments This chapter lists major differences between Oracle database on Windows and UNIX. for Oracle database developers and database administrators

In Oracle, there is no auto-incrementing field as in the MS-SQLSERVER, but there are two ways to implement this feature 1 trigger The SQL statement is as follows: Create or replace trigger trigger_nameBefore insert on your_sid.tablenameFor each

Sequence and trigger in Oracle Sequence: Sequence(Sequence) is a serial number generator. It can automatically generate serial numbers for rows in the table and generate a set of equal-interval values (in the type of numbers ). Its main purpose is

OCI and thin are two sets of Java access methods provided by Oracle to access the Oracle database. Thin is a thin client connection method. In this connection mode, you do not need to install the Oracle client. You only need to include the JDBC

In the WHERE clause, you can use the like clause with wildcards to select columns of the datetime, Char, and varchar field types... "Data records. The following are available wildcard characters:%Zero or multiple characters_Single any character

Original Author: blog garden Yihui original text: Link For DBAs, the database job is no longer familiar, because it is often necessary for the database to automatically execute some scripts at regular intervals, or to back up the database, or to

  I have been wondering about the problem of getting comments from the databasemetadata interface. I happened to check this article online, but I don't know if it is correct. I need to verify it later. When extending the ibator plug-in today, when

Generally, such simple stuff as between and won't go wrong, but I also tried this simple stuff error, it is unclear about the internal implementation mechanism of Oracle. After all, PL/SQL is the fourth generation language, and how to parse and

Processing of text fields in hibernate + spring + Oracle After N days of painstaking exploration, I finally found a solution for processing large text fields in hiberate. The configuration is as follows: Applicationcontent. xml. Note: The

    Oracle has its own unique practices for truncate table operations. It takes almost the same time to truncate dozens of data records and tens of millions of data records, Oracle only updates the data dictionary and does not operate on the actual

Sometimes we need to execute multiple SQL statements at a time, and the SQL statements used for updating are spelled out by code according to the actual situation. The solution is to splice the SQL statement into the following form:BeginUpdate tb_vg