Oracle

Name, businesscode, a. account Zhou Qiao 18929609222 3754031157710000Miao medicine 18929609233 3754031157712344Lingdan 18929609189 3754031157710000Zhou Qiao 13329609189 3754031157713333 Find all the records with the number of account occurrences

The log file $ ORACLE_BASE/admin/orasid/bdump/alert_orasid.log of the ORACLE database records the duplicateFor log conversion, database startup and shutdown, database structure change, rollback segment modification, deadlock, internal error and

I. Set the environment variable [oracle @ orcl ~] $ Cat. bash_profile#. Bash_profile # Get the aliases and functionsIf [-f ~ /. Bashrc]; then.~ /. BashrcFi # User specific environment and startup programs ORACLE_SID = orclORACLE_BASE

ROUND and TRUNC ROUND (n1, n2)Perform rounding for n1 according to n2. n2 is 0 by default, that is, the n1 is rounded up. If n2 is a positive number, it is rounded up from n2 to the right of the n1 decimal point. If n2 is a negative number, then, it

  HelloJin said that the data synchronized by their OGG may contain garbled characters and the entire method should be checked. After half a day of discussion, I did not find any good method. I can only query each table and each record, and then

  Consider this scenario: when a task waiting for processing is added to a database table, the PROCESSED_FLAG column of the table has only two values: Y and N. This column value is N (not processed) for records inserted into the table ). When other

(1) Pfile Pfile (Parameter File) is a Parameter File in text format that contains database configuration parameters.Oracle 9i creates a Pfile for each database during installation. The default name is "init + routine name. ora", which is a text file

  1. When using Oracle, Oracle can run normally by starting OracleServiceMYORCL and OracleOraDb11g_home1TNSListener; 2. To allow hosts on the LAN to access your oracle database, you must start the oracleora81homemanagermentserver service. Note:

  When using spfile, you can use the v $ parameter. ISSYS_MODIFIABLE field to determine the initialization parameters that can take effect without restarting.   V $ parameter. ISSYS_MODIFIABLE parameter Indicates whether the parameter can be changed

1. Users and Roles Overview: Oracle is similar to Window. Instead of assigning permissions to users directly, they use roles and groups. Window is a group, while Oracle is a role. users belong to roles and groups. In this way, the user's permissions

Common database objects in Oracle-ViewI. view definition: Logical Data Set extracted from the tableA) a view is a virtual table.B) The view is built on an existing table. The view depends on the created tables, which are called base tables.C) the

1. different concepts: connections refer to physical network connections. Establish a session between the client and oracle on the established connection. Later, the interaction between the client and oracle will be conducted in a session

Use the linux File handle to restore the Oracle Data File test environment accidentally deleted: OEL + Oracle 11.2.0.1 first check the current data file and Data File status: SQL> select file_id,tablespace_name,file_name,status from dba_data_files;

In the desc table of oracle, the name and type Columns cannot be formatted. (The placeholder is too long.) oracle cannot format the oracledesc column name. The placeholder is too long. When we play Oracle today, in my desc table, I often find that

After preparing environment variables for oracle installation, or before installation (if you know your installation path), you need to prepare the path related to oracle (environment variables), such: ORACLE_SIDORACLE_BASEORACLE_HOME  Modify the

Oracle12c installation error: PRVF-0002 solution. /runInstaller launch graphical error PRVF-0002: cocould not retrieve local nodename. check the error message: [root @ test68 OraInstall2013-09-06_04-43-39AM] # cat installActions2013-09-06_04-43-39AM.

ORA-28150 proxy users do not have access to resolution ORA-28150: proxy not authorized to connect as client Cause: A proxy user attempted to connect as a client, but the proxy was not authorized to act on behalf of the client. action: Grant the

ORACLE uses RMAN to manage archived logs. oracle usually uses rman to manage archived logs. Normally, the 1 expiration policy can be deleted as part of the Backup set. Crosscheck archivelog all; delete expired archivelog all;  2. Based on the

Memory modification for oracle11g rac asm instance Memory_max_target (which is a static parameter and needs to be restarted after modification) memory_target (which is a dynamic parameter and does not need to be restarted) SQL> select name,

Using PL/SQL profiler to locate PL/SQL bottleneck code for SQL optimization, you can use SQL tuning advisor to achieve automatic SQL optimization and adjustment. For PL/SQL code, there are both SQL code and PL/SQL code. It is far from enough to use