Oracle

Select Max (Sys_connect_by_path (username, '; ') from(SelectU.username,rownum roFromT_base_user U,t_base_role_user ruwhereU.id = Ru.userid) NewtabStart with newtab.ro = 1Connect by Prior newtab.ro = Newtab.ro-1 Note: T_base_user is a user table

/* CursorsPurpose: To process a SELECT statement to return multiple rows of data Use steps:1. Define CursorsCURSOR cursor_name is select_statement2. Open cursorOPEN cursor_name3. Extract DataFetch cursor_name into variable1,...--Fetch one row of

Yesterday, the head was assigned a task, mainly to write a trigger, used in one of the tables in a field update, the same table will also modify another field. I yesterday that tangled ah!! For a long time, the main is not played before the trigger,

In the Chinese application Management system, the UTF8 format replaces the GB2312 database storage more and more is set to the default format, this kind of internationalized coding format has brought the great benefit in the resolution text format

A few weeks ago I learned the seam framework, seam ejb3 and JSF, and the development is much simpler, much like Ror ^_^. Seam development can put more effort into business requirements and reduce the time spent on code. To facilitate seam

Topic: 5. You are performing a blocks media recovery on the TOOLS01.DBF data file in the SALES database using RMAN. Which Two statements are correct in this scenario? (Choose two.) A. You must ensure so the SALES database is mounted or open. B. You

In Oracle, there are times when you need to update another table with one table. The following are examples of implementations: 1. Create a table test_a CREATE TABLE Test_a (ID Number (19),Name VARCHAR2 (20),Age Number (3)) 2. Insert some data

The Naming convention for this file defaults to: Init$oracle_sid.ora (under UNIX environment) Init%oracle_sid%.ora (under Windows environment) Places it in the following directory by default $ Oracle_home/dbs (Unix) %oracle_home%/database 

Oracle hierarchy query (connect by) is used in structured queries, and here's a basic syntax for Oracle hierarchy queries, which hopefully gives you a deeper understanding of Oracle hierarchy queries. SELECT statements in Oracle can use the start

=============================== query Table space usage =============================== Select UPPER (f.tablespace_name) "Table space name", D.TOT_GROOTTE_MB "Table space size (M)", D.tot_grootte_mb-f.total_bytes "used Space (M)", To_char (ROUND

implementation steps: 1. Change init parameter resource_limit to true; restart the database; 2. Change the "Idle connection Time" of profile profiles for user profiles; 3. In the database query session state is "Snipe", through the operating

I. Preparatory work 1. Effective backupMake a physical backup of Oracle software and databases.2. Check for invalid objects.3. Ensure system's free space is above 50M.4. Shared_pool_size and java_pool_size are at least 150Mb.5. Close the database

Sqlplus/nolog Connect Sys/sys as Sysdba Shutdown normal Startup Mount Appear: ORA-00214: Alter system set control_files=' D:/oracle/oradata/ora10/control02. CTL 'Scope=spfile; ALTER DATABASE Mount Appearance: ALTER DATABASE mount*Line 1th Error:

Today found the Dream Oracle 9207 Windows upgrade patch, upgrade the times in the client machine abnormal, the original is the MSDTC service did not stop, reported a lot of garbled, temporarily stop DTS service upgrade normal. After the upgrade exp

Install the oracle9i, and then install Tomcat (5.0/6.0 have tried), with the start of the myeclipse to say "address already" in user. No language, for fear of conflict with Oracle ports I've changed the ports when I installed Tomcat, like 8081,8082,

1 SELECT * FROM ( SELECT segment_name, SUM (BYTES)/1024/1024 M From Dba_segments WHERE OWNER = user GROUP by Segment_name ORDER BY 2 DESC ) 2 The second method SELECT Partition_name, High_value, High_value_length, Tablespace_name, Pct_free, pct_used,

Truncate is a unique keyword in Oracle. Its role is to empty a table, and in the deletion of data, and delete some of the differences, so that they can remember: 1, in function, truncate is to empty the contents of a table, it is equivalent to

After the system upgrade, one of the features is not normal, colleagues want to look at the upgrade before the stored procedures. The first thought is the flashback function, unfortunately, the flashback encountered a ORA-01555 error. SELECT *

+++10gr2 If the host name is modified and the corresponding information is not changed, the database will be/etc/hosts when it is shut down and started. [Oracle@oracle ~]$ Sqlplus/as SYSDBA Sql*plus:release 10.2.0.1.0-production on Sun APR 6 19:1

Time is not to be mistreated. Install the Oracle 11g, need to install the RPM dependency pack, according to the Oracle official website, the need to install the RPM package is certain, but these dependencies may depend on different systems depending