Oracle

Use of the To_date () function in a 1.Oracle database: Insert a record into the EMP table:Sql>InsertInto EMPValues1234,‘Lizelu‘,‘BOSS‘,1234,‘1980-12-06‘,10000.0,0,30);InsertInto EMPValues1234,‘Lizelu‘,‘boss " ' 1980-12-06 ", Span style= "color: #8000

(Note: This digest is from http://www.linuxidc.com/Linux/2012-04/59322.htm)Start learning Oracle, so we're going to install Oracle 10g today. After the installation is done to test whether the normal work.During the installation process, the

"This article describes"Once you are familiar with PL/SQL syntax, implementing Java calls to Oracle stored procedures is the primary purpose. This article describes how to write stored procedures, and how Java calls stored procedures."Introduction

The Dbms_random package in Oracle encapsulates a number of functions that generate random numbers and random strings, which are commonly used in the following two:Dbms_random. VALUE function This function is used to produce a random number in two

1. The concept of tablespaceNone of the previously contacted databases have ever heard of the word tablespace, and the table space was found everywhere in the previous time when the Oracle database was seen. So tablespaces should be a very common

Long is a type of special1, a Long data type is stored in a variable length string, the maximum length limit is 2GB.2, for the text beyond a certain length, the basic can only be stored with a long type, the definition of many objects in the data

Installing Oracle Maybe some people think that is a very simple thing, but in fact, in the process of installation contains a wealth of knowledge, especially installed on the Linux platform, you may encounter such a variety of strange problems,

1. Copy the libflashplayer.so plugin to the path: ~/.mozilla/plugins/.2. Open Firefox and enter about:config in the Address bar. Enter Plugin.expose_full_path in the Filter field. Set true to enable this option. (The address bar enters About:plugins

IMPORTANT: Alter DATABASE guard none;-----------------------------------------------------DBA User Build Table-----------------------------------------------------Sql> CREATE TABLE Liang.testa as select * from Tab;Table created.----------------------

Some time ago learning Oracle To do the study notes, organized a bit, the following is a share of the Oracle common functions of some notes, and later will share other parts of the notes, please criticize correct.Use of the To_date () function in a 1

http://blog.csdn.net/huangwuyi/article/details/7407820First, the function1, take the whole mod (2,10) =22, take the whole trunc (12/10) =13, take the whole ceil (12/10) =24, NULL (NULL) specifies a value NVL (null,9) =95 cumulative sum (piece) =88347

Oracle cannot support directly returning a table type like MSSQL, so create a custom type first. This is used for nested tables (Nested table).--Nested tablecreate or replace TYPE split_str is TABLE of VARCHAR,/--functioncreate or replace FUNCTION

1. Connect to the database using the SYS as SYSDBA method exp/impWindows environment:Exp 'sys/[email protected] as Sysdba' file=exp.dmp log=exp.log #注意这里是单引号UNIX and Linux environmentsExp \ 'sys/[email protected] as sysdba\ ' file=exp.dmp

1. System Kernel parameter setting Cat >>/etc/sysctl.conf RHEL 6 Shmall and Shmmax are configured to use the default settings, Shmmax is generally set to half of the system memory, 4195057664=4GB After modification, the Execute command takes effect:

One, scalar data types1, varchar2 (size) nvarchar2 (size) variable length string2, char (size) nchar (size) fixed-length string, where n begins with a character set that stores internationalized strings to support multiple languages.3. Date

OS authentication1. In Sqlnet.ora (located in the $oracle_home/network/admin directory) file, use VI Edit to comment out the #sqlnet. Authentication_services = (NONE) the row. 2. Check whether the current OS user belongs to the DBA group.3. Execute

 1 %TYPE description in order for the data type of one variable to match the data type of another variable that has already been defined, in particular a column of the table, Oracle provides a %TYPE define the way. When the data type of the

--Create a tableCreateTableSx04_lbalance (YearVARCHAR2 (10)NotNull, ProgramnoVARCHAR2 (40)NotNull, FDateVARCHAR2 (10)NotNull, FacctcodeVARCHAR2 (50)NotNull, FcurcodeVARCHAR2 (3)NotNull, FaacccreditNumber (19,4)Default0NotNull, FaendbalNumber

Tag:oracle    view process     No. 06 Lecture  chapter 03--managing an oracle instance--learning process: $ id$ sqlplus / Nologsql> conn / as sysdbasql> startupsql> !$ ps -ef|grep  oracle   last view process-Knowledge point:initialization parameter 

Use the tool plsqldev to import Excel to the Oracle database, plsqldevoracle 1. Use the tool plsqldev 2. Open the excel file to be imported, click the office button, select Save As-other format, select Save type CSV (separated by commas) (*. csv),