Oracle

/** * string Split function. * @param p_str The string to be split * @param delimiter * @return Custom table type Ty_str_split. * Use the method select Column_value from table (Fn_split (', ', ')) * @Author: Xder */create OR REPLACE FUNCTION

??Kettle Version 4.1.0 Open the Spoon software and double-click Spoon.bat under Windows. Creates a transform. Create two data sources, one for Oracle and one for MySQL. CREATE TABLE input.

This article transferred from: http://www.cnblogs.com/wuhuacong/archive/2012/03/09/2387680.htmlThe management of data objects and data in Oracle is undoubtedly managed using PL/SQL developer, which also provides us with a lot of convenient and fast

Oracle installation processThe first time to install Oracle yourself, before the Oracle installation configuration is not understanding, and finally finished. Summarized below.1, install Oracle10gserver end2, install Oracle10gclient.Server side and

This article will start with user creation, specifically about an instance of Oracle granting user rights, and it is helpful to know that Oracle has been granted user rights.These two days in the test database synchronization software, the need to

Before using the Oracle database, I was using a MySQL database, I know that the MySQL database implementation is updated, no update, there is a statement,But Oracle's ability to do this is a moment of frustration for me, but I'm sure the Oracle

A 32-bit multi-threaded application, with many functions, similar to SQL, including variable hints and parameter passing script display, can write and run the program, using very simple, fast, good interface.Golden32 is a good helper to operate

Share an example of Oracle problem solving todayPrompt for "ora-00600:internal error code, arguments" error when starting Oracle?Sql> StartupOra-00600:internal error code, arguments: [Ksunfy:too few sessions], [9504], [75040], [], [], [], [], [], [],

"Go" usage of Oracle's SUBSTR functionOracle's use of the SUBSTR functionGets a string that specifies the starting position and length of the string substr (string, start_position,[length] )Such as:SUBSTR ('This is a test', 6, 2) wouldreturn '

Typically, we use PL/SQL developer to manage data objects and data in Oracle. If we want to quickly restore or deploy Oracle to a new machine, how to backup the database, import and restore it?Here's what we have to consider: How to create an Oracle

The programmer in the small factory also has to toss Oracle maintenance. Here's a simple record of some of the problems that the Oracle database server encountered and resolved when it was used.1. On the Oracle database server (the machine on which

----------------------Create Table--------------------------------CREATE TABLE Sms_externalsyssmsrequest(Smssendrecid VARCHAR2 () primary key NOT NULL,Sourceref number (a) is not NULL,Surveysvcno VARCHAR2 (+) NOT NULL,Surveyname VARCHAR2

Management of Oracle's tables:Naming rules for table names and columns. Must start with a letter. Length cannot exceed 30 characters. Cannot use Oracle's reserved words. Use only the following characters column_name-z,column_name-z,0-9,$, #等Data

Implementation results: Write a stored procedure under a user in a database, use Dblink to connect to another database in a stored procedure, take a number from a user in the database, and then insert a table in the current database.Two.

Download Oracle (this is no nonsense!) ）To a link, you need to register Oracle and then download it.Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.htmlUnzip the installation12c has two files, download them and unzip

http://oracleseeker.com/2009/08/12/how_to_find_the_table_view_of_oaf_application_in_oracle_ebs/The data source behind the Oaf page is more cumbersome than it is in the form, and cannot be positioned as accurately as it does, but it can also find

This question in six months ago, took me two days to solve, now just want to get up, by the way to record to prevent forgetting.With JDBC, precompiled SQL cannot be queried for fixed-length fields.To speak with an example:Create a table with only

Operating system: Windows 7Database version number: Oracle 10gVS Version number: VS2010Introduction: There are many ways to connect Oracle, here only proc Shell, explain how to connect Oracle, what's the matter, I hope you tell me to point out,

How to execute a job in an oracle session deadlock, oraclejob // Select t. USERNAME, count (*) from v $ session t group by t. USERNAME // query the SQL _id value that a user is executing select * from v $ session t where t. USERNAME = 'budget 'and t.

Remove EM, force end the EM process, start the database ORA-00119, the solution to ORA-00132 error, ora-00119ora-00132 When you use the emca-deconfig dbcontrol db-repos drop command to delete the EM database, it has not been deleted for a long time.