Oracle

Oracle BIEE uses a custom text format for the columns in the report, where you can fill in the HTML code. Assuming that the report is shown on the right, the following are examples of country IDs:1. Pass the value of the country ID column to the

Static registrationChange the 1521 port in Listener.ora and Tnsnames.ora to 1421, it is very simple Dynamic registration2.1 Change the port in the Listener.ora file to 1421LISTENER =(Description_list =(DESCRIPTION =(address= (PROTOCOL = IPC)

The meaning of several Oracle nameDb_name:Database name: Show parameter Db_name,db_name There is also a very important role is to dynamically register the monitoring, whether or not specified service_name, or the value of service_name, Pmon will use

A few days ago with Oracle write stored procedures, found in stored procedures to write update, insert or DELETE statements will compile errors,Then inadvertently found a solution,Add EMP to represent the Scott user, if you create a stored procedure

Oracle 11gR2 cannot export empty table solution with exp in the 11gR2There is a new feature that does not allocate when the table has no datasegmentto save space,Oracleof course, in execution .Exportwhen exporting, empty tables cannot be exported,

 How to avoid a long time without logging in again(English environment) 1, set the value of the profile icx:session timeout to null 2, the icx:limit time setting slightly larger, such as 8 hoursProfile Description:icx:session TimeoutThis profile

Dbnewid is a tool that Oracle provides to modify database dbid and dbname.Before we introduce this tool, we must rebuild the control file if we want to change the database name of the database. However, it is not possible to modify the dbid of the

1) Change the date display type of the results queried in SQL developer in Oracle 11g R2, that is, the setting of the session date type:Alter session Set Nls_date_format = ' Yyyy-mm-dd HH24:MI:SS ';Oracle Plus fields:ALTER TABLE operator_daily Add

with the SQL statement, delete duplicates only keep one in thousands of records, there are some identical records, how to use SQL statements, delete duplicates1, duplicate records in the lookup table are judged by a single field (Peopleid) .Select *

1. Create an object:Create or replace type sys_col_id as Object (ID number (38))2. Define an arrayCreate or replace type Sys_tbl_ids as table of sys_col_id3, calculate the length of the delimiter, usage: splitter_count (' 1,2,3,4 ', ', '), return

/*TRUNC (Number,num_digits)Number requires a truncated rounding.The num_digits is used to specify the number of rounding precision. The default value for Num_digits is 0.TRUNC () function is not rounded when truncated*/The use of the--oracle trunc ()

Table connection refers to a SQL statement through the Relationship between table and table, from one or more tables to retrieve the relevant data, the main table and the connection between the table can be divided into four kinds, respectively,

Environment: aix7.1+oracle RAC 11.2.0.3Migration Description: Today in the installation of Oracle RAC, the wrong 500G data disk as a OCRDG, then later more trouble, only to speak OCR and Votedisk migrated to the new OCRDG, and DATADG deleted and

Statement **********************************************Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.Please leave a message or email ([email

Why didn't I hit Racdatabasehome during oracleraco patchauto?First explain the environment: OS: AIX 7.1Oracle version: Oracle Rac 11.2.0.3 before the release of the 11.2.0.3.9 Patch Set, Rac is not officially used, so simply hit the latest 11.2.0.3.1

Oracle Database experience series-Article 11) change the date display type of the query results in SQL developer in oracle 11g r2, that is, the setting of the session date type:Alter session set nls_date_format = 'yyyy-MM-DD HH24: MI: ss ';Oracle

Linux/centosoracle10g control connection IP AddressOracle controls the IP address of the connected database Simply set allowed IP addresses and prohibited IP addressesIn 9i and later, modifying sqlnet. ora is actually the best and fastest way. 1:

Deferred_segment_creation usage in Oracle and exp Solutions SYS @ ORCL> show parameter segment NAME TYPE VALUE-----------------------------------------------------------------------------Deferred_segment_creation boolean TRUERollback_segments

Oralcesql creates calendar information for a specified period of time The creation start time is 2010 and the end time is 2100. Create table temp_calendar as selectMin (to_char (day, 'yyyymm') month, To_char (min (decode (weekday, 1, day), 'dd') w_7,

Oracle session and connection Optimization 1. Modify the Oracle session and maximum number of connections 1. view the maximum number of connections SQL> show parameter processes; NAME TYPE VALUE--------------------------------------------------------