About 15,700,000 results
Open links in new tab
  1. How to generate an entity-relationship (ER) diagram using Oracle …

    Jul 5, 2011 · I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. What is the process for creating an ER diagram in SQL …

  2. How can I set a custom date time format in Oracle SQL Developer ...

    Nov 15, 2011 · By default, Oracle SQL developer displays date values as 15-NOV-11. I would like to see the time part (hour/minute/second) by default. Is there a way to configure this within …

  3. If Else with Select statement in Oracle sql developer

    Dec 3, 2015 · In order to provide such functionality each database developer typically provides an additional language that includes variable declaration, loops, conditionals, etc. For Oracle this …

  4. How to enable DBMS_OUTPUT in SQL Developer? [duplicate]

    Nov 28, 2021 · From the screenshot it seems you are using SQL Developer, which has a slightly complicated way of displaying dbms_output. First you have to show the dbms_output pane …

  5. Changing password with Oracle SQL Developer - Stack Overflow

    Jul 25, 2018 · Create a connection to the database in SQL Developer 4.1.0.17 with an alternative administrative user Expand the "Other Users" section once connected, and right-click the user …

  6. SQL to search objects, including stored procedures, in Oracle

    May 12, 2009 · Oracle SQL Developer offers this capability, as pointed out in this article : From the View menu, choose Find DB Object. Choose a DB connection. Enter the name of the …

  7. themes - How do I change the background color of the Query …

    Overall I would like to have a dark theme for Oracle SQL Developer. I know that I can go to the menu item Window/Preferences, Code Editor/PL/SQL Syntax Colors and select the …

  8. How to export large amount of data using sql developer - Oracle

    May 7, 2015 · 2-Or you can build in PL/SQL a procedure in UAT DB to export data to a file in CSV format and in DEV DB use oracle external tables to SELECT from that files. Be carefull about …

  9. SQL Developer with JDK (64 bit) cannot find JVM - Stack Overflow

    Jul 2, 2015 · 44 I just wasted one morning trying to get SQL developer to work on my current setup: OS: Windows 8.1 virtual machine running on mac via Parallels. No oracle client or …

  10. How do I view a Tree list of Schemas for a database in Oracle SQL ...

    Feb 19, 2016 · How do I view the schemas, that belong to a database in SQL Developer? I am trying to get a view similar to Toad. In that you have the database name at the parent level, all …