NAV: SLTechnology News&Howtos > Database >

• 

  Regular execution of stored procedures

  Timed execution of stored procedures basic Oracle timer Oracle timer: regular execution of a stored procedure. You can see it through the graphical interface of pl/SQL. The timer includes scheduling and stored procedure interface, which mainly tells the timer to be executed.

  2022-06-01 17:25:27 Views: 258
• 

  HFileOutputFormat of HBase

  Hadoop mr output needs to import hbase, then it is best to export to HFile format, and then import to HBase, because HFile is the internal storage format of HBase, so import efficiency is very high, the following is an example 1. Create HBase table T1h

  2022-06-01 17:25:26 Views: 271
• 

  Mysql master-slave replication and some special settings that should be paid attention to

  0. Prepare A. Installation database: master and slave mysql database (mysql server) are all installed: in version, mysql allows lower version of master with higher version of slave https://dev.mysql.com/do

  2022-06-01 17:24:56 Views: 246
• 

  Settings for oracle snooping listener

  View commands for listening to listener lsnrctl status turn off listening lsnrctl stop start listening lsnrctl start register listening alter system register (need to connect to database

  2022-06-01 17:24:56 Views: 272
• 

  [MongoDB Learning Notes 5] create, read, update, delete (CRUD) in MongoDB

  Database will be used to create (create) read (find) update (update) delete (remove), MongoDB will also be used; first, create an insert function to add documents to the collection. For example, create a database blog and add documents to the

  2022-06-01 17:24:56 Views: 266
• 

  How to judge whether a string contains Chinese characters in oracle

  How to judge whether a string contains Chinese characters in oracle. 1. 1 BLOG document structure figure 1. 2 preface part 1. 2. 2. After reading this article, you can master the following skills, and you can also learn some other knowledge that you do not know, ~ O (∩ _ ∩).

  2022-06-01 17:24:56 Views: 233
• 

  Write simple query statements

  1. The basic syntax statements select * from employees;A.SELECT and FROM are keywords, which need to be written in uppercase, but the compiler is not case-sensitive. It can be written on a single line or multiple lines.

  2022-06-01 17:24:55 Views: 266
• 

  How to start ORACLE 11 under CentOS 6

  After successfully installing the Oracle 11g database under CentOS6, we are faced with the problem of starting Oracle. The following is a summary of the learning practice: manually start the database and log in to $lsnrctl start$sqlplus / as with Oracle users.

  2022-06-01 17:24:55 Views: 294
• 

  The aggregator assists in localized sorting of MongoDB computing

  For localized languages (for example, Chinese), MongoDB is sorted by UNICODE encoding, not by local language encoding. It is convenient to use esProc and MongoDB to sort localized languages (for example, Chinese is sorted by pinyin). Next I

  2022-06-01 17:24:49 Views: 289
• 

  Lepus monitoring database

  Environment: all packages required for 192.168.1.128 mini2: https://pan.baidu.com/s/1uAZqYnST0VwoCLL3Ir3FCgLepus installation requires the Lamp environment to install LAMP:

  2022-06-01 17:24:19 Views: 234
• 

  The advanced part of MySQL

  1.MySQL table constraints (1) introduction to data integrity: what    calls data integrity is the accuracy and reliability of the data. Data integrity can be improved by adding integrity constraints: entity integrity: determining a unique identity for each entity (record). Implementation method:

  2022-06-01 17:24:13 Views: 224
• 

  Oracle alter operation

  Because Oracle has a slightly different format for column addition, deletion and modification, it is hereby recorded in order to facilitate future viewing. 1. Add the column: SQL > alter table T1 add y integer;Table alteredExecuted

  2022-06-01 17:24:13 Views: 239
• 

  Where and Having distinction

  Similarities and differences between Where and Having (1) where is filtered before the query returns results (2) having is filtered after the query returns results (3) the HAVING clause is added to SQL because the where keyword cannot be clustered

  2022-06-01 17:24:12 Views: 279
• 

  Principle of SSM framework

  SSM framework: spring, springMVC, mybaits. Spring:spring is a container. Similar to an object factory, classes marked as required are put into this container in advance. For the generation of objects, you do not need to new manually, you can use the

  2022-06-01 17:24:09 Views: 296
• 

  Package of Oracle topic 15

  1. An overview of the package a. What is a package? A package is a combination of PL/SQL programming elements such as related procedures, functions, variables, constants, and cursors. B. what are the characteristics of the bag? It has the characteristics of object-oriented programming language and is suitable for PL/SQL programming elements (procedures, functions, variables, etc.).

  2022-06-01 17:24:00 Views: 246
• 

  Opportunities for SQLLDR to display its talents

  Sqlldr technical terms do not do verbose, approachable that this is for the import or bulk import of .csv format data. After opening the cmd, we can enter sqlldr to see the relevant information and help information, with a detailed analysis, must see! Then we mostly cooperate with script documents to make

  2022-06-01 17:23:54 Views: 292
• 

  Knowledge of operating mysql in Python (2)

  1. Create tables Teacher:create table Teacher (teaId int not null, teaname varchar, ag)

  2022-06-01 17:23:53 Views: 225
• 

  The principle of MySQL Master-Slave replication and read-write Separation

  The main purpose of this article is to share the principle of MySQL master-slave replication and read-write separation. This paper also introduces how to configure and verify the experiment of master-slave replication and read-write separation. I hope you can get something through this article. MySQL master-slave replication and read-write separation 1. Before the preface, we have already discussed the MySQ

  2022-06-01 17:23:53 Views: 221
• 

  SybaseIQ-date function

  1. Getdate () function: get the current time of the server 2. Datepart (interval,date) parameter: interval: a certain part of time (such as hour, minute, second, day, week, month, quarter, year) date: current date or specified day

  2022-06-01 17:23:47 Views: 261
• 

  Master the knowledge of MySQL recovery data backup

  This article mainly gives you a brief talk about the knowledge of MySQL recovery data backup. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article on MySQL recovery data backup knowledge can bring you some practice.

  2022-06-01 17:23:47 Views: 290