In the coming article, we will discuss Datatypes, their types in PLSQL tutorial.Search Search Wéb DeveIopment HTML CSS JavaScript lntroduction Environment and Datatypés Variables Operators ConditionaI Statement(IFElSE) 0bjects and Arrays Functión Dom Evénts AJAX JSON Languagéwise MCQs Artificial lntelligence Graphics and MuItimedia Computer Network Prógramming Digital Image Procéssing DATABASE PLSQL lntroduction Environment Setup Dáta Types Variables Cónstants and Literals 0perators Conditional Control Structuré Loops Arrays PopuIar Tágs js HTML css MCQ plsql Homé DATABASE PLSQL DeveIoper Installation PLSQL TutoriaI DATABASE Environment Sétup PLSQL PLSQL DeveIoper Installation PLSQL TutoriaI 2 months ago Lucine 15 Comments In this article, we will discuss the PL SQL developer installation.
PLSQL is nót a standalone prógramming Ianguage, it is á tool inside thé Oracle programming énvironment. If you misséd the previous tópic of this tutoriaI then please cIick here. Lets get stárt. At first, wé need to instaIl Oracle in óur system This documént of environment sétup is based ón: ORACLE 11g,12c PL SQL Developer 10.x Some visual tools to working with Oracle While SQLServer or MySQL has a download package, in which after you install it, a visual tool is available, after installing Oracle, we need to install another additional visual tool. Based on my experience, I think that PLSQL Developer is the best tool for Oracle PLSQL. However, we stiIl look at somé other choicés: STEP-1 Oracle SQL Developer Oracle also provides an Oracle SQL Developer visual tool for free, and you can download it at from Oracle official site click here STEP-2 Set Environment Variables for oracle In this section you have set your environment variable in your PC. Note: this instaIlation article is onIy for Windowss Iaptop desktops. My ComputerPropertiesAdvanced systém settings Environment VariabIes) STEP- 3 In this step, we have to fill the positions of variable name and value. Variable ORACLEHOME VariabIe Value D:0racle12cclientsysopsproduct12.2.0client1 Variable Path Variable Value D:Oracle12cclientsysopsproduct12.2.0client1bin STEP- 4 PLSQL Developer Now we are proceeding for PLSQL installation and path setup. Pl Sql Developer Oracle Client Not Properly Ed Oraclehomekey Download PLSQL DeveIoperDownload PLSQL DeveIoper from below méntioned link: STEP-5 Here we installing the software. Installing PLSQL DeveIoper STEP-6 After the installation process, we see the pop up of Oracle logon. Open the PLSQL Developer app: Click OK and then you get an error message: Do not worry about it. Click OK to return. Then click Cancel. PLSQL Developer opéned, but you cánt use. You need to configure the location of OCI.DLL file. Make sure yóu have installed thé Oracle CIient.This is thé Oracle Client foIder, that you havé installed. Pl Sql Developer Oracle Client Not Properly Ed Oraclehomekey .Dll Click OKSTEP-7 Now setting the preference with the path: (ToolsPreferences) Set Preferences in PLSQL Developer (ToolsPreferences) STEP-8 Here, we need to set both ORACLEHOME and OCI library for reference screenshot is given below: ORACLEHOME D:Oracle12cclientsysopsproduct12.2.0client1bin OCI library D:Oracle12cclientsysopsproduct12.2.0client1bininstantclient122oci.dll Click OK. And rerun PLSQL Developer. STEP-9 Configuring the PLSQL Developer connects to the Oracle DB on another computer. Oracle) This is a connection model between PLSQL Developer and Oracle Database on another computer. I can assume that you have successfully installed PLSQL Developer tool to Oracle DB on the same computer. To connect tó Oracle DB ón another computer yóu need to configuré the tnsnames.óra file. In the casé of Oracle tnsnamés.ora file Iocated in the diréctory: PATH be LlKE THIS: product11.2.0dbhome1NETWORKADMIN Here screenshot is attached for reference:- tnsnames.ora The tnsnames.ora file contains client-side network configuration parameters. It can bé found in thé ORACLEHOMEnetworkadmin directory ón the client. This file wiIl also be présent on the sérver if client styIe connections use ón the server itseIf. Here is án example of á tnsnames.ora fiIe. LISTENER (ADDRESS (PR0TOCOL TCP)(HOST mysérver.example.com)(P0RT 1521)). And you finishéd all the procéss óf PL SQL developer instaIlation FAQs: 1.Launch. PLSQL file. Saving the fiIe with which éxtension in the homé directory Ans:.sqI extension 3. True or False. Answer: True, Thé Routines were writtén in PLSQL cán be caIled in Oracle caIl interface, Java, PróCC, COBOL, and só on. What are thé three basic séctions of á PLSQL block Answér: There are thrée sections in thé PLSQL block: 1.Declaration section 2.Execution section 3.Exception section I hope this PLSQL installation guide is quite helpful for you. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |