Oracle

My Oracle database was installed last November and then configured, and then it was normal, no problem, but then I didn't use my local Oracle, and PL/SQL was always a colleague's machine, Then today suddenly want to do some tests on their own

When creating a table, add a NOT NULL constraint to the column in the following form:column_name Data_type[constraint constraint_name] NOT NULLWhere constraint constraint_name represents the specified name for the constraint.You can also add a NOT

1 Problem descriptionPreviously wrote a blog to delete the Oracle home directory, refer to:Linux platform mistakenly delete home Oracle root directory solutionhttp://blog.csdn.net/tianlesoftware/article/details/43794273This is the depth of this side,

This document is based on the relevant data collated, summarized, mainly on the Oracle database, to obtain the most authoritative and correct method of SQL statement execution plan, and also explained in detail the meaning of the options available

Comparison operator:> greater than,>= greater than or equal, = equals,!=,<>,^= not equal toPrecedence of logical operator operations: not > and > OR ( parentheses can be used if you want to change the order of precedence )Special operators:[NOT]

1: List all employees ' names, department names, and wagesSelect A1.ename,a1.sal,a2.dname from emp a1,dept A2 where A1.deptno = A2.deptno;2: List details of all departments and number of departmentsSelect A2.deptno,a2.dname,a2.loc,count (a1.empno)

Minor version upgrades for Oracle: Upgrading from 10.2.0.1 to 10.2.0.4Upgrade package to be prepared: p6810189_10204_linux-x861. Current versionSql> Conn/as SYSDBAConnected.Sql> select * from V$version;BANNER------------------------------------------

Today bored to churn just graduated from the computer, found in 11 in the unit internship some exercises and examination questions and answers, now record here, convenient for later inspection.Assessment One:--1, List all employees who pay more than

1. Tablespace Fragmentation *********************** ----1. View FSFI values Select A.tablespace_name,trunc (sqrt (max ( Blocks)/sum (blocks)) * (100/sqrt (sqrt (count (blocks))), 2) Fsfi from Dba_free_space a,dba_tablespaces bwhere A.tablespace_name=

Database Connection PoolA connection pool is a cache of database connections that request a database connection to a connection pool whenever the application needs to connect to the database, and the connection pool is responsible for the creation

when we execute the SQL Show all command under Sql*plus, we can find a parameter: Define & (Hex 26), as shown belowConcat. (Hex 2e)Copycommit 0Copytypecheck onDefine & (Hex 26)Describe DEPTH 1 linenum off INDENT offecho off1, "&" EscapeThis is the

Installing the 32-bit Oracle client Instantclient-basic-nt-12.1.0.1.0.zip: http://www.oracle.com/technetwork/topics/winsoft-085727.html Download unzip to get "instantclient_12_1" file, copy "Instantclient_12_1" to "C:\app\oracle\product\12.1.0" (can

Oracle Database Migration-FundamentalsAs a developer, database knowledge must be in our hands. But now the company's database is dedicated DBA maintenance, usually give us an environment address, and then we write Crud SQL. And the company's product

Suppose we are now brewing a library, initially, we only have 10 books for everyone to read and buy. For 10 books, we might just need a bookshelf to hold it as a container for the 10 books, because anyone can easily take a glance at the title of the

Connect to the Oracle database with Plsql by using a thin client that does not require an installed client.Download the installation package firstDownload the Oracle Instantclient Basic package on the ORALCE official website.The address is as

Main function:package com.tianyu;import java.sql.connection;import java.sql.drivermanager;import  Com.alibaba.fastjson.jsonobject;public class main {public static string game_url  =  "http://ka.game.163.com/service/cardsvc/taohao?id=12374";p

Nagios monitoring oracle alert Log script, nagiosalertClick Nagios to know how to use it # Add nagios to the oinstall group # usermod-a-G oinstall nagios#! /Bin/shDbversion = 11Bdump

Oracle Import Export prompt EXP-0006: internal inconsistency error Solution Exp and imp are two of the oldest operating system command line tools survived by ORACLE, import (IMP)/Export (EXP), yesterday in Oracle with exp, imp Import Export report

Oracle optimization (entry and improvement) In the past decade, Oracle has become one of the world's most professional databases. For IT experts, IT is to ensure that their company's productivity is improved by leveraging the powerful features of

Oracle12cRAC cluster uses GNS for SCAN  1 Description   In the previous Blog, there were three methods for configuring SCAN in RAC: (1)/etc/hosts (2) DNS (3) GNS   The specific link is as follows: Oracle RAC cluster SCAN description Http://blog.csdn.