NAV: SLTechnology News&Howtos > Database >

• 

  Summary of time and date function in oracle

  1. Commonly used date function: DAY ()-- function returns date value MONTH () in date_expression-- function returns month value YEAR () in date_expression-- function returns date_e.

  2022-06-01 16:16:50 Views: 267
• 

  [Postgresql] postgresql9.3.9 version deployment

  Installation method: source package installation environment: linux-Centos 6.5.download Postgresql source package wget http://ftp.postgresql.org/pub/source/v9.3.9/postg

  2022-06-01 16:16:50 Views: 236
• 

  The use of data pump EXPDP export tool and IMPDP import tool

  The use of data pump EXPDP Export tool and IMPDP Import tool I. EXPDP and IMPDP usage instructions Oracle Database 10g introduces the latest data pump (Data Dump) technology, data pump export and import (EXPDP and IM)

  2022-06-01 16:16:49 Views: 202
• 

  CentOS6.x install mysql5.6.x

  1. System and installation instructions system: CentOS6.x_x64mysql: community version 5.6.21, mysql is the most widely used open source database, compilation and installation is relatively complicated, yum installation version is relatively low, and the default installation location is / var/. Official download is adopted this time.

  2022-06-01 16:16:49 Views: 229
• 

  A tutorial on Building and configuring redis clusters in Windows Environment

  Redis cluster: Redis cluster is an assembly that provides data sharing among multiple Redis nodes. Cluster nodes work together to build a decentralized network. Each node in the cluster has an equal identity, and each node saves its own data and cluster state. Between nodes

  2022-06-01 16:16:19 Views: 243
• 

  MongoDB-pymongo.errors.CursorN

  Python, python3. First get all the data db ['test'] .find ({}, {_ id:0}) from the database, and then for the results demos = db [' demo'] .find ({}, {"_ I)

  2022-06-01 16:16:19 Views: 264
• 

  Thinkphp Note 2

  1. Controller creation principle: basic principle: according to the function, in principle, a function item corresponding to an action in the controller may share multiple functions to add and modify an action is relatively close. According to the conditions to choose to add or modify may need an auxiliary method to complete an action basic principle: according to the function, according to

  2022-06-01 16:16:18 Views: 287
• 

  10. MySQL view

  The view in the database is a virtual table. Like a real table, a view contains a series of named row and column data. Row and column data to freely define the table referenced by the view query and dynamically generate when the view is referenced. 10.1. View Overview View is derived from one or more tables, view

  2022-06-01 16:16:18 Views: 274
• 

  Delete tablespace prompts ORA-00604 and ORA-38301 in oracle

  Today, I need to make room on my computer. I found that a dbf file in oracle occupies about 30g, which is rarely used by users, so I want to deal with it-delete tablespace operation. The database of this machine is 32-bit 10.2.0.1.0, tablespace

  2022-06-01 16:16:18 Views: 218
• 

  Treatment of excessive oracle 11g RAC crfclust.bdb

  Find /-type f-size + 500m | xargs du-hm | sort-nrora.crf service provides services for Cluster Health Monitor (hereinafter referred to as CHM)

  2022-06-01 16:16:18 Views: 288
• 

  Extension of RHEL + Oracle 11g + udev + ASM experiment

  Recently, I have been studying hard about the architecture of Oracle and other theoretical knowledge. I summarize some knowledge here, and I do an experiment here to consolidate the recently learned knowledge. Experimental environment Redhat Enterprise Linux 6.5x86x64

  2022-06-01 16:15:51 Views: 208
• 

  [MongoDB] 01, MongoDB Foundation

  1. Overview of MongoDB 1. Introduction to MogoDB what is MongoDB? MongoDB is written by C++ language and is an open source database system based on distributed file storage. In the case of high load, adding more nodes can ensure server performance.

  2022-06-01 16:15:45 Views: 241
• 

  MongoDB Master/Slaver configuration

  After getting started with MongoDB, this article mainly introduces MongoDB Master/Slaver configuration and first creates Mongo Master/home/hrj/mongodb-linux-i686-static-1.6.5/b.

  2022-06-01 16:15:42 Views: 256
• 

  Mysql remote login notes

  Non-root needs to create user name switch database mysql > use mysql; create user (user1: user name;%: any ip, can also be specified, root defaults to localhost;123456: login password) mysql > CRE

  2022-06-01 16:15:42 Views: 235
• 

  The necessary configuration after the project svn of the thinphp framework is checked out again

  Just tried to understand the thinkphp framework, here to make some notes, followed by a new summary will be updated here, if there are any mistakes and omissions, please correct. Projects using the thinkphp framework need to be reconfigured after being checked out with svn before they can be opened locally

  2022-06-01 16:15:37 Views: 247
• 

  Hive storage processor (StorageHandlers) and integration of hive and hbase

  This article is based on the translation of the official English document of hive. Some things that are difficult to understand have been added to my personal understanding. The official English address is 1. Https://cwiki.apache.org/confluence/display/Hive/St

  2022-06-01 16:15:36 Views: 267
• 

  MongoDB assertion: 18 {code: 18, ok: 0.0, errmsg: & quot;auth fails"}

  Assertion: 18 {code: 18, ok: 0.0, errmsg: "auth fails"} MongoDB 2.4.10 use the xucy administrator account under the admin database to export data and verify

  2022-06-01 16:15:21 Views: 220
• 

  Tree structure storage of a large number of file name records

  For more than ten years, 1 billion directories and files already exist in NAS, and there are many challenges in the process of designing and developing backup system. This paper will share the tree structure storage practice of a large number of file name records. Introduction since it is a regular backup, there will certainly be more than one backup. For a special

  2022-06-01 16:15:21 Views: 236
• 

  SQLite compile-time authorization callback Compile-Time Aut

  Original: https://www.sqlite.org/c3ref/set_authorizer.htmlint sqlite3_set_authorizer (sqlite3*,int (* xAuth) (v)

  2022-06-01 16:15:21 Views: 213
• 

  Oracle user password management

  Use profile for password restriction. When you set up a database, oracle automatically creates a profile file called default, and when the creation does not specify the profile option, oracle assigns default to the user. (1) account locking

  2022-06-01 16:15:20 Views: 222