Oracle

Create user [username] identified by [Password] Create a new user Grant permission 1. Permission 2... to grant the user the permission to create a user Ex: grant create session to [username] at this time, you can only connect to the database

The database is Oracle 10g 32-bit. Client 1 is an Oracle 10g 64-bit client. Client 2 is an Oracle 10g 32-bit client.   (1) Use client 1 for query. Data cannot be queried when the query condition contains Chinese characters. (2) query using

The database must first have the ctxsys user and ctxapp role Database users assign ctxapp roles Make sure that the LSNRCTL is running on the Oracle server. The plsextproc service is started. Create Table tbl_1 (ID int primary key, title

Details: In the Oracle database, log on to SQL * Plus using system,   Run the startup command to prompt the ORA-01031, with insufficient permissions. Note: Here system is the DBA permission! Solution: It is strange that since it is a DBA, how

Original article: Http://qa.taobao.com /? P = 7887   Since Oracle introduced the automatic management of memory parameters for 10 Gb, it seems that the problem of sga pga parameter settings that had plagued DBAs has been gradually ignored. Yes.

To_date ("string to be converted", "format to be converted") The format of the two parameters must match. Otherwise, an error is returned. That is, the first parameter is interpreted according to the format of the second parameter. To_char (date,

The set operation has three types of operations: Union, intersection, and difference. Union: returns the union of two query results and removes duplicate rows automatically. Union all is not sorted: the Union set of the two query results is obtained,

Some netizens have raised some very basic questions, such as whether a function has implemented a certain function, what is a function used for, and what is the format, at the same time, I also felt my lack of knowledge about Oracle functions, So I

Oracleorahome81agent-Oracle intelligent agent. Similar to SNMP. Used with OEM, among other things. Oracleorahome81appserverlistener-listener for Oracle apps Oracleorahome81clientcache-used for Oracle names server cache Replication

Modify the character set of Oracle 10 GB Modify the database character set to zhs16gbk.View server character setsSQL> select * from V $ nls_parameters;Modify:$ Sqlplus/nologSQL> Conn/As sysdbaIf the database server has been started, run shutdown

I. Overview Oracleebs is an Oracle ERP product. This product is very large and can provide powerful management functions for all aspects of the enterprise. Generally, some of its modules are used by large enterprises, depending on the nature of

First, log on to sqlplus. SQL> sqlplus Scott/Tiger We can add the suffix 'look _ for_me 'After the trace file to facilitate searching for the trace file. We do not add any of the following examples.

The table that PD imports to Oracle is not working properly and the error "ORA-00942 table or view does not exist" is reported Cause:Note the quotation marks and the Case sensitivity of table names when using PD and Oracle connections. scripts

After testing on Oracle10g, other clients should be similar. Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> Registrykey HKLM = Registry. localmachine;Registrykey hksoftware =

[Application Scenario] many colleagues have asked me about pseudo columns. I mainly want to add some serial numbers = when exporting data. In fact, pseudo columns have many functions. Official reference: Oracle Database SQL Language Reference 1

The instead of trigger can be used to insert, update, delete, and merge tables in a view composed of more than one table. Instead of can also be used to create partition tables. Syntax for creating an instead of trigger: 1 Create [or replace]

private dB link check the password, Public dblink you can also see the password. You just need to use sys query user logon. query dblink User password , use sys login Select*FromSys.Link $; Select*

Subject: how to clean up after a failed Oracle clusterware (CRS) Installation Doc ID: 239998.1 type: Bulletin Modified Date: 18-Mar-2009 status: published Purpose------- The purpose of this document is to help DBA's and support analysts

Create Table extnl_table ( Col01 varchar2 (100 ), Col02 number, ...... )Organization external(Type oracle_loaderDefault directory "XXX"Access Parameters(Records delimited by 0x '0a' skip 1 fields terminated by', 'enabledby' "'lrtrim missing

For beginners, Oracle's database language PL/SQL is always a bit strange. It is called a host language and, as its name suggests, it is dependent on something to survive, PL/SQL is attached to the Oracle database, and its runtime environment is the