Oracle

//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

1. Monitor whether the index is usedIn addition to the primary key being an integrity constraint and automatically becoming indexed, the purpose of creating a normal index is to improve the query speed, and if we create indexes that are not used,

----------------------------------------------------------------------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 ...

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

Enter cmd-->SqlplusSysAs SysdbaTo delete a table space:DROP tablespace tseve_data including CONTENTS and datafiles;To create a table space:Create Tablespace Tseve_dataLoggingDataFile ' D:\allworkplace\oracleWS\TSEVE_DATA.dbf 'Size 50mAutoextend

Sqlplus-s/As SysdbaSet Trimspool onSet Linesize 10000Set pagesize 50000Set heading onSet term offSet heading onSet feedback off;Set NEWP none;Set echo offSet markup HTML onSpool onSpool Xj.xls--Table Space usage query:Select

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%

PublicListCREATEZTREEDEP (String compid) {List DD =NewArraylist(); Find SQL statements for all child departmentsString SQL = "Select Dep_id,dep_name,super_id,folder from Td_department" + "Start with super_id in (" + "Select dep_id from Td_department"

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

Oracle Connect by usageExperiment with the EMP table from the Scott user first.EMP table has a field, one is Empno (employee number), the other is MGR (higher manager number)Here is all the data in the table1SELECT * from emp start with empno=7698

1. Single Grouping function650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/72/F2/wKiom1XwLKPAAOrjAAB9Ym73cYI651.jpg "style=" float: none; "title=" 2015-09-09_204103.png "alt=" Wkiom1xwlkpaaorjaab9ym73cyi651.jpg "/>650) this.width=650;

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

Excerpt from: http://www.linuxidc.com/Linux/2012-07/66288.htm1thDual is not an abbreviation but a complete word. Dual noun means logarithm, when doing adjectives refers to two heavy, two yuan.2ndThe dual table in Oracle is a single-row,

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

Previous time to do questionnaires, customers create custom questionnaire content, including topics and options content;Then you need to go around the questionnaire,,,, trouble.So to search the internet everywhere, there is no direct result, and

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 \