plsql客户端的安装

因工作的需要,安装Plsql,为了防止以后再次忘记,现在做下记录,以备不时之需。文件下载地址:

https://pan.baidu.com/s/1Fo42T4Yp-TFSqjrZQjNW4Q  提取码: w4p1
需要先下载附件 plsql12_32.zip 和 win32_11gR2_client.zip ,解压文件件,并分别双击plsql中的 plsqldev1202x32.msi 到安装目录D:\java\plsql\plsqlClientInstall 和 client 中的setup.exe ,到client的安装目录 D:\java\clientInstall,在D:\java\clientInstall添加network\admin目录,并新建文件tnsnames.ora,然后在文件中添加如下数据库服务的配置: 

# tnsnames.ora Network Configuration 
# Generated by Oracle configuration tools. HOST: 安装oracle数据库的地址 1521是数据库的端口号 test是数据库名称 
test_dev=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))  // 
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test)
    )
  )

第一次双击plsql快捷键时,点击cancle,进入plsql的not logged on 页面,如下图:

点击configure 的 Preferences,然后弹出如下图,配置Oracle Home 和OCI library,即完成了对应的plsql的安装,因本人不喜欢中文版的安装,没有进行汉化,汉化的步骤就不在这里写了。

然后点击Apply及OK按钮之后,关闭plsql客户端工具,再次打开客户端工具,填写 上面配置的数据库监听的数据库名称,用户名和密码,即可登录到oracle数据库中了。

 

 

  • 1
    点赞
  • 7
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
32位版本的 PLSQL 正式版。 安装请查看说明。 APRIL 17, 2020 - VERSION 14.0 RELEASED Built-in Version Control support for Git and Subversion For these file control operations PL/SQL Developer relies on a 3rd party shell extension that must be installed on your system. In the screenshots above “GIT Extensions” has been used. Worksets A workset is a set of Program Windows, SQL Windows, Test Windows, Command Windows, Report Windows and Diagram Windows that you are working on. Internal difference viewer The new viewer allows you to ignore differences in case and white space as usual, but it can also ignore differences in comments. Program Window enhancements The Program Window now highlights transaction statements, so that you can visually recognize the code that affects a transaction. As soon as you place the cursor on a transaction statement, all related statements within a program unit will be highlighted Debugger enhancements A variable name and value can now be copied to the clipboard through the new “Copy variable” popup menu item. Editor enhancements A function key “Editor: Refresh Code Assistant” has been added, to bring the Code Assistant up to date after creating new database objects. When selecting a word, all matching words will be highlighted. Marked editor text is automatically copied to the search field of the Find function. SQL Window enhancements You can now display multiple result sets simultaneously and can compare them: CLOBs and BLOBs are now fetched on demand to improve query performance. Single record view will now show column comments if available. The EXCEL and CSV export filenames can now include substitution variable values. The EXCEL and CSV export filenames can now include %time%, %hh%, %mi% and %ss% variables. For the “Export Results as SQL file” function you can now customize the initialization and finalization. The WITH_PLSQL hint is now supported. Command Window enhancements New EXPORT TABLES and EXPORT OBJECTS commands have been added. This allows you to automate frequent export jobs. You can easily build the command-line from the interactive export tools. The BEAUTIFY <file> command now supports wildcards. The CONNECT command now shows the database list after typing @. The WITH_PLSQL hint is now supported. Object Browser enhancements The Object Browser will now show all overloaded versions of functions and procedures. You can now filter on multiple comma-separated object names (e.g. “dept%, emp%”). You can now refresh materialized views from the popup menu. File Browser enhancements Git and Subversion support has been added. File icons now indicate the PL/SQL Developer file type. You can now filter files based on the name, size, date, read-only status, and version control status. You can specify the filter in the options dialog You also can enter the filter expression directly at the top of the File Browser All windows shell functions are now available from the popup menu. You can now create a specific PL/SQL Developer file type from the “Create File” popup menu item. You can now add multiple files to a project at once. Project enhancements Git and Subversion support has been added. File icons now indicate the PL/SQL Developer file type. Table Definition Editor enhancements The Index and Partition storage can now be edited, copied, and pasted directly in the grid. Support for Row Archival has been added. Test Manager enhancements You can now add multiple Test Script files at once. You can now drag & drop Test Script files from the File Browser. You can now enable or disable multiple items at once. Connection List enhancements Window icons now indicate the PL/SQL Developer window type. Connection status icon moved to the left for consistency. Session Window enhancements You can now define Session Actions that can be performed from the popup menu of the session list: Session Actions can display feedback by writing dbms_output. Other enhancements Function keys have been added for “Search Bar” functions (Focus, Search, Go to next, Go to previous). Substitution variable checkbox and list values can now refer to other variable values as &variable. An “Unregister License” function has been added. Fixes Fixes for multiple monitors with different display scaling (file selector, print dialogs, MDI window title bars, scrollbar width) Conditional sections could be displayed incorrectly in the Code Contents Define Connections and Select Connection tree was incorrect on a secondary display with different DPI settings Menu items with icons from templates were too small on high dpi monitors Ribbon / Menu customization form options were not preserved Editors with a right margin and wrapping enabled did not wrap at the right margin View Stack Dump function now places the error lines in center of the editor Connection matches did not process proxy user expressions (user1[user2]@database) correctly for the application background DBMS_Jobs could not be edited on Oracle19 (‘xxxx’ is not a valid
32位版本的 PLSQL 正式版。 安装请查看说明。 JUNE 4, 2020 - VERSION 14.0.1 RELEASED Enhancements Language packs updated for 14.0 features Large Data Editor did not show in Single Record View in the SQL Window Selection > Uncomment would remove /* and */ in string constants Window List did not conform to the “Short Text” setting for Difference Viewer windows The Difference Viewer window did not always have a correct title Cut and Paste did not work in the SQL Window in Single Record View Code Assistant would display urowid parameters as “Unknown type 104” Table Definition Editor Index Column Selector would convert string expressions to lowercase Entering a value with square brackets when executing a template would interpret the square brackets as a variable Key Configuration items for File / New / Program Window were missing The Command Window BEAUTIFY command did not conform to the Files / Format / Linebreaks preference The Project desktop file (project.dsk) is now portable Using the “SQL Window: Hide Editor” function would incorrectly reposition the vertical splitter The Debugger did not always show correct variable values in local subprograms Object Browser Filter “My invalid objects” would raise ORA-00918 when opening the Triggers folder Clicking on Window List items did not always work correctly after changing the display File Locations import/export functions added File Browser directory popup items added for Git Clone and Subversion Checkout Change All Lines popup menu item added to the Diagram Window Fixes for multiple monitors with different display scaling (file selector, print dialogs, MDI window title bars, scrollbar width) were not available in the 64 bit version The “Close unused connections” preference could cause delays when closing a window or when changing the main connection The Quick Access Toolbar in Full Screen mode on Windows 10 was transparent

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值