Oracle

There are three users test1,test2,test3, and three users have DBA color permissions. Create a table T1 with TEST1 users and grant their query permissions to TEST2: Sql> CREATE TABLE T1 as select * from All_objects; Table has been created. Sql>

1, Ora-12541:tns: No listener Cause: The listener is not started or the listener is corrupted. If the former, use the command net start Oracleorahome10gtnslistener (the name may differ), and if it is the latter, use the "Net Configuration Assistant"

This article mainly introduces the Oracle database startup and shutdown methods, the need for friends can refer to the next First, start data$sqlplus "Sys/pass as SYSDBA"Sql>startup Second, start the listenerafter the database is started, if the

Oracle self-Adding column creation method collection Oracle does not have such features as the self-adding fields, but it can be implemented by triggers (trigger) and sequences (sequence). First build a test table: CREATE TABLE Userlogin ( ID

Distinct this keyword to filter out the extra duplicate records only one, but often use it only to return the number of records not duplicates, rather than using it to return all the values not to be recorded. The reason is that distinct only use

1, UPDATE nowait Apply the following scenario: Query a data and open database transactions to it. If the current data for the query is not locked, the result is returned correctly and the current data is locked, if the current data for the query is

Background processes are used to perform the actual maintenance tasks required to keep the database running. For example, a background process maintains the buffer cache and writes the block out to the data file as needed. Another process is

This article is a detailed analysis of the difference between MySQL and Oracle update, the need for friends under the reference Update: Tanku Updates Needless to say, the two are the same, mainly talking about the update of multiple tables Copy

---Description flash back to the database ---Restore a table's contents to a specific point in time using the flash-back table ---recover from a deleted table ---Use a flashback query to view the contents of a database for any point in time

We may have encountered in peacetime work, multiple table cascade Update, I also saw a lot of methods on the Internet, but the use of these methods generally did not succeed, so today I introduce you to a slightly troublesome method, the need for

  This article mainly introduces Oracle and MySQL 9 point difference, need friends can refer to the following 1. Group function usage rules MySQL group functions can be used at will in a SELECT statement, but in Oracle if there are group

Question Prompt Error tip: Error:ora-12514:tns:listener could not resolve service_name given in Connect Workaround: The code is as follows 1. Open the/network/admin/listener.ora file and find: Sid_list_listener = (Sid_list =

Problem: An inexplicable problem occurs when you use Plsql developer to connect to a local Oracle database on a WIN8 64-bit system, and the error prompt box may even be empty. Reason: According to the internet, the reason is estimated to be

Oracle Software Environment: 1, Windows 2000+oracle 8.1.72, Oracle installation path is: C:\ORACLE Implementation method: 1. Start-> Setup-> Control Panel-> Admin Tools-> Service Stop all Oracle services. 2, Start-> Program->oracle-orahome81->oracle

Oracle Week Three: Table space management What does the name contain? : Improved table space management Table space management has been significantly improved, which can be attributed to a sparser SYSTEM, support for user-defined default

oracle| Data | database Six experiences in Oracle database system usage ----The use of the 1.having clause ----A HAVING clause to control the row groups determined by the GROUP BY clause, the HAVING clause condition allows only constants to be

If you have really understood some of the methods we discussed above (Edit, update, and AddNew), perhaps some readers already know how to delete records in an Oracle database. ' Delete all records that match the above criteria

oracle| Function | Data pl/sql code: CREATE OR REPLACE PACKAGE "SCOTT". " Pkg_test "as TYPE Myrctype is REF CURSOR; FUNCTION get (Strbarcode VARCHAR) return myrctype; End Pkg_test; CREATE OR REPLACE PACKAGE Body "SCOTT". Pkg_test "as FUNCTION get

oracle| Data | Database Oracle Object Server contains six objects 1.OraClient 2.OreSession 3.OraConnection 4.OraDatabase 5.OraDynaset 6.OraSQLstmt 7.OraField 8.OraParameter 9.OraParameterArray 1.Oraclient objects Oraclient object to record all

--View Oracle database Character set: SQL code Select Userenv (' language ') from dual; Query results: Simplified Chinese_china. Al32utf8 --Modifying the Oracle Database Character set: (In SQL Plus) SQL code Sql> Conn/as sysdba; sql>