- #Download navicat premium 64 bit install
- #Download navicat premium 64 bit full
- #Download navicat premium 64 bit software
- #Download navicat premium 64 bit download
In Pl\sql developer, querying a table that contains Chinese characters will become a segment question mark, mainly because the server is not the same as the client's character set.Įxecute the following SQL statement to view the server database character set: The main difference between the two is that the database entry, the basic mode needs to enter the "hostname or ip/service name" format data connection string, TNS mode can be selected in the drop-down box in the configured database.Īs with Navicat, it is recommended to use a more concise basic mode, while setting up Pl\sql developer to keep the login history is much easier.Ħ, solve pl\sql developer Query Chinese table appears question mark garbled problem The Pl\sql developer can also be configured with the basic and TNS connection modes. Configure database connection in Pl\sql developer OCI Library: D:\Databases\Oracle\instantclient_12_1_x32\oci.dllĥ. Oracle Home directory Name: D:\Databases\Oracle\instantclient_12_1_x32 In the Preferences-oracle-connection interface, configure the Oracle home directory name and the OCI library. In the "New Connection" interface, enter the connection name, connection type, hostname or IP address, port, service name or SID, username and password, and click OK to connect to the database. It is recommended to use a more concise basic mode, which eliminates complex tnsnames configurations. The TNS mode only needs to select the network service name, but before you need to create a new Tnsnames.ora and configure the database service. In TNS mode, you need to use an alias item in the Tnsnames.ora file to connect to an Oracle server through Oracle call Interface (OCI). OCI is a standard database access library and a dynamic link library form retrieval function.īasic mode requires a host name or IP address, port, and service name or SID. OCI is an application interface that allows program developers to access the Oracle database and control the stages in which all SQL statements run by using the third-generation language legacy process or function call. In Basic mode, Oracle is connected through the Oracle call Interface (OCI). There are two types of connection for Oracle in NAVICAT Premium: Basic and TNS. In navicat Premium configuration database connection Set the OCI library in Navicat Premium to D:\Databases\Oracle\instantclient_12_1_圆4\oci.dll, and then reboot to take effect.ģ.
#Download navicat premium 64 bit download
In fact, Navicat Premium comes with instantclient_10_2, but it is a lite version of Base Lite (Basic Lite:basic, with only English error messages and Unicode, ASCII and Western European character set support), the Chinese character set is not supported, and the server-side Oracle in this article happens to be the Chinese character set, instantclient_10_2 is not appropriate, so you need to download the base version. The 32-bit and 64-bit instant clients are extracted and renamed, and the native decompression and renaming paths are as follows:ģ2-bit: D:\Databases\Oracle\instantclient_12_1_x32Ħ4-bit: D:\Databases\Oracle\instantclient_12_1_圆4 Give me the feeling that Navicat premium is more convenient, while the database, Pl\sql developer more professional, Oracle's development management more powerful.
The official website is, the download version of this article is 10., the official also provides the Simplified Chinese language pack.
#Download navicat premium 64 bit full
PL/SQL developer focuses on ease of use, code quality, and productivity, giving full play to the key benefits of Oracle application development. PL/SQL Developer is an integrated development environment designed specifically for the development of Oracle Database storage program units. The official website is: Http://Since this machine is a 64-bit operating system, download the latest 11.1.10 64-bit version. Navicat Premium is a set of database management tools that can be easily connected to MySQL, MariaDB, SQL Server, SQLite, Oracle, and PostgreSQL databases in a single program. The basic release contains all the files required to run the OCI, OCCI, and JDBC-OCI applications.Īs for why the 32-bit and 64-bit versions of the instant Client are downloaded separately, they are detailed later. The latest version is 12.1.0.2.0, which downloads the 32-bit and 64-bit versions of basic respectively. The Instant client is a streamlined version of the customer's website, launched by Oracle Corporation.
#Download navicat premium 64 bit software
Native: Windows 7 64-bit Software that needs to be preparedġ, Instant Client 12.1.0.2.0 32-bit and 64-bit
Server Oracle Version: Oracle 11g R2 64-bit, character set is ZHS16GBK.
#Download navicat premium 64 bit install
Because the main job is not development, and do not want to install a large Oracle database on their own computers, it is thought that only through the database management tools to connect the database for some common query operations.
Recently took over a project where the server-side database is Oracle 11g 64-bit.
0 kommentar(er)
