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>

The most common way to merge column values is to write a custom function to do this, and here's another way. You can use the for XML Path in SQL Server to merge column values, and you can use Wm_concat or Listagg in Oracle. Prepare data:

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"

Oracle unlocks the Scott/tiger user 1, verify the current system for Scott user status: SELECT * from Dba_users where upper (username) = ' SCOTT '; Account_status:expired & LOCKED 2. Release the lock for Scott User: Conn Sys/bitservice@ttonline

Oracle Primary Data types Overview: The data types supported by various databases are similar, and may differ slightly from the data types in standard SQL languages Type: VARCHAR2: You can set its length limit when declaring a field. And after

If you search on the web with the keyword MySQL migration oracle, you will basically get a little more information about how to migrate from Oracle to MySQL and from MySQL to Oracle. Aside from all the manual ways to do this, you can find some

Use Date Oracle Internal use digital storage date: century, year, month, day, hour, minute, second. The default date display format is DD-MON-RR. --You can specify only the two digits of the year, allowing the 21st century date to be stored in

When the index is too fragmented, it affects the speed at which the query is executed, which affects our productivity. The most advantageous measure at this time is to rebuild the index. This article mainly introduces the process of examining index

Workaround: 1. View which profile strategy the user uses Sql> select Username,profile from Dba_users; USERNAME profile ------------------ ----------------- Mgmt_view DEFAULT SYS DEFAULT SYSTEM DEFAULT Ekpuser DEFAULT 2. View effective days

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

1. Open the corresponding database through Plsql. 2. Select the Export Users Objects submenu under the menu tools 3. Select the table name that you want to export the table to, and then select the saved path. 4. Click the Export button to export

Decode function: It can compare an input value to a parameter list in a function, and return a corresponding value based on the input value. The parameter list of a function is a number of sequential pairs of numbers and their corresponding result

A few days ago encountered a problem about Oracle is not equal to the last search for a moment, found the following information, to share with you, need friends can refer to the next is not equal to the number in Oracle: in Oracle, <> != ~=

Oracle| Program | Links The following links are used by the Oracle dedicated to the image link, the value is not high, but very efficient Oracle dedicated ODBC download Http://otn.oracle.com/software/content.html need to register Default.asp -----

RDA is the short name of the remote diagnostic Agent, the tool Oracle uses to collect and analyze databases, and running the tool does not change any of the parameters of the system, and RDA collects data that is comprehensive and simplifies our day-

First, manually delete the file system database 1. Stop Listening and OEM The code is as follows: $ lsnrctl Stop Listener_name $ emctl Stop Dbconsole 2. Access to data files, log files and control documents related information, including

Use of rownum in Oracle in order of result set For Oracle's rownum problem, a lot of information said that do not support >,>=,=,between...and, only use the above symbols (,>=,=,between. and will prompt for SQL syntax errors, it is often not to

Today I learned about the latest popular Ruby on Rails, feeling like a code generator linking OracleDatabase, I searched for half a day of information. Finally found a way, ^______^. 1. Installation drive http://rubyforge.org/projects/ruby-oci8/

Oh, spent one hours, around the 11g installation toss good. It took a long time to toss the SQL Developer, and finally it was done. OK, first summarize the installation steps, hope to the rear of the children's shoes to improve the installation

To export script content: @echo off Rem REM File name Daily.bat REM Batch Process Reload DB Backup Rem REM Author Frank.fan REM modification History Created 2012-05-07 REM Modified Rem for/f "Tokens=1-3 delims=/"%%i in (' date/t ') do