NAV: SLTechnology News&Howtos > Database >

• 

  Several naming ways to connect to Oracle

  People engaged in Oracle-related work use various tools to connect to Oracle databases every day, such as SQL*Plus, PL/SQL, TOAD, SQLDeveloper and so on. Here are several ways to connect to Oracle. This example

  2022-06-01 21:42:25 Views: 263
• 

  The method of creating Database with PHPmyadmin

  Today, the editor shares with you the method of creating a database with PHPmyadmin, which is not well understood by many people. Today, in order to let you know more about PHPmyadmin, the editor summarizes the following contents. Let's look down together. Create a database with PHPmyadmin

  2022-06-01 21:42:10 Views: 253
• 

  Construction and basic Application of LAMP platform

  LAMP platform deployment and application 1:LAMP includes the advantages of linux apache mysql php (python,perl): low cost, easy to develop open source software, simple page code, and very good integration with html markup language

  2022-06-01 21:41:53 Views: 274
• 

  Sql that usually used

  Insert the date of one year into the data table: insert into T_HOLIDAYselect SEQ_T_HOLIDAY.NEXTVAL xh,to_date (20160101) + level

  2022-06-01 21:41:52 Views: 236
• 

  Oracle query slow execution of sql, using V$SESSION_LONGOPS analysis

  / * OPNAME: refers to the name of the operation that has been executed for a long time. Such as: Table ScanTARGET: the object_name being operated. Such as: tableA TARGET_DESC: describe the content of target SOFAR: this is required

  2022-06-01 21:41:52 Views: 266
• 

  Steps for Oracle exp imp to back up and restore tablespace data

  Oracle backup is divided into logical backup and physical backup. Logical backup is exp/imp; physical backup: cold backup, hot backup and RMAN backup. Exp/imp has three modes, table mode, user mode, and full library mode. 1. Use exp/imp to prepare

  2022-06-01 21:41:52 Views: 267
• 

  Heapq takes the maximum or minimum value element of the list

  When you get the largest or smallest n elements in a collection, you can use the nlargest and nsmallest functions in the heapq module to meet the requirements heapq introduction: the heapq module implements heap sorting in python and provides the relevant parties

  2022-06-01 21:41:51 Views: 224
• 

  Zabbix alarm executes remote command

  In daily Zabbix alarm cases, most of them report to the police and send emails. in the scene, it is rarely necessary to execute a command after the alarm (start the service, clear the disk space, shut down the server). Today, let's talk about what needs to be done recently: execute remote commands after the alarm, first of all, talk about the requirements.

  2022-06-01 21:41:32 Views: 208
• 

  Non-relational database NoSQL

  The general introduction of NoSQL http://www.apelearn.com/bbs/forum.php?mod=viewthread&tid=8660&highlight=NoSQLmemcached introduction 1.

  2022-06-01 21:41:32 Views: 226
• 

  Delete and add nodes in 11g rac under windows

  First, delete: 1 dbca delete node rac1, and delete it as prompted. You need to enter the sys password crsctl unpin css-n rac12# to view the resource pool for grid users. At this time, rac2 is no longer in serverpool.

  2022-06-01 21:41:31 Views: 263
• 

  Sharing of master-slave instances of Redis switching between each other online

  Today, what the editor shares with you is an example of Redis switching between masters and slaves online. Many people don't know much about it. Today, in order to let you know more about Redis, I summarized the following contents for you. Let's look down together. I'm sure you'll get something. For some reason, we may need to set the

  2022-06-01 21:41:28 Views: 206
• 

  Detailed explanation of MySQL8.0 InnoDB parallel execution

  Today, the editor shares with you a detailed explanation of the parallel execution of MySQL8.0 InnoDB, which many people don't know very well. today, in order to let you know more about MySQL8.0, I have summarized the following contents for you. Let's look down together. I'm sure you'll get something. Overview M

  2022-06-01 21:41:19 Views: 279
• 

  What are the ways to register redis as a window service

  What are the ways to register redis as a window service? Many people don't know much about it. Today, in order to let you know more about the method of registering redis as a window service, I summed up the following and let's take a look at it. Open the redis installation path and execute:

  2022-06-01 21:41:07 Views: 220
• 

  The Foundation of MySQL Database (4)-- MySQL Database creation example

  MySQL database foundation (4)-- MySQL database creation example 1, create database 1, create database create database, specify the default character set of the database is utf8. Create database schoolDB default cha

  2022-06-01 21:41:04 Views: 222
• 

  Basic use of redis

  1.redis persistence introduces a.remote dictionary serverb. It is also based on key-value key value storage c.redis supports richer data types d. Persistent caching service, e. Support for master-sla

  2022-06-01 21:41:00 Views: 250
• 

  The method of character set conversion between databases under different systems

  Today, what the editor shares with you is the method of character set conversion between databases under different systems, which is not well understood by many people. Today, in order to give you a better understanding of the character set conversion between databases, the editor summarizes the following contents. Let's move on. I'm sure you'll get something. Front-end Lin

  2022-06-01 21:41:00 Views: 249
• 

  Deployment of MongoDB replication sets and administrative maintenance of replication sets on CentOS7

  Overview of MongoDB replication sets replication sets are additional replicas of data, the process of synchronizing data across multiple servers, providing redundancy and increased data availability, and allowing recovery from hardware failures and disruptions in services. Replication set how MongoDB replicates the set to

  2022-06-01 21:41:00 Views: 274
• 

  Data backup and recovery Mechanism BDR of HBase

  1. The snapshot mechanism snapshots simply makes a table on hbase for testing: hbase (main): 044 main 0 > scan 'student'ROW COLUMN+CELLnum1 column=shuxing:n

  2022-06-01 21:40:47 Views: 289
• 

  The installation and deployment process of oracle11g R2 under centos 6.4( 64bit)

  Some time does not install oracle, feel a little raw, so make a note to facilitate later installation and deployment, at the same time can also share with you. This installation is the process of deploying Oracle 11GR 2 under CentOs 6.4( 64bit). You can go to the network.

  2022-06-01 21:40:39 Views: 260
• 

  The method of dealing with OGG problem ORA-01403

  Learn about logdump analysis tools and common commands: http://book.51cto.com/art/201202/319253.htmhttp://www.killdb.com/2012/09/01/golde

  2022-06-01 21:40:39 Views: 251