March 2005-version 6.0.5 releasedenhancements Insert Template context menu would hide a and add dummy item Insert Template did not show subfolders Connection preferences at Registry (Logon section) did not work projects:progres s while compiling today shows actual number of compilable files (compiling:x of y) projects:not all compile errors were in dicated projects:handled errors in command files for whenever ... Failure Added missing oracle10g plan_table columns
Pl/sql developer-newsseptember 2004-version 6.0.2 releasedenhancements Partitioned tables were not detected Corre ctly on Oracle8i Partitions tab page is visible when viewing a non-partitioned table Code Assistant did not describe mate Rialized views Code Assistant did not describe record types declared in another package Code Assistant could remove spaces Typed
PL/SQL Developer experience with oaracle11g64-bit systems in Windows7 64-bit SystemsI. Problem phenomena and solving methodsPhenomenon:1.pl/sql cannot log on to a 64-bit database2. Enter Chinese in PL/
of the Tnsnames.ora file. For example, my machine is: d:/instantclient_11_2/network/admin4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.SELECT * from Nls_instance_parameters;View the value of Nls_languageNls_languageNls_territory5.
example, my machine is: d:/instantclient_11_2/network/admin4. Set the Oracle language, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_instance_parameters;View the value of Nls_languageNls_languageNls_territory5.
First, download the Oracle client: http://www.oracle.com/technetwork/topics/winsoft-085727.htmlCurrent Latest VersionVersion 12.1.0.2.0Select the first instant Client for Microsoft Windows (32-bit) to download it,Please do not download 64bit, I have tried, can not achieve the connection.Unzip the downloaded Instantclient-basic-nt-12.1.0.2.0.zip compressed package
Tags: plsql developer uppercase and lowercase conversionRefer to http://blog.csdn.net/itmyhome1990/article/details/41363633 If you use the case conversion shortcut keyThe following methods add a case conversion icon to a toolbar:Steps:Tools--Preferences User Interface---Toolbar add Selection uppercase, Selection lowercase to the rightThen we can see the two icons in the toolbar.Select the code you want to convert click the AA on the toolbar, or AA.Itm
Tags: background database management tool Oracle ClientFor the traditional large-scale software products using relational database, the continuous development and maintenance of the background database can produce a large number of script files, how to make versioning more convenient for these script files, and how to quickly manage the permissions between the teams. The level of integration between the different database products and the corresponding client management tools and different produ
The previous blog describes the method of backing up Oracle with the Navicat tool, which describes how to import and export an Oracle database using the PL/SQL developer tool.PL/SQL Developer is one of the primary tools used by Oracle databases to import and export databases
There are two ways to find it online:1. Through Configuration and migration ToolsNet manager→ local → profile →oracle Advanced Security → validation → Remove the "NTS" in the selected method, the key is to not restart the database.2. Locate the installation directory: App/product/10.2.0/dbhome_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). This met
Tags: select fill idt LAN row content query action GravityDouble-click the table default feel Expand/collapse expand/collapse sometimes need to view the data at a high speed, assuming that writing a select * from tab will appear troublesome,We can achieve high-speed query by double-clicking 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/
Get ready:
PL/SQL Developer: I'm using plsqldev1005 (32-bit)
Win32_11gr2_client: Remember that it must be 32-bit, because PL/SQL developer only recognize 32-bit
After the installation is successful, you need to c
Nls_languageNls_languageNls_territory6. Download and install the PL.SQL.Developer configuration appConfigure Tools->preferences->connectionOracle HomeD:/instantclient_11_2OCI LibraryD:/instantclient_11_2/oci.dllThe PL/SQL developer in Chinese isTools--Preferences--ConnectOracle Home DirectoryD:/instantclient_11_2OCI L
Tags: ant article directory name add protoc Imp directory database comOracle 11g Lite Client ConfigurationOracle is typically deployed on the server, and the client needs to connect to Oracle on the server using connection tools such as PL/SQL Developer.At this point, it is often necessary to install hundreds of megabytes of Oracle on the client and then configure the completion of
Tags: plsql developer software WrapStatement ************************************************************** *********Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/39932149*************************************************************************************************************** *
1) Install Oracle 11g 64-bit2) Installing the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0)Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website has downloaded), Unzip it to product under the Oracle installation directory (this machine is named: instantclient_11_2): D:\Oracle\app\YM\product\instantclient_11_2.Copy a directory under the root directory of the database installat
example, enter SF, press space, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements. Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit 1), create a text file Shortcuts.txt, and write the following: s= The SELECT replication code is saved to the ~/plugins directory under the installation path of PL/
Modify the database configuration file: Tnsnames.ora "My database location: D:\app\Icey-evil\product\11.2.0\dbhome_1\NETWORK\ADMIN"Add the following to the server address:10.88. 250.28 = = =10.88. 250.281521) ))) (= ORCL ) )) Description: HOST = 10.88.250.28 is the Oracle server that needs to be connected Ip,service_name = ORCL is a connected db instance, Port = 1521 is the Oracle Server listener.Configuration complete, with the PL
, press the space, automatically replaced by select; for example, enter SF, press space, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements.Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit1), create a text file Shortcuts.txt, and write the following content:S=selectCopy code is saved to the ~/plugins directory under the PL
The Oracle tutorial being looked at is: Pl/sql Programming experience Summary Developer Network Oracle. Usually in the Pl/sql programming encountered some problems, here in the form of questions and answers to summarize them, for everyone to share.
1, when the need to load
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.