Views related to permissions and roles in Oracle

The views related to permissions and roles include the following:Dba_sys_privs: query the system permissions of a userUser_sys_privs: system permissions of the current userSession_privs: All permissions of the current userRole_sys_privs: system

Uninstall Oracle 9i

In the Windows enterprise operating system, uninstall Oracle 9i: 1. Stop all Oracle services 2. Delete All Oracle items in the Registry (1) Delete the Oracle directory under HKEY_LOCAL_MACHINE \ Software (2) Delete All Oracle items under

Grouping functions in Oracle PL/SQL

When you use rollup or cube for group operations, fields with null values are generated, then, how can we tell whether the field itself is null or generated by rollup and cube? In this case, grouping (groupingfield) can be used to solve the

Oracle 9i/10g/11g Database Upgrade Roadmap)

Mos documentation describes the upgrade Route: Complete check list for manual upgrades to11gr2 [ID 837570.1] Maclean's Blog contains several more intuitive images:

Oracle-related videos recorded by yourself (updated in succession)

    1. Oracle 10g Windows Platform Installation : Http://download.csdn.net/source/1850497 Http://v.youku.com/v_show/id_XMTM0NzA5MjY0.html online viewing address   2. install linux on a virtual machine Download address:

PHP + Oracle implementation Paging

In fact, this problem is not difficult, but it has been found on the internet for a long time. There are also between and minus. However, neither of these methods can successfully complete the paging query with sorting. Finally, we found a solution

Oracle analysis table and Index

Analyze table tablename compute statistics; Analyze index indexname compute statistics; It is very beneficial to use CBO, and more reliable table information can be used, so that the execution plan can be more accurate. In 10 Gb, analyze is

A question about the time field type caused by Oracle update statements

I want to use the Oracle database to update data when I was building an ASP. NET Website. The fields in the table include int, string, and date. net front-end controls always encounter problems when binding updates. I checked a lot of things online

Java Oracle operations

SQL ************************************* **********Create Table AA(A_id number (10) primary key,A_name varchar2 (50 ),A_sex varchar2 (4 ),A_date date,A_money number (8, 2))-- Check whether the operation is successful.Select * from AA;-- Create a

Multi-table join SQL statement (sqlserver, Oracle)

Oracle8 Select a. *, B. * from a, B where a. ID (+) = B. ID -- equivalent to right join Select a. *, B. * from a, B where a. ID = B. ID (+) -- equivalent to left join Oracle9Supports the above writing, and also adds leftjoin, right join,

Oracle 1204 RAC failover test (6)

1. Remove the power of the priv network switch. rac2 reboot and Rac1 work normally. [Oracle @ mesdb01 ~] $ Crs_stat-T Name type target State host ------------------------------------------------------------ Ora. Mes. DB application online

Batch Oracle insert records

The combined arrays of PL/SQL are used here. I want to insert a group of records separated by '_' into the database. Of course, this is just to facilitate batch insertion from Java calling the stored procedure.   First define the array type and a

Oracle PL/SQL group by cube

Rollup will gradually remove a field on the right from the right to the left Based on the field following group by, and gradually sum up, Cube sums all the combinations of fields after group.   Cube eg1:  Select department_id, job_id, sum (salary)

Oracle null is null

NullNoGreater than/less than/equal to/not equal to any value (including null itself), and only:Null is null SQL> set serveroutput on SQL> begin 2 if (2> null) 3 then 4 dbms_output.put_line ('>'); 5 elsif (2 6 then 7 dbms_output.put_line (' 8

Sequences of Oracle

It turns out that Oracle is only used, because there is no auto-incrementing column (like MSSQL), so a method called "Automatic Acquisition" is adopted.Today, I finally learned this sequence. It is similar to the "auto-collect" method. It is like a

Oracle user name Modification

C: \ Documents ents and Settings \ Administrator> oradim-startup-Sid testbas C: \ Documents ents and Settings \ Administrator> set oracle_sid = testbas C: \ Documents ents and Settings \ Administrator> sqlplus "/As sysdba" SQL * Plus: Release 9.2.0.4

Problems with executing root. Sh again on node 2 during Oracle 11gr2 RAC Installation

Problem:[Root @ rac2 ~] #/U01/APP/11.2.0/GRID/root. Sh Running Oracle 11g root. Sh script... The following environment variables are set:Oracle_owner = OracleORACLE_HOME =/u01/APP/11.2.0/Grid Enter the full pathname of the local bin directory:

Oracle recovery after Windows is reinstalled

Windows is a very fragile system. It may crash in a few days after it is installed. If you have Oracle installed in windows, how can you restore the database? One method is to use IMP to import the original data after reinstalling the database, but

Oracle promises to support sun hardware services without talking about MySQL

On Thursday's European version of The Wall Street Journal, Oracle published a large number of front-page ads to talk to Sun Microsystems customers. This advertisement promises to increase investments in Sun's hardware and Solaris software, but it

16 Oracle query date statements

The query date is an operation that you often encounter when using the Oracle database. The following lists some Oracle query date statements. If you are interested, take a look. Oracle query date statements are frequently used when we use

Total Pages: 2147 1 .... 2096 2097 2098 2099 2100 .... 2147 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.