Oracle

During Oracle use, we can generate data files via PL/SQL or spool on spool off, but in some environments we need to process the data through stored procedures, the data is processed, the data files need to be automatically generated, and the manual

I. DML operations on a view1. Create a View V_personCreate or replace noforceview V_personAs Select * from the person where ID between 1003 and 1007;2. Insert operation into view V_personInsert into V_person (id,name) values(1010, ' J ')"Note" The

I. Reasons for not exporting empty tables1, oracle11g default to Empty table is not assigned segment, so use EXP export oracle11g database, empty table is not exported.2. After setting the Deferred_segment_creation parameter to False, both the empty

Oracle divides users into two categories: "System" and "SYS" The "system" user can only log in to EM with normal status. (Can be regarded as a general member of the company) "SYS" User has "SYSDBA" (can be regarded as the CEO of the

I. Classification of RightsSystem permissions: The system specifies the user's permission to use the database. (System permissions are for users ).Entity permissions: A permission user's access to other users ' tables or views. ( for a table or view

View the commands for monitoring listener LSNRCTL statusTurn off monitoring Lsnrctl stopStart monitoring Lsnrctl StartRegister for monitoring alter SYSTEM register (requires connection to database [email protected]>alter system register; Manual

1, manually change the size of the data fileSql>conn/as SYSDBASql>createtablespace exampletb datafile ' e:\ examp01.dbf ' size 10M;Sql>alter database datafile ' E:\examp01.dbf ' resize 20m;Sql>alter database datafile ' E:\examp01.dbf ' resize 9m;2.

   today is April 5, 2016, the previous study plan has not been implemented, found that they are still a weak willpower people! No matter how busy the future, all hope that they can put the study plan to persist, with empty mentality to re-learn

There is a special time display type--timestamp timestamp in OracleUsually we convert the current time into a timestamp with the following syntax:Select cast (sysdate as timestamp ) from DualIn a JSP page, you need to get a timestamp field to

Grey Original address:http://www.cnblogs.com/greyzeng/p/5346833.html ?Environment: Windows 10 Professional Edition Oracle Database 12c Release 1 ?Flashback ExampleScenario 1:? Create a new table

Create a view using the system SYS or DBA authority account as follows:1. It is mainly obtained from table dba_data_files,dba_segments two tables in the database.2. The default database holds a byte unit, and the conversion relationship is as

Oracle Four-sheet EMP Dept Salgrade bunus Structure, remembering the benefits of later SQL statement learning employee table (EMP) No. field type description 1 empno

Using DBCA, the Global database name is: prod.origtec.com Sid:prod An Oracle database was uniquely identified by a Global database name,typically of the form "Name.domain" Global Database Name: A database is referenced by at least one Oracle

Flash back Technology (flashback) starts with a 9i version of the flashback query, and is applied in the 10g version, and is enhanced in 11g11g Flash back technology projects:Flash Back Database technologyEnabling the database to roll back quickly

Operation of sequence in Oracle and initialization of sequence before use create sequence creation sequence Myseqstart with 1increment by 1nomaxvalueminvalue 12 initialization sequence Select Myseq.ne   Xtval from dual; it is worth noting that if

Oracle does not have functionality such as a self-increment field, but it can be implemented through triggers (trigger) and sequences (sequence).Build a test table first:CREATE TABLE Userlogin(ID Number (6) is not NULL,Name VARCHAR2 (+) NOT NULL

1. Basic StructureCREATE OR REPLACE PROCEDURE Stored procedure name(Parameter 1 in number,Parameter 2 in number) isVariable 1 INTEGER: = 0;Variable 2 DATE;BEGINEND Stored Procedure Name2.SELECT into STATEMENTStoring the results of a select query in

0007 notes 03-Summary and grouping data in SQL, SQL: Yes 03- 1. In some cases, the summary value of the data is required, rather than the data itself. For example, for some data, the sum, count, the maximum and minimum values, and the average value,

Oracle mathematical functions This article summarizes Oracle mathematical functions. We will share this with you for your reference. The details are as follows: 1. Absolute Value: abs () select abs(-2) value from dual; 2. Take the entire function

0003 64-bit Oracle11gR2 cannot run SQL Developer solution, 0003oracle11gr2 "SQL Developer" under "Application Development" double-click unavailable, "Windows is looking for SQLDEVELOPER. BAT "tips, such as: Search blog garden, find: