Oracle

Windows, using Plsql inserted Chinese data garbled problem, the Internet to find the next solution, using the following method to solve the garbled problem, organized as follows:Chinese garbled code is the result of a non-uniform, the solution only

Here are Some of the concepts that I learned from my own understanding of Oracle, which may be the wrong cognitionA database can be built using the graphical interface at 1.windowsSee Baidu: Http://jingyan.baidu.com/article/90bc8fc80c01f2f653640c1f.

First, restart the Oracle database and listener under Linux:Method 1:Log in to Linux with root SSH and open the terminal to enter the following command:CD $ORACLE _home #进入到oracle的安装目录Dbstart #重启服务器Lsnrctl Start #重启监听器CD $ORACLE _home

MySQL stored procedures(1). FormatFormat created by the MySQL stored procedure: CREATE PROCEDURE procedure name ([process parameters [,...]])[Features ...] Process BodyCase Analysis:ParametersThe parameters of the MySQL stored procedure are used in

1), sorted by pinyin first letterSELECT * from T_table ORDER by Nlssort (NAME, ' nls_sort=schinese_pinyin_m ');2), Sort by strokeSELECT * from T_table ORDER by Nlssort (NAME, ' nls_sort=schinese_stroke_m ');3), by radical sortSELECT * from T_table

First, the phenomenon of database deadlockDuring the execution of the program, click OK or save button, the program is not responding, there is no error.Second, the principle of deadlockWhen you perform an update or delete operation on a column of a

The difference between Oracle and SQL Server:1, the modification operation to take a commit, or the data is simply viewed, not the data submitted2,oracle cannot view data using the Select field as a viewing method;The 3,oracle stored procedure can

LOGMNR needs to be installed before it can be used.Installation steps: Install with the SYS user log-in execution of the following script@ORACLE_HOME/rdbms/admin/dbmslm.sql@ORACLE_HOME/rdbms/admin/dbmslmd.sql Pre-use steps:Set system

(1)Select To_char (123.56, ' 999.9 ') from dual; would return 123.6Select To_number (' 123.56 ', ' 999.9 ') from dual; Would fail because of error "ora-01722:invalid number"(2)Select To_char (123.56, ' 999 ') from dual; would return 124Select

Start and stop OracleStop and start Oracle needs to be switched to Oracle user only, no other user has this permissionRun Sqlplus but don't log in to Oracle:sqlplus/nologConnect to the Oracle server with the privileges of the system administrator:

First, refer to the Oracle namespaceSystem.Data.OracleClient;Second, connect the database code: Private DataTable SqlHelper (string commadtext) { try { //through configuration file, connection

Ora-01422:exact fetch returns more than requestedThe magical mistake that bothered me an afternoon.Problem Description: Obviously only a row of records, the result is a number of records reported errors. I can't think of the solution,There is no

Create the user with the following statement: 123 createuser shopping identified by shopping--用户名为shopping，密码为shoppingdefault tablespace shopping --默认表空间为shoppingtemporarytablespace shopping_temp; --默认临时表空间为shopping_temp

System version redhat5.6A pre-installation environment configurationView Memorygrep memtotal/proc/meminfogrep swaptotal/proc/meminfo(or free-m simultaneously view memory and swap space, generally need memory 2g,swap space 2G)Modify the user's shell

The latest set of production library table space has been alarm over 90%, but the disk hardware resources are not enough, the entire library has reached 26T. The library stores nearly 4 years of data, and business communication that historical data

1. Initial enable ASM automatic Storage driver error, module not found[Email protected] desktop]#/etc/init.d/oracleasm ConfigureConfiguring the Oracle ASM Library driver.This would configure the On-boot properties of the Oracle ASM LibraryDriver.

First, regardless of import and export to create a directory1. Create a DirectoryCreate directory My_dir as ' d:\yth';--Generate directories (you must create a folder at the specified location, preferably in the same name as the user name)Yth: is

Start and stop OracleStop and start Oracle needs to be switched to Oracle user only, no other user has this permissionRun Sqlplus but don't log in to Oracle:sqlplus/nologConnect to the Oracle server with the privileges of the system administrator:

Start and stop OracleStop and start Oracle needs to be switched to Oracle user only, no other user has this permissionRun Sqlplus but don't log in to Oracle:sqlplus/nologConnect to the Oracle server with the privileges of the system administrator:

One, comma splicing fieldSELECT Listagg (AA, ', ') within GROUP (ORDER by AA) as AA from * * * where idOutput results for example: 1,2,3,4Second, time conditionsSELECT * from AAA where time >=to_date (' 2016-01-01 00:00:00 ', ' yyyy-mm-dd hh24:mi:ss