SQL Developer FAQThis is a featured page

This page presents a set of frequently asked questions about Oracle's SQL Developer and links to where to find the answers to them.

  • Is there a list of SQL Developer hotkeys or accelerators?:

  • How to remote debug with SQL Developer?
  • You can use this setup for almost every front-end.
  • More of the same. [Sue Harper's Blogspot on Remote Debugging]

  • How do you run SQL Developer version on Windows XP 64 bit?
    • Use the .bat file: <unzip>/sqldeveloper/bin/sqldeveloper.bat

  • I'm having trouble with SQL Developer 1.5EA and Windows Vista? Are there any fixes?

  • How does SQL Developer find my TNSNames file?
    • SQL Developer checks the following:
      1) $HOME/tnsnames.ora
      2) $TNS_ADMIN/tnsnames.ora
      3) /etc/tnsnames.ora ( non-windows )
      4) $ORACLE_HOME/network/admin/tnsnames.ora
      5) Registry Key


    • SQL Developer just won't start - not even the splash screen will display
      • Verify that you have unzipped the SQL Developer file into an empty folder
      • Verify that the installation directory and the JDK path have no spaces

    • My TNS List of Values is empty when using ifile= in tnsnames.ora
      • See MetaLink note 727224.1 TNS LOV is Empty when Using ifile that Points to a Network tnsnames.ora.

      OTN SQL Developer Forum:



      No user avatar
      rvanvugt
      Latest page update: made by rvanvugt , Jul 23 2008, 9:41 AM EDT (about this update About This Update rvanvugt Added MetaLink note reference - rvanvugt

      29 words added

      view changes

      - complete history)
      Keyword tags: Oracle SQL Developer FAQ
      More Info: links to this page
      Started By Thread Subject Replies Last Post
      kushanxp Do i have to install oracle 10g client 9 Wednesday, 9:34 AM EST by naveenhks
      Thread started: Oct 20 2009, 2:22 PM EDT  Watch
      Hi..

      I have installed oracle enterprise 10g on a server and still i didnt install oracle client on my machine...my question is do i have to install oracle client in order to use the sql developer
      Do you find this valuable?    
      Keyword tags: Oracle SQL Developer FAQ
      Show Last Reply
      Dhabas Debugging in sql Developer 0 Dec 29 2008, 4:33 AM EST by Dhabas
      Thread started: Dec 29 2008, 4:33 AM EST  Watch
      Can Any one describe me how to debug a procedure line by line in by using sql developer ?
      0  out of 1 found this valuable. Do you?    
      Keyword tags: 11g database
      andrewkeating Publish to APEX ? 1 May 2 2008, 2:40 PM EDT by emocat
      Thread started: May 1 2008, 5:25 PM EDT  Watch
      In SQL Developer 1.5 there is a right-click menu item "Publish to APEX" on report results.

      Whatever connection I try I always get an "ORA-00942 : table or view does not exist"

      There seems to be nothing in the documentation about this feature. Can anyone tell me how / whether this works?

      Thanks
      Andy

      1  out of 1 found this valuable. Do you?    
      Keyword tags: Oracle SQL Developer FAQ
      Show Last Reply
      Showing 3 of 3 threads for this page

      Related Content

        (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)