NAV: SLTechnology News&Howtos > Database >

• 

  Oracle series: (9) three types of conversions

  Three types and implicit data type conversions in oracle (1) varchar2 variable length / char fixed length-> number, for example: '123-> 123 (2) varchar2/char-- > date, for example:' 25-April-15'

  2022-06-01 12:46:01 Views: 297
• 

  New features of the first public CTP version of SQL Server 2019

  Translated from: https://www.mssqltips.com/sqlservertip/5710/whats-new-in-the-first-public-ctp-of-sql-server-2019

  2022-06-01 12:45:42 Views: 275
• 

  Oracle database dmp file import and export

  First, database dmp file export in pl/sql under tool select export tales, select all tables, and select the export path export. 2. Import database dmp file to create user tablespace; create user: grant dba t

  2022-06-01 12:45:41 Views: 219
• 

  Using Spring AOP section to solve the separation of database read and write

  Summary: in order to reduce the pressure on the database, the database master-slave (master/slave) method is generally used, but this method will bring some trouble to the application, for example, how to write the data to the master library and read the data from the sla

  2022-06-01 12:45:41 Views: 293
• 

  Object-oriented Database Operation Class in PHP

  In the PHP-oriented process, we can operate on the database by encapsulating functions, so in the process-oriented process, we can also operate on the database through classes. The whole process is roughly the same as the process-oriented idea, but the amount of code is a little more, so it is a little difficult to implement. one

  2022-06-01 12:45:41 Views: 259
• 

  Basic concepts of database

  First, the concepts related to database: data, database, database management system, database system II, data: the basic objects stored in the database. Data definition: symbolic records that describe things are called data. Database: a warehouse where data is stored. Database has three basic characteristics: ① permanent storage, ② has

  2022-06-01 12:45:41 Views: 286
• 

  The condition field in Microsoft SQL Server is of Nvarchar type, and the reason why the condition cannot be queried in Chinese and how to deal with it

  What is included in the condition cannot be queried in Chinese, because the field sender_su_name is of type nvarchar and needs to be preceded by a NSELECT * FROM [test]. [DBO]. [ship _ User_Email] WHE

  2022-06-01 12:45:40 Views: 239
• 

  Install SAP HANA stand-alone database

  Install SAP HANA stand-alone database 1, prepare conditions l sles12sp2 operating system, memory is not less than 24Gl hana database software: HDB_SERVER_LINUX_X86_ 64II, install operating system choose SAP version of the system

  2022-06-01 12:45:27 Views: 301
• 

  Installation of oracle 11gR2 installation on redhat 5.8

  Environmental requirements: Xmanager Enterprise 4 VMware 11.0.0 build-2305329Red Hat Enterprise Linux Server release 5.8 (

  2022-06-01 12:45:22 Views: 256
• 

  Yum installs various versions such as mysql 5.6 and Candle 7.

  Http://repo.mysql.com/yum/1. For a newly opened CVM, you need to check whether the system comes with mysql# yum list installed | grep mysql2. If a system is found to have its own mys

  2022-06-01 12:45:21 Views: 269
• 

  Detailed explanation of backup and recovery parameters of Mysql Database

  Common options:-- all-databases,-A: backup all databases-- databases,-B: for backing up multiple databases, if not, mysqldump takes the first name parameter as the database name, followed by the table name.

  2022-06-01 12:45:15 Views: 237
• 

  Ora-00600

  Trace file / opt/oracle/app/oracle/diag/rdbms/suseora/suseora2/trace/suseora2_ora_36386.trcOracle Dat

  2022-06-01 12:45:15 Views: 265
• 

  Query database statement error "data types text and varchar are not compatible in the equal to operator. & quot

  Problem: query database statement reported an error "the data types text and varchar are not compatible in the equal to operator." Solution: select * from table name where cast (the field name of the query as varch

  2022-06-01 12:45:14 Views: 293
• 

  PL/SQL remote connection oracle Oracle 10g Learning Series (6)

  Because I do not have oracle installed locally, using PL/SQL Developer to remotely connect to the server requires the following configuration: 1. Software preparation oracle client: instantclient-basic-win32-11.2.0.1.0.

  2022-06-01 12:45:09 Views: 297
• 

  Oracle 11g solves the problem of excessive temporary tablespace

  In some databases, because some operations lead to the temporary table space is too large, because of the working mechanism of the temporary table space, the temporary table space will not be released after the completion of the job. This problem can be solved by rebuilding temporary tablespaces, but the operation is still a bit tedious. Found in the operation, pass

  2022-06-01 12:45:08 Views: 270
• 

  Basic operation of mongoDB database

  The collection/coll in mongoDB is equivalent to the table document in mysql, which is equivalent to the common command 1. 1 for each line of data in mysql. Get the help command db.help () db. Table name. Help () db. Table name. Find

  2022-06-01 12:45:08 Views: 279
• 

  ORA-00604 01653 02002 aud$ system

  Environment description: redhat6.4 64-bit + oracle 11.2.0.4 RAC problem description: two days ago, I was temporarily notified that there was something wrong with the database and asked me to contact someone. After connecting to the database, it is found that the cluster service is normal, and the database is also in OPEN state.

  2022-06-01 12:45:08 Views: 227
• 

  Quickly start the test database through HP 3PAR storage underlying snapshot technology

  # the database based on HP 3Par snapshot synchronization technology quickly replicates the production cluster database. The snapshot data is generated by storing the underlying replication technology. Using the snapshot data, the database can be opened quickly, and the new database can be used for testing, recovery and other purposes. The following is to start the fast database

  2022-06-01 12:45:08 Views: 322
• 

  12C SqlPlus prompt

  To update, online when the user is not sys or authorization when there is a problem, add a large version of the database

  2022-06-01 12:45:01 Views: 216
• 

  Analysis of gtid in mysql Master-Slave replication

  Gtid (Global Transaction ID) is the number for a committed transaction and is a globally unique number. Its official definition is as follows: gtid= source_id: transaction_id every gt

  2022-06-01 12:45:01 Views: 281