Oracle

There is no split function in PL/SQL and you need to write it yourself.Code:Create or replace type Type_split as Table of VARCHAR2 (50); --Create a type, and if you want the split function to be generic, set its size larger.--Create functionCreate

We all know that after the Oracle database installation, the default will have such a number of system roles or permissions, Nomal,sysdba,sysoper, and so on, each time you log in to Oracle, is directly logged in as Conn/as sysdba, But I never knew

Title, Preliminary discussion on Oracle delete duplicate records, keep only rowid minimum records (ROWID can reflect the order in which data is inserted into the database)There are several ways to delete duplicate records, and the following are just

The ToChar (sysdate, ' D ') function was encountered while learning Oracle, but the discovery was not a day of the week, as today is 20150317, Tuesday, but the resulting value is 3Started thinking it was the system date what's the reason that

1 because the eight reports of the crosstab are written in SQL , each report corresponds to a SQL statement that has more than one row, and cannot define the view because a parameter must be passed So we took advantage of the stored procedure

I. INTRODUCTION of Index1. Index equivalent to Directory2, the index is a set of sorted index keys to replace the default full-table scan retrieval method, so as to improve retrieval efficiency.3, the creation of the index to moderate, more will

In Oracle, data from one table is copied to another object. There are usually two ways of doing this: INSERT into select and select into from.The former can copy a select of n rows (0 to any number) result set into a new table, which can only copy

Declaring a cursor variable EXEC SQL BEGIN DECLARE section;Sql_cursor Emp_cursor;Sql_cursor Dept_cursor;EXEC SQL END DECLARE section;After this definition, if you want to allocate resources before using allocateEXEC SQL Allocate:emp_cursor;EXEC

Installing Oracle Java on Ubuntu1. Download the latest Java version of the compressed package from Oracle website2. Unzip "TAR-ZXVF Tarball_name3.sudo Mkdir/usr/lib/java4.MV jdk1.8.0_40 to/usr/lib/java/5. Execute the following command linesudo

How Oracle can update newly inserted data with trigger implementation Collection1, establish the test tableCREATE TABLE TEST_TB(ID number,WLID number,PM VARCHAR2 (100),Djzt VARCHAR2 (10),SL number,PH VARCHAR2 (100));2. Set up the package and the

This article focuses on the use of DBMS_LOB packages in Oracle databases and the basic approach to maintaining LOB database types using DBMS_LOB packages. With the development of the society, in the development of the modern information system, the

In Oracle, it is sometimes used to return a result set with a function, and here is the demo:Create or replace type T_test as Object(ID Integer,Create_time date,object_name VARCHAR2 (60));Create or replace type t_test_table as table of t_test;1.

1. First write the download () method under Citycontroller1 Publicactionresult DownLoad ()2 {3 /*the virtualpath here indicates which file you want to set up for download. 4 In the project, the system always defaults to the

As the number of rows in the table increases, so does the impact of management and performance performance. Backups will take more time, recovery will take more time, and queries over the entire data table would take more time. By dividing the rows

Select Initcap (' Smith ') Upp from dual; --Initial capital Initcap ()Select Concat (' 111 ', ' 222 ') | | ' 333 ' phone from dual; --Connection string method Concat (,)Select ' 111222 ' | | ' 333 ' phone from dual;Select InStr (' oracleeetraning ',

VARCHAR2 (size) variable length character type (maximum character)NVARCHAR2 (size) variable length unicode character type (maximum character)char (size) Word length character type (maximum character)Number (p,s) numeric (p is the maximum length, s

In Oracle, user-related configuration information can be obtained through the Fnd_profile package and the FNDSQF library, which can have the following two applications:1. Gets the value of the relevant profile for the user in the current running

Oracle start/Close scott unlock Login After the oracle database is successfully installed, the following problems occur for the first time,   Here, we only provide three methods: L SQL * plus L OEM Console L Windows Console 1. Take the windows

Authorization for CONNECT, RESOURCE, and DBA in ORACLE CONNECT, RESOURCE, and DBA are the three built-in roles of the ORACLE system. The role permissions are as follows: CONNECT: users with the Connect permission can only log on to ORACLE, create

Modifying Instance name SID in OracleModify the ORACLE Instance nameSystem Environment: CentOS 6.5ORACLE version: 10.21. Check the original database instance name$ Echo $ ORACLE_SIDOrcl$ Sqlplus/as sysdba> Select instance from v $ thread;INSTANCE----