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
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
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
Mos documentation describes the upgrade Route:
Complete check list for manual upgrades to11gr2 [ID 837570.1]
Maclean's Blog contains several more intuitive images:
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
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
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
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
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,
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
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
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)
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
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
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:
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
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
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
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