sql developer training

, click the test button to test whether the setting is connected, and if it succeeds, it will show "success" after the left corner status.Figure 2.18 The new/Select Database Connection windowCommon error: If the connection error shown in 2.19 appears, Oracle's service is not turned on.Figure 2.19 A connection error occurredLearn two more tricks: the steps to turn on Oracle services are as follows.(1) Right-click on the "Computer" icon in the desktop and select "Manage".(2) In the Computer Manage

Query for a field with Chinese text SELECT * from Issue I where ASCIISTR (i.id) like '%\% ' Query a field with English letters SELECT * from Issue I where regexp_like (I.id, '. [A-z]+[A-z]) (red font changes randomly) Renaming In the SQL Script window, right-click on the table name to select ' Rename ', modify it in the popup window, tap ' OK ' Delete a table Select my objects, find the table name, and right-select ' drop '20

Tags: Oracle Toad database ManagementUsing PL/SQL developer to manage Oracle in the past has found it inconvenient to use. Open very card, and the upper left corner of the interface is always more out of that box, how can not be set by default hidden away.The only thing that is worth it is that there is a beautification tool, but later found that Toad actually also has a format tool, the decisive unloading

Tags: table structure method file ora sysdba net blog log sqlIn cases where the owner of the table cannot be changed, you can use the method of importing and exporting the table structure and table data to move the table under the owner you want (note: In particular, if you are logged in as a sysdba, the owner of all tables is SYS, which can cause trouble for you to access the database in C #, In my other article, I also mentioned ". NET connection to Oracle database errors, myobjects filter in

you created the soft link through the command line 3.checking Oracle Instant Client SDK Header directory ... configure:error:Oracle Instant Client SDK header files not Foun DWhether your SDK folder is located in the Instantclient directory. 4.ERROR: '/tmp/pear/temp/oci8/configure--with-oci8=instantclient,/usr/local/lib/instantclient ' failedThe path followed by the--with-oci8 is correct and should be the last directory we copied. Ubuntu 14.04 Install Oracle database management software

Tags: com mmu develop plsql lov use TNS POS ResultsDescription of the phenomenon: It is normal to compile procedure with Plsql developer connection. Once the test starts to enter debug mode, it is stuck. The initial guess is that there is no permission, but the DBA role, if not the right will directly report the error without permission. The later guess is the version of Oracle or PL SQL

1:oracle SQL Developer 4.0.2 download Link:Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html2: The downloaded file is sqldeveloper-4.0.2.15.21-1.noarch.rpm, RPM installation package cannot be installed directly on Ubuntu system, need to use

Label:s = SELECT t.* from t w = WHERE b = between and l = '% ' o = ORDER by INSW = in (SELECT a From a where a) SW = Select t.* from t WHERE t sc* = Select COUNT (*) from t st = Select t.* , T.rowid from t f = for update u = Update t SET t. WHERE t 　　1. Save the above contents as Shortcuts.txt, copy to the X:\Program files\plsql developer\plugins directory, Win7 to pay attention to the permissions2. Menu select Tools-Perferences, Editor-autorep

1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/

PL/SQL Developer double-click table name query, pldeveloper Double-click a table. The default value is Expand/Collapse. To Expand/Collapse a table, you need to view the table data quickly. If you write select * from tab, it will be troublesome, Double-click table to perform quick query. Method:Tools-> Preferences-> User Interface-> Browser-> Object type (Table)-> Double-click action (Query Data)

PL/SQL Developer customizes the case-sensitivity conversion icon to the toolbar. pldeveloper For case-insensitive conversion shortcuts, see http://blog.csdn.net/itmyhome1990/article/details/41363633 You can add the case-insensitive conversion icon to the toolbar using the following methods: Steps: Tools --> Preferences --> User Interface --> Toolbar --> Add Selection Uppercase and Selection Lowercase

Two days ago, when a colleague uses Plsql, it is too troublesome to change the database by repeatedly entering the password.Below, I say here how to implement plsql do not need to enter a password to quickly login method:1, start logging in, first enter the password as usual login first2. Enter the page after login, select the tool option in the menu bar, select Preferences3. Then check the login history on the left page of the pop-up window and tick the password store4, then finally click on th

ORACLE you haven't actually written to the database since you modified the data. If you change the wrong, you can roll back.Dot the green tick is write cache, Is the post meant to be transmitted? Change is what it means, you know.Post changes is to pass the changes and not actually write to the database. If someone queries the database at this time, they will not see what you have changed. you are not actually writing to the database until you commit it.This is the concept of database tra

Tags: des style blog color os io file data1, found in the local installation of Oracle directory oracle\product\11.2.0\dbhome_1\network\admin, it generally has two files can be edited Tnsnames.ora Listener.ora, generally as long as the configuration Tnsnames.ora can. Configure how the content looks like.# Tnsnames.ora Network Configuration file:d:\app\oracle\product\11.2.0\dbhome_1\network\admin\ tnsnames.ora# Generated by Oracle configuration tools. ORADEV764 = (DESCRIPTION = ( address_list

Locate the installation directory: C:/oracle/product/10.2.0/db_1/network/admin Open Sqlnet.oraFind sqlnet in there . Authentication_services= (NTS)Change it to: sqlnet. Authentication_services= (Beq,none)or comment out: # Sqlnet. Authentication_services= (NTS)The reason: My computer is in domain control, and NTS is just the window OS authentication method.PL/SQL Developer log in when reported ORA-12638: res

Double-click Table Defaults to Expand/collapse expand/collapse Sometimes you need to quickly view the table data, if writing select * from tab will appear troublesome,We can make a quick query by double-clicking the table.The method is:Double-click Action (Table), User Interface, Browser, Tools, Preferences, Quer Y Data)Reprint Please specify source: http://blog.csdn.net/itmyhome1990/article/details/38663783PL/SQL

Oracle Study--pl/sql Developer software errorThe blog is open at 51cto and CSDN.System environment:Operating system: Windows XP (64)Software: PL/SQL Devoloper 8.04Software, after normal installation, the following error occurred during use:650) this.width=650; "Src=" http://img.blog.csdn.net/20150408162908002?watermark/2/text/ ahr0cdovl2jsb2cuy3nkbi5uzxqvbhf4mdqw

First turn on the computer, to the specified directory of PL/SQL installation"D:\app\DZL\product\10.2.0\dbhome_1\NETWORK\ADMIN" or"D:\oracle\product\10.2.0\db_1\network\ADMIN" or is not logged into PL/SQLLocate your installation path via theFind it again. "Tnsnames.ora" under the \network\adminOpen the "Tnsnames.ora" file to increase the string you need to connect remotely .For example:XXXX =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HO

Label:PL/SQL Developer can import or export CSV files.Import CSV file steps:1, choose Tools->text Importer ....2. Select the second Data to Oracle tab and select Open Data File ... to select the CSV file to import and determine3, select the corresponding owner and table, the field one by one corresponds, and finally click on the bottom of the import, the data is imported into the selected table.Exporting a

1) Install Oracle 11g 64-bit, I use the version: Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html2) Install the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0) as: Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website is downloaded), unzip it to the Oracle installation directory under pr