Oracle

1. Enter Excel Test form, Test.xls.2. Save As. csv format3. Create the Sql*loader control file Test.ctl, which reads as follows:Load dataInfile ' C:\test.csv 'Insert INTO table test fields terminated by ', '

One, theOracle data dictionary is composed of the following views mainly:1.user ViewUse User_ as a prefix to record information about user objects2.all ViewAll_, which is used to record the information of the user object and the object information

Source: http://www.cnblogs.com/ningvsban/p/3603678.htmlThere is a new feature in ORACLE 11G that does not allocate segment when the table has no data to save space.Workaround:1) Insert a row, and then rollback will produce segment.The method is to

Sql> Select COUNT (*) from V$session #连接数Sql> Select Count (*) from v$session where status= ' ACTIVE ' #并发连接数Sql> Show parameter Processes #最大连接Process: This parameter limits the number of operating system processes that can connect to the SGA (or

1, use the following statement to find the locked table name, osclient, session informationSELECT B.sid, b.serial#, the D.spid OS system is number, C.object_name is locked in the name of the image, B.username logged in user, the b.schemaname is

Need to use a geoserver to combine with Oracle to display GIS informationResults when the layer is displayed, tomcat errorsAfter querying the data, we need to establish a spatial indexWhen you create an index, you don't know what to name and which

--oracle:declare n_count int;begin Select Count (*) into N_count from from m_test where entitylsh = 1; Dbms_output.put_line (N_count); End --sql server:declare @is_exist_alert3 int; Select @is_exist_alert3 =count (*) from m_test where Entitylsh =

Java usesJdbc:oracle:thin:@11.1.0.14:1521:orclConnecting to an Oracle database appears:Ora-12505,tns:listener does not currently know of SID given in Connect descriptorError.Indicates that a service with Sid ORCL on the server does not exist and can

Stored procedures are in a large database system, a set of SQL statements to complete a specific function, stored in the database, after the first compilation after the call does not need to compile again, the user by specifying the name of the

Queries are the most frequent accesses made on a table.When querying data, few users are willing to query all the data in the table, unless the entire table is processed.In general, users are always querying a subset of the data in a table.In a

WIN8 [INS-13001] environment does not meet minimum requirements when installing Oracle 64-bitCause of the exception11.2.0.1 is released earlier than Win8, so the compatibility List cannot be compatible with Win 8.Workaround OneOpen the CMD input CD

Configure local Yum Source [[email protected] ~]# cd /etc/yum.repos.d/ [[email protected] yum.repos.d]# [[email protected] yum.repos.d]# vi local.repo [Local] Name=local baseurl=file:///mnt/Server enable=1 gpgcheck=0 [[

What if we forget the user's password for the Oracle database and do not know the password of the user who is larger than the user's rights?Don't worry, as long as you have installed the database server operating system users, then you can easily

1. Table namingL name best words too literally, avoid using database keywordsL Name all uppercase letters (or lowercase, do not write large mix)L The singular name of the English word. Example: FACTORYL NAME the English word abbreviation. Example:

1,sql Server sequence creation and useBeginif EXISTS (SELECT * from sysobjects WHERE name = ' event_seq ') DROP SEQUENCE event_seqendcreate SEQUENCE Event_seqminva LUE 1MAXVALUE 999999999999999999START with 1INCREMENT by 1CACHE 20; --Goselect Next

PL/SQL Basic structurePL/SQL data type Numeric type: Number (p,s), Pls_integer, Binary_integerCharacter types: CHAR, NCHAR, VARCHAR2, NVARCHAR2, LONGDay Type: DateBoolean Type: BooleanDefine data type: typeType is ;Data type: Oracle allows you to

★ First define the several parameters that will be used for the paging statement: int currentpage ; Current page int Pagerecord ; Shows the number of records per page Take the previous AddressBook data sheet for example (10 records

Oracle sequence understanding and creating a self-augmented primary keyOracle Sequence PRIMARY KeySequence: is a database object provided by Oacle to produce a series of unique numbers.L automatically provide a unique valueL Shared objectsL mainly

Create or Replace function f_split_condition (start_string VARCHAR2, V_flag VARCHAR2)/*** Replace the given START_STRINGN string with a comma-delimited string by V_flag* For example: 12-34-56 replaced with ' 12 ', ' 34 ', ' 56 '* Use loop Loop to

Not how to use Oracle, and is in the local government rent intranet internal estimate is the cause of the firewall is not even in the virtual machine Oracle, just start a lot of trouble to find problems, and now give up the use of direct database,