NAV: SLTechnology News&Howtos > Database >

• 

  SQL acquires data

  SELECTCOMPLAIN_CODE 'complaint order number', ORDER_NO 'order number', RESPONSIBILITY 'responsible unit name', CREATE_TIME 'creation time', COMPLAIN_TYPE'

  2022-06-01 17:32:42 Views: 255
• 

  How do I export definition statements for stored procedures, functions, packages, and triggers? How do I export table and index creation statements?

  How do I export definition statements for stored procedures, functions, packages, and triggers in Oracle? How to export the structure of the table? How do I export an index creation statement? Someone in the QQ group asked: how to export a stored procedure under a user? Wheat Miao answer: there are many ways to use DBMS_METADAT.

  2022-06-01 17:32:12 Views: 290
• 

  Use python to operate mysql database (which is implemented through classes to facilitate the addition of functions)

  #-*-coding: utf-8-*-"Created on Sun Nov 27 18:57:44 2016@author: toby"import MySQLdb'test_db'"

  2022-06-01 17:32:12 Views: 207
• 

  Oracle 11gr2 rac Environment preparation (virtual box)

  Oracle 11gr2 rac Environment preparation (virtual box) https://oracle-base.com/articles/11g/oracle-db-11gr2-rac-installat

  2022-06-01 17:32:12 Views: 292
• 

  Brother Kang teaches you how to manage redo log files effectively.

  Some people may not know what redo log files are, but they are actually the redo.log files under your oradata directory. Role: when your database crashes, the administrator can restore the database to the last time by redoing log files and database backup files

  2022-06-01 17:32:12 Views: 219
• 

  MySQL user and Rights Management

  The way Mysql changes the password if you forget the password-- skip-grant-tables1, alter useralter user test@'localhost' identified by 'xxxx password

  2022-06-01 17:32:11 Views: 230
• 

  Principle "64-bit operating system needs to install 64-bit database"

  Basic principles of database installation, 64-bit operating system, installation of 64-bit database. 2018-09-17 21:32:01 5676 [Note] Plugin 'FEDERATED' is disabled.2018-09-17

  2022-06-01 17:32:11 Views: 295
• 

  A memo about oracle

  What the database cannot avoid is dealing with the data scenario: invoice information, when many employees of the company are engaged in transactions, the invoice information is the same, so the employees of the company often want to call the unified invoice information. the company accounting login system can fill in the general invoice information, in order to generate the order is simple, the invoice needs

  2022-06-01 17:32:11 Views: 237
• 

  Deploy statspack tools (1)

  Disable sga automatic management mechanism, allocate relatively small data buffer (30m) and shared pool (70m) space 1.1.turn off SGA automatic management mechanism to see if ASSMidle > show parameter sga;NAME TYPE VA is enabled

  2022-06-01 17:32:11 Views: 262
• 

  Actual combat between Node and Mongodb

  Listening to Chen Hongyu's "ideal Thirty". Listen ~ the last two blog posts mentioned the installation and connection of Mongodb under Mac. This time let's take a look at how to operate Mongodb through Node. PS: the data set in this article adopts the "myc" from the 'test' library' in the previous blog post.

  2022-06-01 17:32:10 Views: 266
• 

  Database script backup

  Rem * * Code Start**@echo offset "Ymd=%date:~

  2022-06-01 17:32:10 Views: 291
• 

  Centos7.1 deployment mysql-5.6.34 (notes)

  What I use to install here is the mysql binary package, which mainly reduces the compilation and installation time, and of course, there is also the yum installation mode. Download address of mysql version: http://mirrors.sohu.com/mysql/1, solving related dependency problems

  2022-06-01 17:32:10 Views: 269
• 

  Detailed tutorial on installing Oracle 11g based on RHEL 6.5 (7) & mdash;— configuration Oracle self-startup

  7 configure Oracle self-startup to modify orcl:/u01/app/oracle/product/11.2.0/db_1:N in / etc/oratab file to orcl:/u01/app/oracle/produ

  2022-06-01 17:32:09 Views: 285
• 

  Oracle 11g archive opening and closing

  The archive log process is an optional process, which is not started when the instance is started. The purpose of this process is to write the data of the full redo log file to an archive log. This archive log is used to repair the database in the event of a media failure. Archiving is strongly recommended in the production environment. We use ps

  2022-06-01 17:31:51 Views: 218
• 

  MongoDB practice (8) performance Monitoring

  1. Mongosniff this tool can monitor from the bottom which commands are sent to MongoDB for execution, from which you can analyze: execute as root:. / mongosniff-- source NET lo and then it will

  2022-06-01 17:31:42 Views: 294
• 

  Bayaim_linuxRedHat5_install_oracle11gR2.txt

  Bayaim_linuxRedHat5_install_oracle11gR2linux_install_oracle_11g: check the memory of the server by using the following command: [] # grep MemTotal /

  2022-06-01 17:31:42 Views: 280
• 

  50 suggestions for MongoDB developers Tip6

  This series of articles are translated from "50 Tips and Tricks for MongoDB Developers". I can't find the Chinese version for the time being. Anyway, I have been studying mongodb deeply recently, so I just want to translate it. On the one hand, strengthen yourself.

  2022-06-01 17:31:42 Views: 251
• 

  SuSE12 installation MySQL5.7.22: compilation and installation mode, single instance

  Summary: SuSE12.1 64-bit operating system, MySQL5.7.22 compilation and installation, single instance compilation and installation with and without boost Note: kingtry is my hostname 1, environment-ready operating system: SuSE version 12.1 64-bit

  2022-06-01 17:31:41 Views: 249
• 

  Oracle basic statement

  1. Create the table create table IT_EMPLOYEES (ENPLOYEES_ID NUMBER (6) NOT NULL UNIQUE,FIRST_NAME VARCHAR2 (20), LAST_N

  2022-06-01 17:31:38 Views: 230
• 

  Oracle full library import table error ORA-39126

  An error was reported when importing data using the impdp included with Oracle, as shown in the figure above. This is due to the import of the system table, and then change the parameter TABLE_EXISTS_ACTION=TRUNCATE when importing.

  2022-06-01 17:31:38 Views: 281