pl sql developer tutorial

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

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

Using PL/SQL Developer to import Excel data often involves data migration after project delivery. Generally, the given data does not have an ID, that is, the primary key. you need to add a column in excel, such as ID. save the excel file as a Text (Tab delimited) file, open plsql, connect to the oracle database to be imported, and then open Tools --> Text importe

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

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

Label:Today, I intend to export the query results of SQL statements to a CSV file using the export CSV function of PL/developer. The results of this SQL query in Chinese, and finally opened with Execel found that the Chinese are all garbled.After Baidu got the answer. The following method verifies success under excel20

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

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

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

--f82: Execute a single statement--mouse cursor resting place F83: Execute multiple statements--select more than one statement F84: Beautify code--toolbar PL/SQL Beautifier5: Debug Stored Procedure-Select procedures in the Browse window to find the stored procedure that needs to be called, then select the stored procedure for debugging, right-click, select Test, in the test Scrīpt window that is defined as

In the Execution menu you can disable statistics, or get SELECT permissions in the V_$session,v_$sesstat and V_$statname tablesSolutions[Email protected] ~]$ Sqlplus sys/manager123 as SysdbaSql> Grant Select on V_$statname to Zheng;Sql> Grant Select on V_$sesstat to Zheng;Sql> Grant Select on V_$session to Zheng;Sql> Grant Select on V_$mystat to Zheng;If you need

PL/SQL _ Developer _ the export tool is not recognized. pldeveloper Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright. Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/44974587 You cannot use th

Local Oracle client connects to remote database with Plsql developer , log in when reported ORA-12638: resolution of failure of identity certificate retrievalLocate the installation directory: C:\oracle\BIToolsHome_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)Reason:Sqlnet. Authentication_services= (N

MySQL, MariaDB, SQL Server, SQLite, Oracle, and PostgreSQL databases in a single program. The official website is: Http://www.navicat.com.cn/products/navicat-premium. Since this machine is a 64-bit operating system, download the latest 11.1.10 64-bit version. 3, Pl\sql Developer 10.0.5.1710