Database Administrator

Define the package and usage of stored procedures in Oracle Define the package and usage of stored procedures in Oracle Use the dept table under the scott account; Select * from dept order by deptno; 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30

Tips for SQL Server to detect database connection Sometimes you may need to check whether the services of a machine are up, or whether a database of a machine can be connected, cannot open ssms, and do not want to log on to the server. 1.

Use temporary variables in Oracle In Oracle databases, you can use variables to compile general SQL statements. When running SQL statements, input values for variables will replace the variables with these values in SQL statements. Temporary

Oracle Spool commands Use the Oracle spool command to copy the output results of SQL * plus to a specified file, or send the query results to the printer and directly use the spool off command. The spool command syntax is as follows:Spool

Use Innobackupex to quickly build (fix) the MySQL Master/Slave Architecture There are many ways to build MySQL Master/Slave databases. The traditional mysqldump mode is one of the choices of many people. However, this method is not ideal for large

Use in Oracle The main purpose of using a package is to modularize the program. The package can combine the relevant stored procedures, functions, variables, constants, cursors, and other PL/SQL programs, in this way, code libraries can be

ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (Document ID 1930964.1), goldengate ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (Document ID 1930964.1) Source:ORA-00604 ORA-00376 Unable to Drop a tablespace in

[Translated from mos] What does Windows Service javasleremexecservice do? oraclemos Source:What Is The Windows Service "Oracleremexecservice "? (Documentation ID 1433144.1) Applicable:Oracle Server-Enterprise Edition-Version 11.2.0.1 and

Rman command line, directly startup db, rmanstartup I forgot where I saw it. It seems like this is a new feature of 11 GB.   [oracle@rhel63single ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Thu Feb 19 00:39:14 2015Copyright

[Translated from mos] explanation of the MISSING keyword in datafile name, mosdatafile Source:Explanation of MISSING keyword in datafile name (Document ID 1050268.1)Applicable:Oracle Server-Enterprise Edition-Version 7.3.4.0 to 11.2.0.1.0 [Release 7

In archive mode, restore the offline drop datafile method. Reference:How to recover offline dropped datafile in archivelog mode (Document ID 286355.1) The following experiment is completed based on oracle 11.2.0.4 linux x86-64bit. [Oracle @

PL/SQL summary, plsql SummaryI. Basic syntaxThe structure blocks of PL/SQL are as follows:Declare-- Declare variables, types, and cursorsBegin-- The execution part of the program, similar to the main methodException-- Provides a mechanism for

Oracle linesize command, oraclelinesizeYou can use the linesize command to set the number of characters that a row can accommodate. The default value is 80. If the linesize value is small,A row of data in the table may be displayed in multiple rows

The NFS mount point that is disconnected on AIX causes the Oracle instance to hang and the aixinstance Oracle instance hang is occupied by NFS mount points disconnected on AIX.From mos: Disconnected NFS Mount Point Causes Instance to Hang on AIX

Real-Time Report (T + 0) solution using the rundry set computing report, real-time report In report projects, the customer is paying more and more attention to the real-time nature of source data, and hopes to see the latest data in the report.

Database Operations -- get the returned values of stored procedures and returned values of Stored Procedures Write a stored procedure using the SQL Server database. The Code is as follows: create procedure proc_select @id intasbeginif exists(select

Perform an experiment where the initial value is smaller than the uniform size. After the table is created, the extents of minextents uniform size are created., minextentsextents Perform an experiment where the initial is smaller than the uniform

Article Title, article title Daquan Bug 4352808-Dump (kglpnal)/OERI: 17252/crash from PQ with TYPE columns (Document ID 4352808.8) go to the bottom Bug 4352808 Dump (kglpnal)/OERI: 17252/crash from PQ with TYPE columnsThis note gives a brief

Reconstruction-multiple methods are used to remove students and reconstruct students When designing the function of discontinuing students, I have read many blogs and think it is appropriate to use the responsibility chain model, we know that when a

Oracle's edit command and Oracleedit command Use the edit command to copy the content in the SQL * plus buffer to an afiedt. buf file, and then start the default editor in the operating system to open this file, and the file content can be edited.