NAV: SLTechnology News&Howtos > Database >

• 

  Solve the problem of logging into the PL/SQL object window to see that Tables does not have a table.

  Sometimes when PL/SQL logs in to view the table in the left object window, it is not displayed. Pay attention to the users who are now displayed by the system: you can first check whether the current user has created a table. Select count (*) from user_tables; is generally selected as

  2022-06-01 13:48:44 Views: 244
• 

  Database and JDBC programming

  JDBC is a database connection, which is a Java API that executes SQL statements. The program can connect to the relational database through JDBC API and use the structured query language to query and update the database. By using JDBC, you can use the same

  2022-06-01 13:48:44 Views: 224
• 

  Postgresql-- conditional judgment function, system function, etc.

  1. Conditional judgment function: conditional judgment function is called control flow function. In postgresql, the conditional judgment function is: case. 1 、 CASE expr WHEN v1 THEN r1 [WHEN v2 THEN r2] [E

  2022-06-01 13:48:44 Views: 204
• 

  Server security audit in financial industry

  Server security audit industry requirements: whether the audit content of the server host includes: user addition and deletion, audit function startup and shutdown, audit policy adjustment, authority change, abnormal use of system resources, important system operations (such as user login, logout) and so on. Server enabled: not by default

  2022-06-01 13:48:32 Views: 232
• 

  PostgreSQL Database Management (6)

  A database is a collection of schemas, which contain tables, functions, and so on. Hierarchy: server, database, schema, table (or some other type of object, such as function). List existing databases: SELECT datname FROM pg_database; or

  2022-06-01 13:48:31 Views: 297
• 

  Explanation of the problem of heartbeat in ORACLE RAC

  1. The function of rac heartbeat: to detect the network health status between cluster nodes, and it can also be used for cache synchronous refresh and global resource maintenance. Data blocks are also transmitted after the emergence of grid control, whose inline data traffic is relatively large, usually gigabit network, of course, it is better to use 10 gigabytes. 2 、 rac

  2022-06-01 13:48:31 Views: 210
• 

  Mysql Foundation

  RDBMS (Relational Database Management System) Relational Database Management system what is a database: a database (Database) is a warehouse that organizes, stores and manages data according to the data structure, each data

  2022-06-01 13:48:31 Views: 252
• 

  Best practice: HTAP database TBase helps upgrade the core system IT architecture of a provincial unit

  Data storage and processing is an ancient and important technology, from the knot notes in ancient times to the text notes of the ancients, and then to various systems after the birth of computers, until E.F.Codd put forward the relational model, human beings finally have a relatively efficient and unified data processing system-relational database. In

  2022-06-01 13:48:14 Views: 242
• 

  Install the openstack mitaka version on centos7

  Openstack is really a behemoth, and it's not easy to eat it through, so when you have an understanding of openstack, you should deploy it, although openstack can be installed with one-click installation tools such as rdo or devstack.

  2022-06-01 13:48:13 Views: 256
• 

  Automate silent installation of Oracle database

  1.1Unpack the installation package Oracle11gR2 and install it into two installation packages. After all, you need to merge the contents of the two installation packages together and install the Oracle version of the linux64_11gR2 operating system CentOS7.0-X86-64bit.

  2022-06-01 13:48:00 Views: 231
• 

  Problems encountered in migrating projects from JBOSS 6 to JBOSS 7

  The following contents are only recorded in the form of notes to prevent further trouble, and provide a reference: 1. The data source in the project uses JBOSS's JNDI. In versions 6 and 7, there are great differences in configuration, specific configuration methods and more information configuration. I will not repeat them here (please refer to http.

  2022-06-01 13:48:00 Views: 299
• 

  Oracle GoldenGate Learning-- basic Concepts and configurations (2)

  Oracle GoldenGate Learning-basic Concepts and configurations (2) 1. Oracle OGG download: http://www.oracle.com/technetwork/cn/middleware/golde

  2022-06-01 13:47:54 Views: 222
• 

  MVC5 DB FIRST

  As master has been working on the development of codefirst, there is a new requirement recently, that is, I need someone else's database, and then I will develop it. Now there is a problem. Sort out the following: there is a ready-made engineering code for our previous codefirst. I remember Master said that it was generated from the database.

  2022-06-01 13:47:39 Views: 284
• 

  PIVOT: row-to-column function

  PIVOT function, the format of the row-to-column PIVOT function is as follows: PIVOT (< aggregate function > ([aggregate column value]) FOR [column name before row transfer] IN ([column name after row transfer], [column name after row conversion], [column name after row conversion],.

  2022-06-01 13:47:39 Views: 289
• 

  Tablespace where the oracle mobile table resides

  1. Modify the table space alter table TABLE_NAME move tablespace TABLESPACENAME query all tables under the current user select 'alter table' | | tabl

  2022-06-01 13:47:39 Views: 214
• 

  Nagios Monitoring Database DB2--check_db2_health

  I think you all know that Nagios monitors the DB2 database using the check_db2_oracle plug-in, but before you can use it, you need to install the runtime on the Nagios server. Combined with many of my own tests, I focus on how to use CenOS6.7 64b

  2022-06-01 13:47:38 Views: 269
• 

  Postgresql Index usage reference

  A common index is usually created in postgresql as follows: create index idx_table_name_x1 on table_name (col_name); after reate index execution, it will block during index creation.

  2022-06-01 13:47:38 Views: 209
• 

  Add redo log group and add log group diversification

  View the status of the redo log group and the location of the log. SQL > select * from vault log group # THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCSTAT

  2022-06-01 13:47:38 Views: 261
• 

  Silently build and delete databases

  In many cases, the customer site or test environment does not necessarily have graphical tools such as xm, and new libraries or deletions need to be carried out through the command line. Silently build the database: SYS@pro > select * from v$version where rownum < 2th banner

  2022-06-01 13:47:38 Views: 214
• 

  Oracle calculates the function of time span

  Display the span from the current time-calculate the time span: return value is X days y: Z minutes declareln_day_count number (10); ln_hour_count number (10); ln_min_count

  2022-06-01 13:47:37 Views: 207