Oracle

This article records the installation of the robot framework connection to an Oracle database1. Basic EnvironmentFirst of all, the basic environment of Robotframework +databaselibrary environment to be ready, the two environments are set up in the

=Group by A, b+GROUP by a+GROUP BY NULL1 sql> Select Deptno,job,sum (SAL) 2 2 from EMP 3 3 GROUP by Rollup (Deptno,job); 4 5 Deptno job sum (SAL) 6-------------------------7 8 9

To view the database default table spaceSql> Select Property_value from database_properties where property_name = ' default_permanent_tablespace

Oracle 11g Virtual sub-partition experimentthe following two create statements are created successfully;Requirements Description:The project requires that 3 fields be partitioned, such as time, hours, and an area ID, to associate with the virtual

Mainly follow the Li Xinghua Teacher's installation Steps (Http://edu.csdn.net/course/detail/3574/62057?auto_start=1), but the last step forgot password management, so unload the reinstallation.In terms of uninstallation:1) Enter Services.msc in

Oracle Server version 11.2.0.1.0Sqlserver2008 R2The prerequisite is that the Oracle client is installed on the SQL Server servers and configuredNot Configured, please refer to this link1 Login MSSM Tools2 Select one of the databasesRight-click task?

FunctionA function is similar to a stored procedure and is also a named Pl-sql block stored in a database. The main feature of a function is that it must have a return value. The return type of the function is specified by return. Anywhere in the

The NOT NULL constraint can be defined only at the column level, and the name of the NOT NULL constraint may be specified, and the name is automatically generated if unspecifiedsql> CREATE TABLE T1 (x number not NULL, y number constraint nn_t111_y

*********** Importing (exporting) data with toolsTool (T)-"Export Table" (X)Tool (T)-"Export Table" (X)Selected Run File location:E:\oracle\product\10.2.0\db_1\bin\imp.exe (Exp.exe)********* command Import and ExportOracle Import DMP File command:(1)

http://blog.csdn.net/msdnchina/article/details/53174196Https://docs.oracle.com/cd/E52668_01/index.htmlOracle Linux, known as Oracle Enterprise Linux, is one of the oel,linux releases.Oracle launched its first release in early 2006 to better align

/*$SQL: SQL statements$pagedir: Paging Click to jump Address$page Current PageTotal $count Data$pagesize show the number of bars per page*/Function page ($sql, $pagedir, $page = 1, $count, $pagesize = 10) {$pagecode = ";$page = Intval ($page);$count

Flash back area full:OS:RM-RF [Archivelog autobackup backupset controlfile Flashback Onlinelog]Eg:Archivelog autobackup backupset controlfile Flashback Onlinelog[Email protected] prod]$ CD autobackup/[[email protected] autobackup]$ ls2014_10_13 2014_

Simple conditional Judgment StatementSql> Declare2 myage Number: = 10;3 begin4 If Myage 5 dbms_output.put_line (' I am a child ');6 End If;7 End;8/I am a childPL/SQL procedure successfully completed.Sql> 2Myage number: = 10;Sql> CH/10/14Myage number:

General character Splitting methodSelectREGEXP_SUBSTR (Str,'[^,]+',1, Level)STR from(Select '11,12,13,14,15,16' Str fromdual) CONNECT by Level Regexp_count (Str,'[^,]+');To split with a special number character:line break, carriage return, TAB

1. Check the alarm log/u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.logReal-time logs: Tail-f/u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.logTrace File ADR2. Dynamic performance view (v$) saved in memoryInformation used to access

Recently, I have made further analysis and research on rownum when I use Oracle's rownum to realize pagination display. Now summarized as follows, hope to bring you a harvest.For rownum It is the number of the Oracle system order assigned to the

Table partitioning is an idea, and partitioning represents a technology implementation. When the size of the table over G can consider table partitioning, improve query efficiency, equalization IO. The Oracle partition table is the implementation of

1 STARTUP Nomount1. Read the parameter file under the DBS directory under Environment variables (spfile/pfile)To find the order of the parameter files as listed above, read the priority level:Spfilechongshi.ora > Spfile.ora>initchongshi.oraIf none

1. Get HelpImp help=y2. Import a full databaseImp system/manager file=bible_db log=dible_db full=y ignore=y3. Import all of the tables, indexes, and other objects that a specified user or group belongs toImp System/manager file=seapark Log=seapark

*********** Importing (exporting) data with toolsTool (T)-"Export Table" (X)Tool (T)-"Export Table" (X)Selected Run File location:E:\oracle\product\10.2.0\db_1\bin\imp.exe (Exp.exe)********* command Import and ExportOracle Import DMP File command:(1)