Database Administrator

Create TableMyinfo (myname varchar2 (10), passwdVarchar(10 )); Based on the above table myinfo PL/SQL (procedural language/SQL ):Oracle is an extension based on the standard SQL language. In PL/SQL, You can nest SQL statements, define variables,

1) Only appropriate privileged user can do delete operation on SYS. AUD $ table. The user must have either of the following privileges.-SYS user.-Delete any table system privilege. (If O7_DICTIONARY_ACCESSIBILITY = TRUE)-A user to whom SYS has

The following command was run in the db2 command window today: Db2stop Then, when we enter db2start, an error is returned !!! "SQL1397N failed to log on to the DB2 service" Why is the Instance suspended after it is started? I checked the

This article analyzes the problem of slow MySQL database servers and proposes corresponding solutions. 1. Check the system status Check the status of the system by using some operating system tools, such as CPU, memory, swap, and disk utilization.

1.Set the total number of lines displayed on the page   1)View the currentPagesize,The default value is14: SqlplusCode 1.Show pagesize;   2)SetPagesizeSet100,You can display more than enough rows at a time.: SqlplusCode 1.Set

1. Shrink Oracle10g Database files: 1.1 questions: A database contains millions of data records. After the Delete statement is used to Delete most of the data, the space occupied by the database files will not be reduced to free up extra space. For

It is troublesome to input data one by one. We can add all records to your database table using text files. CREATE an example file named "“mysql.txt". Each line contains a record. Use a tab to separate the values and give them in the order of the

Oracle determines whether the varchar2 type is null.VV_LIST: = 'dsssfdfdsfds ';IF (VV_LIST <> '') THENDBMS_OUTPUT.PUT_LINE ('ppppppppppppppp ');ELSEDBMS_OUTPUT.PUT_LINE ('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb ');End if; The result is printed with

The following is what I encountered during the test. I did not have it before, but it seems that I can use lower case letters. But today, when I change the archive location, I can only use upper case sid. In my environment, Oracle sid is case

Spring provides great support for Hibernate integration. Spring provides initialization for sessionfactory, So you no longer need to worry about session open and close. Spring also provides flexible transaction declarations. This article describes

In SQL server, the number of affected rows returned is: If @ RowCount In Oracle, the number of affected rows returned is: If SQL % rowcount Example: Sqlserver:[SQL] AS BEGIN UpdateT_MtSetStat = @ Stat, OStat = @ Stat, RptTime = Getdate

1.5.1.3Raw Devices Raw devices are disk partitions or logical volumes that have not been formatted with a file system.When you use raw devices for database file storage, Oracle writes data directly to the partition or volume, bypassing the

Oracle Database cursor and stored procedure Spool abc. log -- start logging Create or replace procedure db. PROC_FIRST (flag out interger,T_DATE IN VARCHAR2) AS Varno varchar2 (20 );Varprice varchar2 (20 ); CURSOR mycur (vartype number) isSelect emp_

Creating tables in Oracle to hook the same or consistent tables can also be used in many cases. Convenient. For example, a department table exists as follows: SQL> select * from dept;       DEPTNO DNAME          LOC   ------ --------------

When performing a redolog loss recovery test, you can delete Oracle redolog in the open Database state, and the database still works normally. The database can perform regular operations, or even create tablespaces, perform log switching, and

Conn/as sysdbaCreate undo tablespace undotbs3 datafile 'd: \ lx \ undotbs03.dbf 'size 2 m;Alter system set undo_tablespace = undotbs3; Sess1:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~Drop table test_undo;Create table test_undo as select *

Branch Structure Decode   If expr1ThenAction1Elif expr2ThenAction2...ElseDefault_actionFi Decode (expr1, search1, result1, search2, result2,..., default)Only equivalent comparison can be performed. SQL> select ename, deptno, decode (deptno,10, 'aaa

Oracle 11g Release 1: http://www.oracle.com/technology/software/products/database/index.html RHEL5 under the ASMLib2.0: http://www.oracle.com/groovy/global/cn/tech/linux/asmlib/index.htmlopen the page, will find a Red Hat Enterprise Linux 4 AS (x86)

Scenario: After the program is modified, upload it to tomcat on the application server. After restarting tomcat, an exception occurs! The front-end nginx Server Load balancer has a 504 error and the website cannot be opened! Troubleshooting: After

Sys @ DEX>Select*FromV $ statnameWhere Name Like '% Sort %'; STATISTIC #NAMECLASS STAT_ID ---------------------------------------------------------------------- 565 sorts (memory) 64 2091983730 566 sorts (disk) 64 2533123502 567 sorts (Rows) 6