Oracle

When inserting a text or an HTML string directly through an INSERT statement, more than 4000 characters are reported:ORA-01489: String concatenated result is too longAlthough the field is CLOB, it is sufficient to store it, but by this direct

In the process of development, it is often not necessary to install Oracle on their own computers, it is too big.Here is a way to connect to Oracle using Plsql, similar to the Navicat connection to MySQL.First download plsql, install, here is a

A stored procedure is a named PL/SQL program block that can be given parameters, stored in a database, and can be called by a user. Since the stored procedure is compiled code, it is not necessary to compile again at the time of the call, which

Syntax for building functionsCreate or Replace function name (parameter input or output parameter type) return data typeis return value data type of return valueBeginAction to be done by the functionEndSQL Statement Demo:Create or Replace function

Lsnrctl (Listener control) is a sql*net tool for controlling database Listener, which provides control of command Listener start, stop, view Listener status, change Listener configuration parameters.Lsnrctl IntroductionEnter LSNRCTL on the command

Performance tuning is a task that every DBA can encounter in his careerBig to the World 500 strong core system, small to the township enterprises of the invoicing, almost will have to tune the timeFaced with a variety of systems, a wide range of

1. Find all indexes of the table (including index name, type, constituent column):Select T.*,i.index_type from User_ind_columns t,user_indexes i where t.index_name = i.index_name and t.table_name = I.tabl E_name and t.table_name = table to query2.

Https://workforce.oracle.com/pls/wdp_ekit/rd_psp_find_member0;Oracle the official website of the search address, go in and choose China, will be able to find all the current Chinese WDP center operating Companies , official website and other

PL/SQL subroutine it contains functions and procedures. This function refers to a user-defined function. And the system functions are different. subroutines usually complete a specific function PL/SQL block. , can be called multiple times by

Stored Procedure creation Syntax:Create or Replace procedure stored procedure name (param1 in type,param2 out type)AsVariable 1 type (value range);Variable 2 type (value range);BeginSelect COUNT (*) into variable 1 from table A where column name

Querying Oracle with Python is, of course, best used with the Cx_oracle library, but sometimes constrained to install Python's third-party library, you have to leverage existing resources and bite the bullet. Call Sqlplus in Python to query Oracle,

View v$session_wait can be used to view the current wait events for the system and information about the resources that correspond to the wait events, thus identifying the type of bottlenecks and their objects. V$session_wait's P1, p2, and P3 tell

I. Process (stored procedure) A procedure is a subroutine that can perform a specific operation. Create or replace a subroutine that is saved in the database by using the creates or replace.Example 1: declaring a stored procedure that

First, download: http://www.oracle.com/technetwork/topics/winsoft-085727.htmlDownload the corresponding version according to your actual needs.Two, configureUnzip the downloaded instantclient-basic-win32-11.2.0.1.0 compressed package into the

Oracle Linux, known as Oracle Enterprise Linux, is one of the oel,linux releases. Oracle launched its first release in early 2006 to better align Oracle software and hardware support. OEL, commonly referred to as Oracle Enterprise Linux, because

LOB, or large Objects (large object), is a data type used to store large amounts of binary and textual data (a LOB field can store up to 4GB of data).There are two types of lobs: internal lob and external lob.An internal LOB stores data in the form

The second day of Oracle learning --- use of Profile, oracle --- profile Environment: Oracle 11g 1. Transfer Permissions 1. If the object permission is passed, add with grant option later; Eg: If the system user has a temp table and only wants the

SQL: Oracle11g table, view, stored procedure structure query, oracle11g Stored Procedure -- GetTablesSELECT owner, object_name, created FROM all_objects WHERE (owner in (select USERNAME from user_users) AND object_type = 'table' order by owner,

Solution to the ORA-31684: object type already exists error when importing data with impdp Data Pump in oracle When importing data using the impdp Data Pump in oracle, if a user has been created before the import, an error is prompted: ORA-31684:

Oracle (1) --) Detailed description of database objects (Text explanation, first of all a small understanding ~)---- Database object: a set of logical structures ---- 1. Synonym: alias of an existing object/* function: simplify the SQL statement to