In SQL Developer, from the top menu choose Tools &gt; Data Export.  This launches the Data Export wizard.  It&#39;s pretty straightforward from there.  

There is a tutorial on the OTN site.  [Find it here][1].


  [1]: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/SQLdev3.0_Import_Export/sqldev3.0_import_export.htm

In **version 3**, they changed &quot;**export**&quot; to &quot;**unload**&quot;. It still functions more or less the same.

If, at some point, you only need to export a single result set, just right click &quot;on the data&quot; (any column of any row) there you will find an export option.
The wizard exports the complete result set regardless of what you selected

To export data you need to right click on your results and select export data, after which you will be asked for a specific file format such as `insert`, `loader`, or `text` etc. After selecting this browse your directory and select the export destination.

Our toolkit has over 15000 [JUnit][1] tests, and many tests are known to fail if some other test fails. For example, if the method X.foo() uses functionality from Y.bar() and YTest.testBar() fails, then XTest.testFoo() will fail too. Obviously, XTest.testFoo() can also fail because of problems specific to X.foo().

While this is fine and I still want both tests run, it would be nice if one could annotate a test dependency with XTest.testFoo() pointing to YTest.testBar(). This way, one could immediately see what functionality used by X.foo() is also failing, and what not.

Is there such annotation available in JUnit or elsewhere? Something like:

    public XTest {

      @Test
      @DependsOn(method=org.example.tests.YTest#testBar)
      public void testFoo() {
         // Assert.something();
      }
    
    }


  [1]: http://www.junit.org/

How can I specify JUnit test dependencies?

I remember when I was developing in C++ or Java, the compiler usually complains for unused methods, functions or imports.  In my Django project, I have a bunch of Python files which have gone through a number of iterations.  Some of those files have a few lines of import statement at the top of the page and some of those imports are not used anymore.  Is there a way to locate those unused imports besides eyeballing each one of them in each file?

All my imports are explicit, I don&#39;t usually write `from blah import *`

How can I check for unused import in many Python files?

How to export Oracle DB data using SQL Developer? I need all data, tables, constraints, structure and so on.

How to export data with Oracle SQL Developer?

<p>How to export Oracle DB data using SQL Developer? I need all data, tables, constraints, structure and so on.</p>


A few examples to show, just incase:

*Inline Table Valued*

    CREATE FUNCTION MyNS.GetUnshippedOrders()
    RETURNS TABLE
    AS 
    RETURN SELECT a.SaleId, a.CustomerID, b.Qty
        FROM Sales.Sales a INNER JOIN Sales.SaleDetail b
            ON a.SaleId = b.SaleId
            INNER JOIN Production.Product c ON b.ProductID = c.ProductID
        WHERE a.ShipDate IS NULL
    GO

*Multi Statement Table Valued*

    CREATE FUNCTION MyNS.GetLastShipped(@CustomerID INT)
    RETURNS @CustomerOrder TABLE
    (SaleOrderID    INT         NOT NULL,
    CustomerID      INT         NOT NULL,
    OrderDate       DATETIME    NOT NULL,
    OrderQty        INT         NOT NULL)
    AS
    BEGIN
        DECLARE @MaxDate DATETIME
       
        SELECT @MaxDate = MAX(OrderDate)
        FROM Sales.SalesOrderHeader
        WHERE CustomerID = @CustomerID
    
        INSERT @CustomerOrder
        SELECT a.SalesOrderID, a.CustomerID, a.OrderDate, b.OrderQty
        FROM Sales.SalesOrderHeader a INNER JOIN Sales.SalesOrderHeader b
            ON a.SalesOrderID = b.SalesOrderID
            INNER JOIN Production.Product c ON b.ProductID = c.ProductID
        WHERE a.OrderDate = @MaxDate
            AND a.CustomerID = @CustomerID
        RETURN
    END
    GO
       
Is there an advantage to using one type (in-line or multi statement) over the other? Is there certain scenarios when one is better than the other or are the differences purely syntactical? I realise the two example queries are doing different things but is there a reason I would write them in that way?

Reading about them and the advantages/differences haven&#39;t really been explained.

Multi-statement Table Valued Function vs Inline Table Valued Function

How to detect if a string contains at least a number (digit) in SQL server 2005?

How to detect if a string contains at least a number?

I am in the middle of designing a highly-scalable application which must store a lot of data. Just for example it will store lots about users and then things like a lot of their messages, comments etc. I have always used MySQL before but now I am minded to try something new like couchdb or similar which is not SQL.

Does anyone have any thoughts or guidance on this?

SQL (MySQL) vs NoSQL (CouchDB)

I have a table and I&#39;d like to pull one row per id with field values concatenated.

In my table, for example, I have this:

    TM67 | 4  | 32556
    TM67 | 9  | 98200
    TM67 | 72 | 22300
    TM99 | 2  | 23009
    TM99 | 3  | 11200

And I&#39;d like to output:

    TM67 | 4,9,72 | 32556,98200,22300
    TM99 | 2,3    | 23009,11200

In MySQL I was able to use the aggregate function `GROUP_CONCAT`, but that doesn&#39;t seem to work here... Is there an equivalent for PostgreSQL, or another way to accomplish this?

Postgresql GROUP_CONCAT equivalent?

I have a table that looks like this:

    id   count
    1    100
    2    50
    3    10

I want to add a new column called cumulative_sum, so the table would look like this:

    id   count  cumulative_sum
    1    100    100
    2    50     150
    3    10     160

Is there a MySQL update statement that can do this easily? What&#39;s the best way to accomplish this?


Create a Cumulative Sum Column in MySQL

I would like to create a temporary table in a Oracle database

something like 

    Declare table @table (int id)

In SQL server

And then populate it with a select statement

Is it possible?

Thanks

How do you create a temporary table in an Oracle database?

Using the DUAL table, how can I get a list of numbers from 1 to 100?

SQL to generate a list of numbers from 1 to 100

    date                 value
    
    18/5/2010, 1 pm        40
    18/5/2010, 2 pm        20
    18/5/2010, 3 pm        60
    18/5/2010, 4 pm        30
    18/5/2010, 5 pm        60
    18/5/2010, 6 pm        25 

i need to query for the row having max(value)(i.e. 60). So, here we get two rows. From that, I need the row with the lowest time stamp for that day(i.e 18/5/2010, 3 pm -&gt; 60)

SQL - How to select a row having a column with max value

How do I insert a record in a column having varchar data type having single quote in it?

**Example**: first name is `ROBERT` and last name is **`D&#39;COSTA`**

How to handle a single quote in Oracle SQL

I&#39;m developing a web application and need to page ordered results. I normaly use LIMIT/OFFSET for this purpose.

Which is the best way to page ordered results in Oracle? I&#39;ve seen some samples using rownum and subqueries. Is that the way? Could you give me a sample for translating this SQL to Oracle:

    SELECT fieldA,fieldB 
    FROM table 
    ORDER BY fieldA 
    OFFSET 5 LIMIT 14

(I&#39;m using Oracle 10g, for what it&#39;s worth)

Thanks!

 


----------


 

**Answer:**
Using the link provided below by karim79, this SQL would look like:

    SELECT * FROM (
        SELECT rownum rnum, a.* 
        FROM(
            SELECT fieldA,fieldB 
            FROM table 
            ORDER BY fieldA 
        ) a 
        WHERE rownum &lt;=5+14
    )
    WHERE rnum &gt;=5



Alternatives to LIMIT and OFFSET for paging in Oracle

I just installed Oracle 11g, and tried to start Oracle SQL developer so as to start writing queries.

It is asking me:

    Enter the full pathname for the java.exe file .

Where do I find this? I did a global search for `java.exe` and am sure did not get some Oracle related pdf files. Also my Oracle is installed out of users/vas.


Where to get this Java.exe file for a SQL Developer installation

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. 

I can&#39;t get the SQLPlus command &quot;password&quot; to work in SQL developer.


1. When I hit run, I get an invalid command error
2. When I hit run script, nothing happens.

I don&#39;t want to write them a package to change their passwords since we have a lot of databases. Do I have a better option? 

Changing password with Oracle SQL Developer

I&#39;ve just made the switch from MS sql server to Oracle.  The query tool I am using is Oracle SQL Developer.  The problem I am having is that I cannot get the query results window to stick around. The query results window being the Grid view for the results.  It seems to show up arbitrarily when I open a new &quot;sql worksheet&quot;.  But not always.  Then once I run a query, it disappears the next time I run one.

Can anyone point me to a consistent way to leave this results grid active? Thanks so much.

Oracle SQL Developer - Query results window with grid missing

I am trying to run a stored procedure that has multiple in and out paramaters. The procedure can only be viewed in my Connections panel by navigating Other Users | &lt;user&gt; | Packages | &lt;package&gt; | &lt;procedure&gt;

If I right click &lt;procedure&gt;, the menu items are &quot;Order Members By...&quot; and &quot;Create Unit Test&quot; (greyed out). The ability to &quot;Run&quot; the procedure does not seem possible when it&#39;s accessed by user.

I have been trying to find an example of how to create an anonymous block so that I can run the procedure as a SQL file, but haven&#39;t found anything that works.

Does anyone know how I can execute this procedure from SQL Developer? I am using Version 2.1.1.64.

Thanks in advance!

**EDIT 1:**

The procedure I want to call has this signature:

    user.package.procedure(
       p_1 IN  NUMBER,
       p_2 IN  NUMBER,
       p_3 OUT VARCHAR2,
       p_4 OUT VARCHAR2,
       p_5 OUT VARCHAR2,
       p_6 OUT NUMBER)

If I write my anonymous block like this:

    DECLARE
       out1 VARCHAR2(100);
       out2 VARCHAR2(100);
       out3 VARCHAR2(100);
       out4 NUMBER(100);
    BEGIN
       EXECUTE user.package.procedure (33,89, :out1, :out2, :out3, :out4);
    END;

I get the error:

    Bind Varialbe &quot;out1&quot; is NOT DECLCARED
    anonymous block completed

I&#39;ve tried initializing the out* variables:

       out1 VARCHAR2(100) := &#39;&#39;;

but get the same error:

**EDIT 2:**

Based on Alex&#39;s answer, I tried removing the colons from in front of the params and get this:

    Error starting at line 1 in command:
    DECLARE
       out1 VARCHAR2(100);
       out2 VARCHAR2(100);
       out3 VARCHAR2(100);
       out4 NUMBER(100);
    BEGIN
       EXECUTE user.package.procedure (33,89, out1, out2, out3, out4);
    END;
    Error report:
    ORA-06550: line 13, column 17:
    PLS-00103: Encountered the symbol &quot;USER&quot; when expecting one of the following:

       := . ( @ % ; immediate
    The symbol &quot;:=&quot; was substituted for &quot;USER&quot; to continue.
    06550. 00000 -  &quot;line %s, column %s:\n%s&quot;
    *Cause:    Usually a PL/SQL compilation error.
    *Action:


Run Stored Procedure in SQL Developer?

I&#39;ve been given a user account to a SQL Server database that only has privileges to execute a stored procedure. I added the JTDS SQL Server JDBC jar file to SQL Developer and added it as a Third Party JDBC driver. I can successfully log in to the SQL Server database.  I was given this syntax for running the procedure:

    EXEC proc_name &#39;paramValue1&#39; &#39;paramValue2&#39;

When I run this as either a statement or a script, I get this error:

    Error starting at line 1 in command:
    EXEC proc_name &#39;paramValue1&#39; &#39;paramValue2&#39;
    Error report:
    Incorrect syntax near the keyword &#39;BEGIN&#39;.

I tried wrapping the statement in `BEGIN/END`, but get the same error.  Is it possible to call the procedure from SQL Developer?  If so, what syntax do I need to use?

Content Type	Original Author	Original Content on Stackoverflow
Question	Adomas	View Question on Stackoverflow
Solution 1 - Sql	APC	View Answer on Stackoverflow
Solution 2 - Sql	Eddie Canales	View Answer on Stackoverflow
Solution 3 - Sql	systemkern	View Answer on Stackoverflow
Solution 4 - Sql	Pankaj Sharma	View Answer on Stackoverflow

How to export data with Oracle SQL Developer?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

How can I check for unused import in many Python files?

How can I specify JUnit test dependencies?

Attributions