Oracle

Sys_guid ()-Unique indexIn Oracle, you can use Sys_guid () to generate a GUID that is equivalent to NEWID () in MSSQL.The resulting data in oracle9i and Oracle 10g is 32 bits, such as: 234E45F0077881AAE0430AA3034681AAHowever, the GUID in Oracle is

Original Address--http://blog.csdn.net/qq525099302/article/details/47253641SELECT * FROM b_role_authority as of timestamp to_timestamp(‘2015-07-25‘,‘yyyy-mm-dd‘)Note: The table structure changes after the invalid, can only query for a period of time

----query all tablespace usage---Log on with DBA authority 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 ((d.tot_grootte_mb-f.total_bytes)/d.

--Create a table TEST_HSJ (ID int primary key,num varchar2 (), regdate date) SELECT * from test_hsj;--inserting test data insert into T EST_HSJ values (1, ' 1 ', to_date (' 2015-05-01 ', ' yyyy-mm-dd ')) insert into TEST_HSJ values (2, ' 2 ',

In many cases, a database is just a few blocks of data file corruption. In this case, of course, we use database recovery or data file recovery to solve the problem. But the feeling of a little flak hitting the mosquitoes. Fortunately, Rman provides

First, the problem descriptionSometimes in "related subqueries" you need to query a field that corresponds to an entity class with multiple values, and if you do not do a line train query, you are prompted to return multiple columns of errors. For

1,problem description,DBCAfinallyFinishwhen the errorora-00119:invalid Specification for system parameter Local_listener ora-00130:invalid LISTENER address ' (address= (P ROTOCOL=TCP) (host=pldb236) (port=1521)) ', as shown in2, GohostsAdd

--Cardinality data1SELECT 2 mt.materialtypename, 3 Mt.parenttypeid 4from material_type MT;Use recursive return is with level1SELECTId2Mt.materialtypename,3Mt.parenttypeid,4 SUBSTR (Sys_connect_by_path (Mt.materialtypename,', ')

Create a database link on your local Oracle databasesDROP DATABASE LINK Mydblink;Create DATABASE link Mydblink connect to zszq identified by "zszq" using ' 192.168.0.175:1521/ORCL ';sql> DROP DATABASE LINK mydblink;The database link has been deleted.

1. Select * FROM your_table t//query your_table for all data, you can see three data2. Delete your_table//delete all data in your_table, three data disappears3. Select * FROM your_table t//No data.4. INSERT INTO your_table SELECT * from your_table

Blob fields, in fact, are used to store binary types of data, such as: large text, files, pictures and other information directly stored in the database of a solutionSo, if there is a BLOB type field for the newly inserted record, you need to first

1 in the Oracle database, RowNum is a pseudo-column that the Oracle database adds to the query results. The starting value is 1, which is commonly used to handle paging of query results.2 due to the particularity of RowNum, the use time is usually

When Oracle EBS enters responsibility from the Web interface, it prompts that there is no valid responsibility available. oracleebsWhen Oracle EBS enters responsibility from the Web interface, it prompts that there is no valid responsibility

Oracle Display object space usage show_space Tom wrote a script to view the object space usage of the Oracle database.The following shows how to use it: -Tool source code CREATE OR REPLACE PROCEDURE show_space(p_segname IN VARCHAR2,

How to optimize real-time Oracle databasesBackground of optimization ideas for real-time Databases There are about 168 heat exchange station units, each of which has nearly 400 points, and more than 60 thousand points need to be updated in real time.

In oracle, how does one obtain the local IP address and the domain name based on the IP address?----- Resolve the ip addressSQL> select utl_inaddr.get_host_address ('Google. com') from dual;UTL_INADDR.GET_HOST_ADDRESS ('Google. com ')----------------

Oracle section 2nd LessonAim While retrieving data from the database, you may need to restrict the rows of data that are displayed or specify the order in which the rows are displayed. This lesson explains the SQL statements that youuse to perform

Oracle Paging for tables without primary keys Generally, for tables with a primary key that can be used for unique table recognition, we can use the primary key and rownum for implementation. For example: Select scott. emp. * from scott. emp left

Oracle data types, functions, and stored proceduresString typeFixed Length: char nchar n indicates Unicode encodingVariable Length: varchar2 nvarchar2Number Type: number (P, S) P: integer digits, S decimal placesIntegerBINARY_FLOAT Single Floating

OracleORA-01555 snapshot old description ORA-01555 snapshot is too old, is a common error in the database, such as when our transactions need to use undo to build CR block, and at this time the corresponding undo does no longer exist, at this time