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

Dependent packages required before installation:

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

Recent Oracle upgrades, from Oracle8 to Oracle9i, have encountered a lot of trouble.The first is the uninstall problem. Because Oracle8 did not use the normal uninstall method, the installation of the oracle9i is difficult. The correct uninstall

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

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 

=============================== 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

Oracle creates users and specifies default and default table spaces Create a temporary table space Create temporary tablespace BocodbtempdbsTempfile ' d:/oracle/oradata/bocodb/bocodata/bocodbtempdbs01.dbf 'Size 32mAutoextend onNext 32m MaxSize 2048

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 *

Executes the sh of the stored procedure. /oracle/.bash_profile/oracle/bin/sqlplus qd/qd@info Timed execution of stored procedures using timersView Timer: Crontab-l CRONTAB-E Edit Timer I insert a new: w! Save: q! Exit The contents are as

Database jobs are more familiar to DBAs because they often have to automate some scripts, do database backups , or refine data, or do database performance optimizations, including rebuilding indexes, and so on. However, the Oracle timer job time

+++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