PhenomenonThere are some problems when writing SQL in PL/SQL.ORA-06550: GarbledPLS-00553: GarbledORA-06550: GarbledPl/sql:compilation Unit Analysis terminated"Cause" due to changes in language in Oracle's system configuration files or changes in system configuration files, PL/SQL developer has not yet been updated."This workaround" has not been updated to PL/
Tips for SQL Developer 1. Set the logon password of plsql developer by default. Choose 'tools '--> 'preferences'. In the 'oracle 'column of the window, select the 'store with password' option in 'logon History,Log out of PLSQL and select the database connection name after 'username' when logging on. 2. Set window list
PL/SQL _ Developer import official documents, 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/44974619
Add "official documentation" for PL/
Tags: style blog http ar using SP java on 20141. Premise: The use of Sqldeveloper is based on the premise that Oracle is installed on your machine.2. Just open SQL DeveloperLocate the directory of the JDK you installed, the path I installed is: C:\Java\jdk1.6.0\bin\java.exe or C:\Java\jre6\bin\java.exe. Note that the JDK needs to be available under version 1.6, and the above versions are also available, but
Label:To quickly use PL/SQL developer for Oracle database-related development, summarize some of the more frequently used tips below, from the network and your own tests 1. Switch schema --switch SchemaAlter session set current_schema= PO; --get Current Context informationSelectSys_context ('USERENV','Current_User') Current_User, Sys_context ('USERENV','Curren
Problem Description: After you open PL/SQL developer, you can read the Oracle database, all aspects are normal, but the correct database user and the wrong password still can connect normally, but the SQL statement execution cannot produce additions and deletions to the database.Cause: PL/
Tags: select root directory NTC Click need to restart OCI technology sharing styleRequires oracle11g installation package, PL/SQL Developer, and instantclient_11_21.oracle Click Install (need to pay attention to change the administrator password);2. Copy the network folder under the F:\app\Administrator\product\11.2.0\dbhome_1 directory to the root directory of i
PL/SQL Developer and instantclient client installation configurationOracle installation I will not write, will not be installed on the Internet casually find a tutorial can be installed, installation is relatively simple. However, PL/SQL developer and instantclient clients are not well configured, easy error, configura
PL/SQL Developer and instantclient client installation configurationOracle installation I will not write, will not be installed on the Internet casually find a tutorial can be installed, installation is relatively simple. However, PL/SQL developer and instantclient clients are poorly configured, error-prone, and poorly
When logging in to Oracle with PL/SQL Developer: Using a filter for all users can leads to poor performance!Analysis: Regardless of the configuration of Oracle, you will see very many tables, views, sequences, etc. that are not relevant to the current work when using the tree directory on the left side of Plsql, result
Configuring the PL/SQL Developer Connection Server databaseThe client software is installed on the remote application server and can be downloaded on the Oracle official website.Example:Environment
Application Server operating system
WIN 7
Local address
192.168.56.117
Production server operating system
Ente
When pl/SQL developer is enabled, the NLS_LANG and Character set (Character set) problems occur. plnls_langStart pl/SQL developer and the NLS_LANG and Character set (Character set) problems occur. The company recently trained pl/SQL. After installation, I started it and enco
There are several versions of Project Databases installed in the machine. I want to know what the New and Old database structures are like. I searched several gadgets on the Internet. Either oracle is not supported, or the functions are too weak. Only tables can be compared, and views, processes, triggers, and so on are not supported. Being depressed, suddenly, a big fairy post caught my eye -- use PLSQL developer
Pl/SQL developer open the table garbled. In pl/SQL developer, view the table structure. The table structure comments are all ???, It is normal to view the table structure directly in the cmd window, which indicates that it is a problem with pl/SQL
Label:Do not install Oracle client program locally, connect to remote database directly using PL/SQL developerGiven the limited resources of the machine itself, a client consumes a lot of resources and attempts to connect remotely using a method that does not install the client.Software required: instantclient-basic-win32-10.2.0.5.zip, PL/SQL developerThe process
Let's talk about the computer system. The previous version was win2003,PLSQL is installed on disk D, and Oracle client is installed on disk E.After changing the win2008 system, the Oracle client deletes and reinstalls, and PLSQL is still the original D Drive file.Oracle client configuration listenerProgramThe listener is successfully tested.Then use PLSQL to log on. The following message is displayed:Pl
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\prod
When Oracle uses plsql developer to connect, the following error occurs: The Host object name cannot be found. The solution is mostly because the computer name is modified. Www.2cto.com solution: Step 1: sqlnet under the directory C:/oracle/product/10.1.0/db_1/NETWORK/ADMIN. ora tnsnames. ora listener. the original computer name in these three files is changed to
When using PL/SQL developer, the query out of the text field is garbled, because the database number format and PL/SQL Developer encoding format is not uniform caused.I. Viewing and modifying the Oracle database character setSelect Userenv (' language ') from dual;--query re
Issue: WIN8 64 uses bit system PLSQL developer Local connection Oracle inexplicably problems occur in the database. The error message box may even be empty.Reason: It indicates that the Internet, for reasons, is expected to be installed on a 64-bit system in a 64-bit Oracle database. However, there is no corresponding 64-bit PL/
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.