Oracle

  1. Poor connection managementEach time an application interacts with a database, the connection is opened and closed. This problem is often related to stateless middleware in the application server. It affects performance by more than two orders

On Windows, you can set a task to start some tasks at regular intervals, for example, once a week or once a day. I also saw a lot of applications write PL/SQL batch in Oracle, and then use Windows task to start these batch, which is quite tedious.

If only English software is used, character sets are rarely considered. However, if other languages are used, character sets must be considered. Otherwise, a lot of garbled characters may occur accidentally.   Many other software also has

 I. syntax and Principles of the update Statement 1. Syntax single table: Update table name set column name = new value where column name = A value such as: Update t_join_situationset Join_state = '1' whereyear = '000000' the join_state field of the

The unique identifier generated by Oracle is different from that generated by SQL and Sybase. It uses a serial number generator. The serial number generator is a database object. The following statement creates a serial number generator SQL

Query roles of a user:Select grantee, granted_role from dba_role_privs where grantee = 'wjw ';Query the system permissions of a user:Select grantee, privilege from dba_sys_privs where grantee = 'wjw ';Query the system permissions of a role:Select

Create user _ authorization _ in Oracle and import data Complete process: create users, create tablespaces, authorize, and create tables L create a user  Create user BBS identified by bbs123;    L create a tablespace

  Oracle permission command favorites   Default User and password in Oracle9i: Sys/change_on_install [as sysdba], System/Manager Scott/Tiger     1. permission management   DBA login Conn/As sysdba   Create user myusername identified by

 Create a user in Oracle and set the permission _ basic cmd C:/> sqlplus SQL * Plus: Release 9.2.0.1.0-production on Saturday September 29 15:08:34 2007 Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved. Enter the User name: SYS as

A project needs to monitor data changes in a table, and then generate a file to the disk based on the change results to facilitate monitoring by log capturing programs. You need to use the util_file package that comes with Oracle. The target

Create or replace procedure zzsj. trim_table (v_table_name in varchar2) isBeginDeclareOut_string varchar2 (9999 );BeginIf v_table_name is not null thenBegin-- Create TableSelect SQL _createInto out_stringFrom v_trim_sybaseWhere table_name = upper (v_

1. Add Columns Alter table table_name add (column datatype [Default expr] [, column datatype...]); For example: SQL> ALTER TABLE emp01 add Eno number (4 ); 2. Modify column Definitions  For example: SQL> ALTER TABLE emp01 modify job varchar2 (1

1. create a backup folder in drive D, such as: D:/database backup; create five (up to 7) subdirectories, such as D:/database backup/Monday, D: /database backup/Tuesday ,......, this ensures weekly backup;2. Create five batch files under the

The main process of SQL parsing in Oracle: The cursor concept we mentioned is complicated. It can be a cursor in a client program, a private cursor in a service process, and a shared cursor in a server shared pool. If a cursor is opened, its

Two different database servers read data from one user on one database server from another database server. In this case, you can use dblink. In fact, dblink is similar to the view in the database. When creating dblink, you need to know the IP

When Oracle checks the operating system compatibility, it does not pass the check. At this time, when we click "Next" for installation, it cannot be installed. The error message in the second picture is displayed, therefore, Oracle can only be

The content of the example export9.par is as follows: USERID = CTGPC/xuyunsheng @ ctgpcwebOWNER = CTGPCROWS = YINDEXES = YGRANTS = YCONSTRAINTS = YCONSISTENT = Y (Note: CONSISTENT indicates consistency. CONSISTENT = Y indicates that when multiple

Environment: RHEL 3, Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 SQL> connect sys/passwd @ db as sysdba;SQL> col name for a30SQL> col value $ for a30SQL> select name, value $ from props $ where name like '% NLS % ';Name value $--------

　 Preface In the past decade, Oracle has become one of the world's most professional databases. For IT experts, IT is to ensure that their company's productivity is improved by leveraging the powerful features of Oracle. One of the most effective

After so many days, we have finally been able to make things easier. The oracle-driven QOCI of qt is finally compiled today. The connection is successful !!! Qt cial only comes with SQLLite and ODBC drivers. oracle drivers must be compiled by