Oracle

Six errors and solutions that Oracle beginners often encounter:1. ORA-12541: TNS: No listenerCause: the listener is not started or damaged. For the former, run the net start OracleOraHome81TNSListener command (the name may be different). For the

1. What is registration?Registration is to register the database as a service to the listener. The client does not need to know the Database Name and Instance name. It only needs to know the service name provided by the database to external users

Oracle developer is famous for its rapid data processing and development, and its exception handling mechanism is also relatively complete.1. Advantages of exceptionsIf no exception exists, check whether each command succeeds or fails in the program,

AbstractThis article takes Oracle database as an example to introduce a simple and common form data storage processing method for developing WEB applications using JSP technology to reduce the development workload and provide the main program

SQL> select to_char (sysdate, 'yyyy-mm-dd') from dual;SQL> select to_char (sysdate, 'hh24-mi-ss') from dual;Mysql> select date_format (now (), '% Y-% m-% D ');Mysql> select time_format (now (), '% H-% I-% s '); Date Functions Add a month:SQL> select

Add function to oracle date add operation in SQL Server Oracle date add minutesHow does one add a day/hour/minute/second to a date value?Submitted by admin on Wed, The SYSDATE pseudo-column shows the current system date and time. adding 1 to SYSDATE

I. System Environment 1. Notebook: 3 GB memory Hard Disk 500 GB Operating System: window xp sp3 2. Virtual Machine environment: Operating System: Windows server 2003 Enterprise (pack 2) Memory Allocation: 1.5 GB Virtual Memory: 3 ~ 6G (try to be as

Oracle EBS provides multiple forms of report development and output. MS Excel has obvious advantages in data processing, and opening report output in Excel is a common development item. However, because Excel is "too intelligent and not intelligent",

1. Shut down the database[Oracle @ RHEL5] $ sqlplus/as sysdbaSQL> shutdown immediate;Ii. Disable listening[Oracle @ RHEL5] $ lsnrctl stop3. Delete oracle_baseI switched to root here.[Root @ RHEL5] # rm-rf/s013. Clear residual files[Root @ RHEL5] #

1) create a storage directoryMkdir backup2) Write a shell script #! /Bin/bashExport ORACLE_BASE =/opt/oracle -- the path must be changed according to the actual path.Export ORACLE_HOME = $ ORACLE_BASE/ora10gr2/db_1 -- the path must be changed

1. The case when expression has two forms:Copy codeThe Code is as follows:-- Simple Case FunctionCASE sexWHEN '1' THEN 'male'WHEN '2' THEN 'female'ELSE 'others' END-- Case search functionCASEWHEN sex = '1' THEN 'male'WHEN sex = '2' THEN 'female'ELSE

In Oracle queries, if there is no sorting, but you want to route the information of a specific value in a column to the front, use the decode (field, 'field value', number) of oracle) For exampleSelect name from all data queried by the user. If you

1. Convert string type to timestampCopy codeThe Code is as follows:Select to_timestamp ('01-October-08 07.46.41.000000000 AM ', 'dd-MON-yy hh: mi: ss. ff am ')From dual;2. Convert timestamp to date typeCopy codeThe Code is as follows:Select cast (to_

The server is windows server 2003. After the oracle client is installed normally, when data is inserted, all Chinese characters are displayed ?. Exception: Enter select userenv ('language ') From Dual in the PLL/SQL statement, and the result is

In oracle, The utl_file package provides some functions and procedures for operating text files, and learns their basic operations.1. Create a directory and authorize the userCopy codeThe Code is as follows:-- Create directoryCreate or replace

When you export the data of USERNAME user of Data A and then import it to USERNAME in database B, the following problems occur during table data query by USERNAME User:ORA-06550: 1st rows, 7th columns:PLS-00201: The identifier 'System. PROC_AUDIT

1. If the Console is not installed on the database machine or the network service name is not configured using the Console.You can log on to the idle process on the server by running the command sqlplus sys/sys as sysdba. See step 4.2. If the

I recently used oracle rownum for paging display, and made further analysis and research on rownum. This is summarized as follows, hoping to benefit everyone.For rownum, it is the number of the row returned from the query that is sequentially

1 \ flash the table back to a certain time point:Enable the row movement function before the flash back operationSQL code Alter table emp enable row movement;Execute the flash back statement:SQL codeFlashback table emp to timestamp to_timestamp ('000

During development, a cursor containing a table that does not have fields may be declared to solve special problems. This article will introduce such problems in detail. For more information, seeData. * is a table, and then the fields in other