Oracle

Transferred from: http://blog.csdn.net/liusong0605/article/details/16349121After completing the installation of Oracle and starting the service, you cannot log on by Sqlplus and the following error occurs:SP2-1503: Unable to initialize Oracle call

SELECT * FROM (select T1. table_name as "table name", t3.comments as "table description", T1. column_name as "field name", T1. Data_type as "data type", T1. Data_length as "Length", T1. NullAble as "is empty", t2.comments as "field description", T1.

//login Command sqlplus sys/oracle as sysdba;    //sys/oracle  for   username/password//delete table space  mofdrop tablespace mof including  contents and datafiles cascade constraints; //Delete User  yaojiandrop user  yaojian cascade; //CREATE

Oracle Configuration Tnsnames.ora File InstanceIn order to connect with the server, the client must first contact the listening process on the server. Oracle describes the connection information through the connection descriptor in the Tnsnames.ora

This is written by a master in my collection to remind myself of Oracle learning Route1, SQL, PL/SQL (There are a lot of videos online, you can do a simple start, then read a few books, do more experiments）As the basic skill of Oracle, we need to be

#encoding: Utf-8#dataProc#auth XiajikunImport Sys# Oracle Library Connectivity ModuleImport Cx_oracle# MySQL Library connectionImport MySQLdbImport timeImport OS#水电煤库# SDM = ' username/[email protected]:p ort/servicename 'Db_ora_str = ' Admin/[email

Oracle laying off its Java evangelists? Er, no comment, says OracleSoon-to-be-redundant chap in pink slip slip on Facebook4 Sep at 23:04, Simon SharwoodOracle appears to is making redundancies in the ranks of its Java evangelists team.One of the

----------------------------------------------------------------------User:Dba_users storing information for all users----------------------------------------------------------------------Table:Dba_tables store all tables for all usersUser_tables

CREATE TABLE SpaceCreate TABLESPCE Test datafile ' D:\TEST01.ora '; Create userCreate user test identified by test01; Authorization to the userGrant Create table,unlimited tablespace to test;--can also authorize select Insert and more ...

Restart the Oracle database and listener summary under Linux:Method 1:Log in to Linux with root SSH and open the terminal to enter the following command:CD $ORACLE _home #进入到oracle的安装目录Dbstart #重启服务器Lsnrctl Start #重启监听器CD $ORACLE _home

1. Execute sql:select/*+ Parallel (a,4) * * from Tf_f_user a where rownum2. How to view the parallel number of the SQL statement:Select T.sql_text,t.sql_id,s.sid from V$sql t,v$session s where t.sql_id=s.sql_id and t.sql_text like '%rownumExecuting

Write it here so that you can query after you forget the format later.CREATE OR REPLACE FUNCTION temp_func_wyl (pi_aaa100 VARCHAR2, pi_aaa102 VARCHAR2)-Dictionary conversion, convert code values to

NODEJS connection to Oracle database, official details of each platform document:https://github.com/oracle/node-oracledb/blob/master/INSTALL.mdMy Nodejs is connected to Oracle's configuration, operating environment:Windows7 x64Nodejs 0.12.7Python 2.7

Sql> CREATE TABLE T_long (ID number, long_col LONG);The table is created.Sql> INSERT into T_long VALUES (1, Lpad (1, 32767, ' HELLO world! '));1 rows have been created.Sql> COMMIT;Submit complete.Sql> SELECT * from T_long WHERE long_col like '%world%

1. Error ORA-30009 when manufacturing dataTo schedule a task:Insert into Select from by rownum100000There will be ORA-30009 connect-by errorTo modify a task:Insert into Select from xmltable ('1 to 100000')Use XMLTable to accumulate2, Tns:no

Sqlplus's autotrace is a very simple and convenient tool for analyzing the execution plan of SQL, and is a very useful tool in most cases. The SQL execution plan and execution status provided by the Autotrace tool provide the basis for optimization

1. Parse tables and indexes (analyze does not rebuild the index)Analyze table TableName COMPUTE statisticsEquivalent to analyze table TableName compute statistics for table for all indexes for all columnsStatistics for table exist in views:

In fact, the XML string is like an external table in Oracle, so Oracle has some rules for parsing XML strings that are very demanding. The data provided by the XML string is a table, so Oracle must provide a column header that is consistent with the

The requirement is to compare the values of the last two months and test the data! So I use self-correlation to put two months of data on one line and then compare it! The SQL statement resembles the following: Select B.NY,B.DWDM,。。。。 , a.js as

Oracle starts with pfile or spfile, oraclepfilespfile Oracle 11GStart a database using pfile Startup pfile = 'pfile parameter file Path'   Oracle 11GUse spfile to start a database Spfile = Windows default directory % ORACLE_HOME % \ database \