Oracle

DescriptionWhen a owner-not_owner_user that is not my_table This table tries to grant my_table permission, an error occurs:Error report:sql error:ora-01720:grant option does not exist for ' owner_schema '. My_table ' 01720. 00000- "grant option

Today, we find a very strange phenomenon, the same SQL statement, in SQL PL can query the results, put into the mybatis under how can not find things. After careful study, the following problems were found:1. If the field defined in the database is

Suitable for:Oracle Data Provider for. Net-version 9.2.0.8 and laterOracle Providers for Asp.net-version 11.1.0.6 and laterMicrosoft Windows Itanium (64-bit)Microsoft Windows (32-bit)Microsoft Windows x64 (64-bit)Checked for relevance on 29-jan-2014*

In order to generate some resources for the release of the library. Requires the API module to be migrated to MySQL in, need to boot data.Try the Oracle to MySQL tool. When migrating errors do not say that such a large amount of data, with such a

Toad for Oracle Chinese display garbledData storage When the Chinese display is normal, in Toad for Oracle client and page display are garbled!!!Cause: A problem that occurs when data is in storage.Solution:Increment in system variable: variable

First, prefaceFirst of all, the system here is the Centos7_86_64,oracle version is oracle10g R2, assuming that the system and the database have been installed. There is an article in detail on the CentOS7 under the installation of oracle10g process,

Find leaders with employee number 7369:1 SELECT level,e.* from EMP E CONNECT by PRIOR e.mgr = E.empno START with e.empno = 78762 ORDER by Level DESC' Start with '--this identifies all level=1 nodes in the tree"Connect By" – describes how to walk

Test the code in Windows environment:ImportJava.io.File;Importjava.io.FileNotFoundException;ImportJava.io.FileWriter;Importjava.io.IOException;ImportJava.io.InputStream;ImportJava.io.PrintWriter;ImportJava.util.Scanner; Public classTesttimer {/**

I. Change Password1) Change Password sql>alter user User01 identified by password;2) Change Password and unlocksql>alter user User01 account unlock identified by P Assword;3) Unlocking operationSql>alter User User01 Account unlockTwo. Set Password

In is the appearance and the inner table as a hash connection, and exists is the external loop loop, each loop loop and then query the internal table.NOT exists: Do NL, subquery first, there is a virtual table, there is a definite value, so even if

First, an overview of the task map: The process is to first delete the files on HDFs with Thdfsdelete, then import the data from the organization tables in Oracle into HDFS, establish hive connection-"Hive Build Table-" Tjava Get system Time-"

--Select 30 of employees in the departmentSELECT * from EMP where deptno=30;--List all clerks ' names, departments, numbers--Using the internal connection, that is, the equivalent link, is also the most commonly used linksSELECT ename,empno,dname

--statistics on the sum of departments ' wages according to each departmentSelect DeptID, sum (SAL) payroll totals from the EMP group by DeptID;--statistics on the sum of departments ' wages according to each departmentSelect DeptID, Payroll total,

#!/bin/shsource/home/oracle/.bash_profileif [-Z]then echo "please Input a number,usage:0|1|2" Exitelse Rman_leve L=$1fiexport oracle_sid=xxxxexport today= ' date ' +%y%m%d ' export rman_dir=/backup/archivelog/rman/$ORACLE _sid/$ today-$RMAN

1 Generating a sceneDesigner-> item->odi_exercise, first folder, package->first _pkg, right-click, generate SceneDetermineBuild the scene.2 Schedule 2.1 New ScheduleDesigner-> Project->odi_exercise, first folder, package->fitst_pkg->

To put it simply1, the structure changed, the original SOB is now called Ledger2, customer, supplier, tax raise a level3, customers, suppliers, banks changed to Web interface4, AR, AP can support the cross-ou query and input under one responsibility.

Oracle Regular ExpressionsIn practical applications, you want to exclude field values with Chinese: Select H.froomnumber from T_broker_house h where Regexp_like (Froomnumber, ' ^ ([a-z0-9a-z]|-) *$ ')The string ' ^198[0-9]$ ' can match ' 1980-198

(1)Select the most efficient table name order (only valid in the rule-based optimizer): The Oracle parser processes the table name from the FROM clause in a right-to-left order, and the last table written in the FROM clause (base table driving

The Oracle numeric data type can store a maximum of 38 bytes of precision. When converting an Oracle value to a common language runtime data type, there may be too many digits behind the decimal point, which can cause this error. Query 290,000 data,

This is the opening article for Oracle Database beginners. Due to project reasons, I recently started to study Oracle databases. Oracle is currently one of the most popular databases, with powerful functions and excellent performance. It is