Oracle

1. Connection host string, said no listener SVRMGR> connect internal/oracle @ orcl; ORA-12541: TNS: no listener SVRMGR>2. Run the listener to indicate that the protocol-specific component of the address is incorrectly specified. C:> lsnrctl LSNRCTL

You can grant the Autotrace permission to Everyone using the following methods,If you need to restrict the Autotrace permission, you can change the public authorization to the specific user authorization.D: \ oracle \ ora92> sqlplus/nologSQL * Plus:

Few enterprises now have a complete methodology to turn SOA into reality, which makes Chinese enterprises that are or are trying to implement SOA somewhat skeptical. In August 4, Oracle officially released its "five steps to SOA" solution, which can

Many people know that the Oracle listener has always had a security risk. If security measures are not set, users who can access the listener can close the listener remotely.Example:D: \> lsnrctl stop eygleLSNRCTL for 32-bit Windows: Version 10.2.0.3

This article introduces the import and export of Oracle Data imp and exp commands, and describes the corresponding parameters. Drills to deepen understanding.At last, the article discusses the problems that may occur when using these two commands

The complete execution sequence of the SQL Select statement:1. The from clause assembles data from different data sources;2. The where clause filters record rows based on specified conditions;3. The group by clause divides data into multiple groups;4

Ora-32035 error reportedIf the with clause is defined and is not used in a query, A ora-32035 error is reported: the query name defined in the with clause is not referenced. (At least one with query name is not referenced. The solution is to remove

The current system time is the week of the year. Copy codeThe Code is as follows:Select to_char (sysdate, 'ww '), to_char (sysdate, 'iw') from dual;Select to_char (sysdate, 'ddd ') from dual;Select TRUNC (SYSDATE, 'mm') from dual; 1)The ww algorithm

SQL codeCopy codeThe Code is as follows:Select count (*) from user_objects where object_name = upper (p_table_name );Select count (*) from user_tables where table_name = upper (p_table_name );Create or replace procedure p_drop_table_if_exist_v1

Dbms_random is a random function package provided by oracle. The following describes common examples of dbms_random:Dbms_random.value usage:Generate a 38-digit decimal number greater than or equal to 0 and less than or equal to 1Copy codeThe Code is

[SQL]Copy codeThe Code is as follows:Create table wlbtest1 (Username varchar2 (2 ),DeptID number);Create table wlbtest2 (DeptName varchar2 (10 ),DeptID number);Insert into wlbtest1 values ('A', 1 );Insert into wlbtest1 values ('B', 1 );Insert into

When the data in the table is not required, Delete the data and release the occupied space. To Delete the data in the table, use the Delete statement or the Truncate statement.I. delete statements(1) conditional DeletionSyntax format: delete [from]

Today, the virtual machine is configured with an ip address, so that the virtual machine and the host are in the same network segment, and then webservice is used successfully, but a new problem arises, and oracle cannot be connected.I found that

Software environment:1. Operating System: Windows 2000 Server2. Data Base: Oracle 8i R2 (8.1.7) for NT Enterprise Edition3. installation path: C: ORACLEImplementation Method:1,D:> set NLS_LANG = AMERICAN_AMERICA.USACII7OrD:> set NLS_LANG =

Copy codeThe Code is as follows:Select a. f_usernameFrom(SELECT/* + parallel (gu, 4) */distinct gu. f_usernameFROM t_base_succprouser guWhere gu. f_expectenddate> (select trunc (sysdate, 'y') from dual)And gu. f_lotid = 1And gu. f_playid = 4And gu.

Duplicate data may be in the following two cases: the first is that only some fields in the table are the same, and the second is that the records in the two rows are the same.1. Deletion of duplicated data in some fields 1. query duplicate

Use the dbms_random package of oracle combined with rownum. For example, 499 users are randomly selected:Select * from(Select * from busi. t_ar_userinfo order by dbms_random.value)Where rownum: References for dbms_random, link:

I believe that three appropriate indexes should be created, that is, the appropriate number of indexes should be created on the appropriate tables and columns. Although this can be summarized in one sentence, the database administrator must make

Create or replace procedure PROC6338196642095312503719 (enter the news topic Varchar2, enter the news content Varchar2, enter the publishing time Varchar2, enter the current page Number, enter the Number of lines per page, and output the current

The Update in an Oracle SQL statement can be used with SEQUENCE to Update the continuous numbers of values of a field without having to traverse and Update database records one by one using a cursor. For example, update sample set id =