Oracle

CREATE OR REPLACE FUNCTION "Ufn_split" (p_list varchar2, p_sep varchar2: = ', ') return type_split pipelined      is L_idx Pls_integer;       V_list varchar2 (4000): = P_list;       V_num number (18,0): = 1;   O_tablesplit Obj_tablesplit; Begin

 Single-line function①. Character functionsLOWER (x): Converts each word in X to lowercaseUPPER (x): Converts each word in X to uppercaseInitcap (x): Converts the first letter of each word in X to uppercaseCONCAT (x, y): Used to add y to X, with |

Recently learned a materialized view, just as the manager is not, the results of the study posted for everyone to study it.Let's take a look at the general meaning of materialized view, feel the definition of Baidu is goodBaidu Code

Oracle Services start & Stop scripts with boot. Oracle installation directory and environment:   installation directory:/hywl/oracle/app/product/11.1.1/db_1 in CentOS 6.5 After installing the Oracle 10g R2, after rebooting, you will find that

Recent data processing often found that there are many characters in the number, the execution of the process reported "Ora-01722:invalid number" exception, organized a bit, can be removed by the following methods: 1, replace use simple, the wording

First, install the configuration Oracle ClientTo access Orcale data, the Oracle client must be installed on the client machine that is accessed.Orcale has two forms of client:L Complete ClientThe Microsoft OLE DB provider that includes basic Oracle

Use DateOracle Internal use digital storage date: century, year, month, day, hour, minute, second.The default date display format is DD-MON-RR.--You can specify only the post-two bits of the year, allowing the 21st century date to be stored in 21st

http://blog.csdn.net/leshami/article/details/23763963Index reconstruction is an issue that has been hotly debated. Of course, Oracle has its own views, and many of our DBAs follow this guideline to rebuild the index, which is that Oracle recommends

For the Oracle database, in order to ensure the security of data, we need to set up the database of the Recycle Bin function, the default function is open. We can view and modify them through the following steps1 See if the database has a Recycle

Found online silent installation of many articles, a mess, a variety! Let's get a literacy!Install Oracle 11g_r2******************************************************************************1. System section under CentOS 5.10 * ------1. Installing

Oracle is the big guy for OLTP, and it's used by many industry applications. So in the process of development of the inevitable use of Oracle database, Oracle database version has a lot of, where the Express version is a free development version,

"E Mentor Network" new version of Oracle database release no doubt many of the companies that use will want to update the upgrade, but former Oracle employee Kevin Closson reminds you to upgrade the latest Oracle Database 12c 12.1.0.2 before you

First, row to columnThe following format is requiredConvert to:This is the most common row-to-column, the main principle is to use the Decode function, aggregation function (sum), combined with the group by group implementation of the[SQL]View

Today 4 o'clock in the morning, the person in charge of the scene of the customer called me, said very strange, the download function is fast and slow. This download is very complex, and I've been optimizing it before, turning on the computer in

I. OverviewWe know that in Oracle, every modification of a piece of data produces a redo (that is, redo, which records the modified content). The goal is to back up the modified data to facilitate future re-work. Now there is a problem. Whenever

Oracle has its own Dblink function, which is to logically treat multiple Oracle databases as a single database, meaning that objects in another database can be manipulated in one database, for example, we create a new data database1, We need to

Issue: ORACLE 11g exports a user's own table with the EXP command export and IMP imports 10g found empty table cannot be exportedCause: 11g When you start to build a table, segment is not assigned by default to save space, and when the table inserts

The script consists mainly of the following parts:Awr.sql the script that is used to execute in Sqlplus, which is found directly from the Web.Awr.sh is used to call Sqlplus to generate an AWR report.Ftp.sh is used to package and compress the AWR

Data Import from oracle to mysql (applicable to the mutual import between any data sources) To release some resources in the production database, you need to migrate the API module to mysql and export data. When I tried the oracle to mysql tool,

Add and read comments to tables and columns in ORACLE Add and read comments to tables and columns in ORACLE1. Add a comment to the table: SQL> comment on table name is 'table comment "; 2. Add a comment to the column: SQL> comment on column table.