Oracle

Today in the review project code to see such a problem, there is a number table, each time you need to randomly take 6 free numbers from such a table, that is, each time the 6 numbers are taken out should be different. And then I saw this SQL.Select

      A colleague said the day before that one of the servers that had an AIX RAC restarted the operating system, the resources of the cluster resource CSSD are always in the start state, and check the log output for the following: [   cssd][1286

http://xxciof.blog.163.com/blog/static/7978132720095193113752/The connect by prior recursive algorithm in OracleOracle in Start With...connect by prior clause usageconnect by is used in structured queries, and its basic syntax is:Select ... from

Overview under the Oracle installation directory $home/network/admin, you often see Sqlnet.ora Tnsnames.ora Listener.ora these three files, in addition to Tnsnames.ora, the other two files detailed use many people do not understand.The Sqlnet.ora is

1 --View table Space capacity2 SELECT UPPER(f.tablespace_name) "tablespace name",3 D.TOT_GROOTTE_MB "Table space size (M)",4D.tot_grootte_mb-f.total_bytes "used Space (M)",5To_char (ROUND((D.TOT_GROOTTE_MB-F.total_bytes)/D.tot_grootte_mb* -,2),'990.

This case is the coffee sales situation input query systemFirst, the data input system:1. Design the Input Information pageThe code is as follows: Coffee Management System--input system Welcome to Input System Coffee name: Suppliers Id:Product Price:

It seems that some people still do not understand the true meaning of the schema, and now I have to tidy up a bit, I hope to be helpful to everyone.Let's start by looking at their definition:ASchemais a collection of the database objects (used by a

Using Sqlplus to connect Oracle database times wrong:[Email protected] ~]# sqlplus oracle/[email PROTECTED]//10.5.0.7:1521/SSPSql*plus:release 11.1.0.7.0-production on Thu June 26 10:16:21 2014Copyright (c) 1982, the Oracle. All rights

1. Knowledge points--First stored procedure/* Print Hello worldcreate [or replace] PROCEDURE procedure name (parameter list) as Plsql subroutine body; Call stored procedure: 1. exec SayHelloWorld (); 2. Begin SayHelloWorld (); SayHelloWorld ()

Recently because of the upgrade of Mac OS X 10.10 Yosemite, suddenly a few days ago, a night, the boot found stuck in the start-up interface, it seems that beta is not reliable, and then think of themselves this is not a few days ago back up,

One: First query the database whether to open the archive mode:sql> archive Log list; ----Archive mode is turned onDatabase Log Mode Archive modeAutomatic Archival EnabledArchive Destination Use_db_recovery_file_dest----Modify this archive

Step one: If open Java is already installed on the system, you need to clean it up and skip the processsudo apt-get purge openjdk*Step Two: Installsudo apt-get install Software-properties-commonStep three: Add a trusted software source:sudo

Testing the importance of OLR in Oracle 11g clusterCalled an Oracle local Registry (OLR): All node in a cluster have a Local Registry for node-specific ResourcesTest one: Simulate the OLR abnormal loss situation:Here first will OLR Renam[Email

/*The following code is the display width setting for the EMP Table/dept table/salgrade table*/Col empno for 9999;Col ename for A10;Col job for A10;Col Mgr for 9999;Col hiredate for A12;Col Sal for 9999;Col Comm for 9999;Col deptno for 99;Col dname

Get table: Select table_name from User_tables; The current user's tableSelect table_name from All_tables; All users ' tablesSelect table_name from Dba_tables; including system tablesSelect table_name from dba_tables where owner= ' user name

/*abs (N)Returns the absolute value of the value specified by the parameter n (if the parameter value is NULL, the returned result is null, the same as below). */--select ABS ( -3.14) from DUAL; --3.14/*round (n[, M])Returns the result of rounding

The DECODE function is one of the powerful functions of oracle pl/SQL. Currently, only oracle SQL provides this function, and other database vendors do not yet implement this function. What is the purpose of DECODE? First, let's construct an example.

I. Note: Some tables in the OLTP database have a large amount of data and a large amount of data is continuously increased every month. Because historical data is not accessed in this database, it is analyzed in another OLAP database, therefore,

1. Knowledge Point -- The First stored PROCEDURE/* prints Hello Worldcreate [or replace] PROCEDURE process name (parameter list) as plsql subroutine body; Calls stored PROCEDURE: 1. exec sayHelloWorld (); 2. begin sayHelloWorld (); end;/*/create or

I believe that the 99 SQL statements are handled, and the basic Oracle test is just like playing (the most comprehensive and most typical entry-level Oracle query statements in history) 1. select * from emp;2. select empno, ename, job from emp;3.