SQL developers are often responsible for creating a database from scratch or maintaining one for a company, such as what a database administrator does. A PL SQL developer understands how to mold these languages for use in a variety of situations and applications. Structured Query Languages, shortened to SQL, are important to database creation, structure, and maintenance. To solve that, go to PL/SQL Developer - Tools - Preferences - User Interface and uncheck Faded disabled buttons.PL SQL Developer Job Overview and Tips What Does a PL SQL Developer Do? The icons in PL/SQL Developer looked a bit funny (gray/black - not really readable). I had to do one more thing to get it complete like on a real Windows system. if you now start PL/SQL Developer (CrossOver - Programs - PL/SQL Developer), it will look like it's a native OSX app. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = ORCL)))Īnd copy that file into c:\instantclient_11_2 (or the directory you unzipped the Oracle instant client) Next create a tnsnames.ora file with the connections to your database e.g.: Edit the nf file which you find in C:\Īdd in the section (depending your db characterset): Next you'll have to set the Environment Variables, so PL/SQL Developer knows where it can find the Oracle Client. To open the C-drive: in the CrossOver menu click on Manage Bottles - Advanced Tab - Open C: drive in Finder. Unzip the file and copy the directory to your C-drive. Easiest will be to download the Instant Oracle Client for Microsoft Windows (32-bit).
Once that is done we'll have to install the Oracle client so we can connect with PL/SQL Developer to our Oracle database. You just follow the wizard from PL/SQL Developer to finalize the install. Finally hit the Proceed button to do the install. Select Other Application and in Select an installer search for plsqldev804.exe file (which you can download from the PL/SQL Developer website. Once CrossOver is installed, you click Configure - Install Software. In this blog post I'll show how to install PL/SQL Developer in CrossOver. Not all applications work with CrossOver, but it's worth trying to get it working there as it's more lightweight than firing up a VM. So the options are running a Virtual Machine (I use VMWare Fusion) or use a program like CrossOver (Windows emulator based on Wine). Internet Explorer (just to see if my app works in this browser!), BI Publisher plug in for MS Word, PL/SQL Developer or Schema Compare for Oracle.
Running on Mac OSX is great and although most of the time I have a native Mac OSX app I can use, it sometimes happens I want to run a Windows-only program e.g.
0 kommentar(er)
