NAV: SLTechnology News&Howtos > Database >

• 

  The practical part of ado.net

  one。 Concept understanding ADO.NET, whose name derives from ADO (ActiveX Data Objects), is a library of COM components used to access data in previous Microsoft technologies. The ADO.NET name is used because of Micr

  2022-06-01 13:03:36 Views: 249
• 

  Redis overview, characteristics, different from Memached, master-slave configuration of production environment, redis configuration file parsing

  Redis Overview: is a Key-Value-based persistent database storage, supporting rich data types, written in C language, memory-based and persistent log-type, Key-Value database, and provides multi-language APIRedis features 1. Key

  2022-06-01 13:03:35 Views: 277
• 

  PHP connection oracle

  Install oracle Clientoracle-instantclient11.2-basic-11.2.0.4.0-1.x86streaming 64.rpmoracleMustantclient11.2Mutual-

  2022-06-01 13:03:05 Views: 207
• 

  MHA building

  Note: the MHA built here is an one-master-one-slave environment manager:192.168.162.132master:192.168.162.134 node134slave:192.168.162.133 nod

  2022-06-01 13:03:05 Views: 254
• 

  Index Series 11-- ordering of Index characteristics and Optimization of stored values max

  -- MAX/MIN 's index optimization drop table t purge;create table t as select * from dba_objects;update t set object_id

  2022-06-01 13:03:05 Views: 251
• 

  Yum installs different versions of mysql,php

  1. The first step is to see whether linu has installed mysql, and then go through rpm-qa | grep mysql to view the installation of mysql under centos. If so, uninstall the previous lower version rpm-qa. Grep mysqlrpm-e--

  2022-06-01 13:03:04 Views: 283
• 

  ORA-01031: insufficient privileges

  Problem description: unable to log in to the database through sqlplus / as sysdba, indicating insufficient permissions. Second, simulation test 1. Phenomenon sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0

  2022-06-01 13:03:04 Views: 205
• 

  ORACLE Postgresql Chinese sorting

  When our order sorting doesn't achieve what we want, try the function NLSSORT, which sorts not only by last name, but also by first name: nls_param is used to specify language features in the format nls_sort = sort,nls_s

  2022-06-01 13:03:04 Views: 282
• 

  Oracle PL/SQL Developer integrates TFS for version management of team script files

  For the traditional large-scale software products that use relational database, the continuous development and maintenance of the background database may produce a large number of script files. How to manage the version of these script files more conveniently? and how to quickly manage permissions and other collaborative management between teams? Different databases

  2022-06-01 13:02:46 Views: 266
• 

  Sign function in Oracle

  Function syntax: sign (n) function description: the symbol of the decision value n, if n > 0, return 1; if n < 0, return-1; if n = 0, return 0. Function example: 1. Select sign (100) as "positive number 100

  2022-06-01 13:02:44 Views: 272
• 

  Installation of oracle12C databases for ProxmoxVE (CDB and PDB)

  On the left above is my personal Wechat. For further communication, please add Wechat. On the right is my official account "Openstack Private Cloud". If you are interested, please follow us. The RAC environment of oracle12C was built on the PVE environment two days ago (for details, see another blog post, "Prox."

  2022-06-01 13:02:14 Views: 247
• 

  Oracle11 imports dmp files

  1. Start the oracle service and monitor; enter services.msc for the shortcut key win+r-- to find the oracle service oracleServiceORCL and listen to OracleOraDb11g_home1TNSListen

  2022-06-01 13:02:13 Views: 217
• 

  The use of dblink

  1. Create a global link (using a local user to access the table of other users) Syntax: create public database link link name CONNECT TO local username IDENTIFIED BY password USI

  2022-06-01 13:02:13 Views: 294
• 

  Oracle delete tablespace

  Table space offline SQL > alter tablespace rcat offile;2. Delete the user SQL > drop user ractowner cascade3. Delete tablespaces and data files DROP TABLES

  2022-06-01 13:02:13 Views: 206
• 

  Introduction to use of mysqldump

  1. Backup the structure and data of a single database mysqldump-uroot-p123456 test1 > / root/test1.sql2, restore the structure and data method of a single database 1: use the mysql command mysql-u

  2022-06-01 13:02:13 Views: 296
• 

  Linux backup files and database scripts

  Backup database: #! / bin/bash# bei fen mysql:moves# time:2016/3/27PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/

  2022-06-01 13:02:03 Views: 202
• 

  Installation and configuration on CentOS MYSQL supports INNODB engine

  To install the MYSQL database, please refer to: http://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html in short: 1) download M

  2022-06-01 13:02:03 Views: 225
• 

  Cx_Oracle install

  STEP 1. Install Oracle Client1.1 download: http://download.oracle.com/otn/linux/instantclient/121020/

  2022-06-01 13:02:03 Views: 212
• 

  Sort out part of the java code and compare the data types with oracle,mysql,sql server

  After searching for the comparison of data types on the Internet, there is almost no comparison of the three databases, so I wrote the comparison of some fields. If there is anything wrong, please do not hesitate to comment. JAVA field oracle field mysql field sql server field intnumbe

  2022-06-01 13:02:03 Views: 227
• 

  My first Scrapy program-crawling Dangdang information

  Now that Scrapy is installed, let's implement the first test program. An overview of Scrapy is a crawler framework, and its basic process is as follows (the screenshot below is from the Internet). To put it simply, we need to write an item file to define the data structure returned; write a spid

  2022-06-01 13:02:03 Views: 269