You will see a running task in the Task Progress View by clicking on View -&gt; Task Progress.

From menu of Oracle Sql Developer 

 1. Choose `View`.
 2. Then choose `Task Progress`.
 3. The view will appear in tab located in lower right corner.

 
**`View -&gt; Task Progress`**

[![View Task Progress Menue][1]][1]
[![Task Progress View Tab][2]][2]


  [1]: http://i.stack.imgur.com/vdWJD.png
  [2]: http://i.stack.imgur.com/zrk32.png

I want to initialize an array of Player objects for a BlackJack game. I&#39;ve read a lot about various ways to initialize primitive objects like an array of ints or an array of strings but I cannot take the concept to what I am trying to do here (see below). I would like to return an array of initialized Player objects. The number of player objects to create is an integer for which I prompt the user. I was thinking the constructor could accept an integer value and name the player accordingly while initializing some member variables of the Player object. I think I am close but still quite confused too.

    static class Player
	{
		private String Name;
		private int handValue;
		private boolean BlackJack;
	    private TheCard[] Hand;
	   
	    public Player(int i)
	    {
	    	if (i == 0)
			{
	    		this.Name = &quot;Dealer&quot;; 
			}
			else
			{
				this.Name = &quot;Player_&quot; + String.valueOf(i);
			}
	        this.handValue = 0;
	        this.BlackJack = false;
	        this.Hand = new TheCard[2];
	    } 
	}
	private static Player[] InitializePlayers(int PlayerCount)
    { //The line below never completes after applying the suggested change
		Player[PlayerCount] thePlayers;
		for(int i = 0; i &lt; PlayerCount + 1; i++)
		{
			thePlayers[i] = new Player(i);
		}
		return thePlayers;
    }
***EDIT - UPDATE:***
Here is what I am getting after changing this as I understood your suggestion:

    Thread [main] (Suspended)	
	    ClassNotFoundException(Throwable).&lt;init&gt;(String, Throwable) line: 217	
	    ClassNotFoundException(Exception).&lt;init&gt;(String, Throwable) line: not available	
	    ClassNotFoundException.&lt;init&gt;(String) line: not available	
	    URLClassLoader$1.run() line: not available	
	    AccessController.doPrivileged(PrivilegedExceptionAction&lt;T&gt;, AccessControlContext) line: not available [native method]	
	    Launcher$ExtClassLoader(URLClassLoader).findClass(String) line: not available	
	    Launcher$ExtClassLoader.findClass(String) line: not available	
	    Launcher$ExtClassLoader(ClassLoader).loadClass(String, boolean) line: not available	
	    Launcher$AppClassLoader(ClassLoader).loadClass(String, boolean) line: not available	
	    Launcher$AppClassLoader.loadClass(String, boolean) line: not available	
	    Launcher$AppClassLoader(ClassLoader).loadClass(String) line: not available	
	    BlackJackCardGame.InitializePlayers(int) line: 30	
	    BlackJackCardGame.main(String[]) line: 249	


How to initialize an array of objects in Java

I am looking for what type of code would I put in `__init__.py` files and what are the best practices related to this. Or, is it a bad practice in general ?

Any reference to known documents that explain this is also very much appreciated.


Why would I put code in __init__.py files?

I have a csv unload process i am running in sqldeveloper, a process window popped up showing the progress of the export and it had an option to run the process in background, I picked the option but now how do I know if the process is complete?

How to see if the background process is complete in SQLDEVELOPER

<p>I have a csv unload process i am running in sqldeveloper, a process window popped up showing the progress of the export and it had an option to run the process in background, I picked the option but now how do I know if the process is complete?</p>


Is it possible to create user-defined exceptions and be able to change the SQLERRM?

For example:


    DECLARE
        ex_custom       EXCEPTION;
    BEGIN
        RAISE ex_custom;
    EXCEPTION
        WHEN ex_custom THEN
            DBMS_OUTPUT.PUT_LINE(SQLERRM);
    END;
    /


The output is &quot;User-Defined Exception&quot;.  Is it possible to change that message?



EDIT:  Here is some more detail.

I hope this one illustrates what I&#39;m trying to do better.

    DECLARE
        l_table_status      VARCHAR2(8);
        l_index_status      VARCHAR2(8);
        l_table_name        VARCHAR2(30) := &#39;TEST&#39;;
        l_index_name        VARCHAR2(30) := &#39;IDX_TEST&#39;;
        ex_no_metadata      EXCEPTION;
    BEGIN
        
        BEGIN
            SELECT  STATUS
            INTO    l_table_status
            FROM    USER_TABLES
            WHERE   TABLE_NAME      = l_table_name;
        EXCEPTION
            WHEN NO_DATA_FOUND THEN
                -- raise exception here with message saying
                -- &quot;Table metadata does not exist.&quot;
                RAISE ex_no_metadata;
        END;
        
        BEGIN
            SELECT  STATUS
            INTO    l_index_status
            FROM    USER_INDEXES
            WHERE   INDEX_NAME      = l_index_name;
        EXCEPTION
            WHEN NO_DATA_FOUND THEN
                -- raise exception here with message saying
                -- &quot;Index metadata does not exist.&quot;
                RAISE ex_no_metadata;
        END;
        
    EXCEPTION
        WHEN ex_no_metadata THEN
            DBMS_OUTPUT.PUT_LINE(&#39;Exception will be handled by handle_no_metadata_exception(SQLERRM) procedure here.&#39;);
            DBMS_OUTPUT.PUT_LINE(SQLERRM);
    END;
    /



In reality, there are dozens of those sub-blocks.  I&#39;m wondering if there&#39;s a way to have a single user-defined exception for each of those sub-blocks to raise, but have it give a different message, instead of creating a separate user-defined exception for each sub-block.

In .NET, it would be sort of like having a custom exception like this:

        public class ColorException : Exception
        {
            public ColorException(string message)
                : base(message)
            {
            }
        }

And then, a method would have something like this:

            if (isRed)
            {
                throw new ColorException(&quot;Red is not allowed!&quot;);
            }

            if (isBlack)
            {
                throw new ColorException(&quot;Black is not allowed!&quot;);
            }

            if (isBlue)
            {
                throw new ColorException(&quot;Blue is not allowed!&quot;);
            }

Oracle PL/SQL - Raise User-Defined Exception With Custom SQLERRM

I tried to write the following inner join query using an Oracle database:

     SELECT Employee.EMPLID as EmpID, 
            Employee.FIRST_NAME AS Name,
            Team.DEPARTMENT_CODE AS TeamID, 
            Team.Department_Name AS teamname
     FROM PS_TBL_EMPLOYEE_DETAILS Employee
     INNER JOIN PS_TBL_DEPARTMENT_DETAILS Team 
     ON Team.DEPARTMENT_CODE = Employee.DEPTID

That gives the below error:

     INNER JOIN PS_TBL_DEPARTMENT_DETAILS Team ON Team.DEPARTMENT_CODE = Employee.DEPTID
                                                  *
    ERROR at line 4:
    ORA-00904: &quot;TEAM&quot;.&quot;DEPARTMENT_CODE&quot;: invalid identifier

The DDL of one table is:

    CREATE TABLE &quot;HRMS&quot;.&quot;PS_TBL_DEPARTMENT_DETAILS&quot;
    (
      &quot;Company Code&quot; VARCHAR2(255),
      &quot;Company Name&quot; VARCHAR2(255),
      &quot;Sector_Code&quot; VARCHAR2(255),
      &quot;Sector_Name&quot; VARCHAR2(255),
      &quot;Business_Unit_Code&quot; VARCHAR2(255),
      &quot;Business_Unit_Name&quot; VARCHAR2(255),
      &quot;Department_Code&quot; VARCHAR2(255),
      &quot;Department_Name&quot; VARCHAR2(255),
      &quot;HR_ORG_ID&quot; VARCHAR2(255),
      &quot;HR_ORG_Name&quot; VARCHAR2(255),
      &quot;Cost_Center_Number&quot; VARCHAR2(255),
      &quot; &quot; VARCHAR2(255)
    )
    SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS





ORA-00904: invalid identifier

For some reason, people in the past have inserted data without using sequence.NEXTVAL.  So when I go to use sequence.NEXTVAL in order to populate a table, I get a PK violation, since that number is already in use in the table.

How can I update the next value so that it is usable?  Right now, I&#39;m just inserting over and over until it&#39;s successful (`INSERT INTO tbl (pk) VALUES (sequence.NEXTVAL)`), and that syncs up the nextval.

Best way to reset an Oracle sequence to the next value in an existing column?

I&#39;m using Oracle&#39;s `ojdbc5.jar` and noticed that it includes two JDBC driver classes.

What is the difference between `oracle.jdbc.driver.OracleDriver` vs. `oracle.jdbc.OracleDriver`?

Which one should I use in my Java project?

Difference between Oracle jdbc driver classes?

Suppose I have a column name `OrderNo` with value `AO025631` in a table `shipment`.

I am trying to query the table so that I can get only first two character of column value i.e. `AO`.

Can I do this in the SQL query itself?   


How to get first two characters of a string in oracle query?

I&#39;m developing a part of an application that&#39;s responsible for exporting some data into CSV files. The application always uses UTF-8 because of its multilingual nature at all levels. But opening such CSV files (containing e.g. diacritics, cyrillic letters, Greek letters) in Excel does not achieve the expected results showing something like `Г„/Г&#164;, Г–/Г&#182;`. And I don&#39;t know how to force Excel understand that the open CSV file is encoded in UTF-8. I also tried specifying UTF-8 BOM `EF BB BF`, but Excel ignores that.

Is there any workaround?

P.S. Which tools may potentially behave like Excel does?

----

UPDATE

I have to say that I&#39;ve confused the community with the formulation of the question. When I was asking this question, I asked for a way of opening a UTF-8 CSV file in Excel without any problems for a user, in a fluent and transparent way. However, I used a wrong formulation asking for doing it _automatically_. That is very confusing and it clashes with VBA macro automation. There are two answers for this questions that I appreciate the most: the very first answer by Alex https://stackoverflow.com/a/6002338/166589, and I&#39;ve accepted this answer; and the second one by Mark https://stackoverflow.com/a/6488070/166589 that have appeared a little later. From the usability point of view, Excel seemed to have lack of a good user-friendly UTF-8 CSV support, so I consider _both_ answers are correct, and I have accepted Alex&#39;s answer first because it really stated that Excel was not able to do that transparently. That is what I confused with _automatically_ here. Mark&#39;s answer promotes a more complicated way for more advanced users to achieve the expected result. Both answers are great, but Alex&#39;s one fits my not clearly specified question a little better.

----

UPDATE 2

Five months later after the last edit, I&#39;ve noticed that Alex&#39;s answer has disappeared for some reason. I really hope it wasn&#39;t a technical issue and I hope there is no more discussion on which answer is greater now. So I&#39;m accepting Mark&#39;s answer as the best one.

Is it possible to force Excel recognize UTF-8 CSV files automatically?

I&#39;m new to SQLite.  Is there a way I can export the results of a query into a CSV file?

SQLite: How do I save the result of a query as a CSV file?

Is there a way to dump a NumPy array into a CSV file? I have a 2D NumPy array and need to dump it in human-readable format.

Dump a NumPy array into a csv file

Imploding  a simple array 

would look like this

	$array = array(&#39;lastname&#39;, &#39;email&#39;, &#39;phone&#39;);
	$comma_separated = implode(&quot;,&quot;, $array);

and that would return this

     lastname,email,phone

great, so i might do this instead 

	$array = array(&#39;lastname&#39;, &#39;email&#39;, &#39;phone&#39;);
	$comma_separated = implode(&quot;&#39;,&#39;&quot;, $array);
	$comma_separated = &quot;&#39;&quot;.$comma_separated.&quot;&#39;&quot;;

and now i have what I want a nice pretty csv string 

     &#39;lastname&#39;,&#39;email&#39;,&#39;phone&#39;

is there a better way to do this, it feels to me like there should be an optional parameter for implode am I missing something ?



php implode (101) with quotes

I would like to use the psql &quot;\copy&quot; command to pull data from a tab-delimited file into Postgres.  I&#39;m using this command:

    \copy cm_state from &#39;state.data&#39; with delimiter &#39;\t&#39; null as ;

But I&#39;m getting this warning (the table actually loads fine):

    WARNING:  nonstandard use of escape in a string literal
    LINE 1: COPY cm_state FROM STDIN DELIMITER &#39;\t&#39; NULL AS &#39;;&#39;
    HINT:  Use the escape string syntax for escapes, e.g., E&#39;\r\n&#39;.

How do I specify a tab if &#39;\t&#39; is not correct?


How to specify a tab in a postgres front-end COPY

I have a view which is used as an item in a `ListView`. In my custom adapter, I change the background of the view using `View.setBackgroundResource()` depending on the item&#39;s position in the list. (I have separate assets for the first and last items in the list.)

This sets the correct background image as expected, but it has the nasty side-effect that  all the padding I&#39;d set in the XML definition of the view is completely ignored.

(If I set the background drawable in the XML, and don&#39;t try to vary it at runtime in the adapter, the padding all works fine.)

How can I alter the background image, and retain the padding? Is this a bug?

**EDIT** it seems someone else has found the same problem here: https://stackoverflow.com/questions/2886140/does-change-the-background-change-the-padding-of-a-linear-layout

setBackgroundResource() discards my XML layout attributes

There are many tutorials out there and questions on SO that implement custom title bars.  However, in my custom title bar I have a custom gradient for the background and I would like to know how to set it dynamically in my code.

Here is where my custom title bar gets called:

    requestWindowFeature(Window.FEATURE_CUSTOM_TITLE);
    setContentView(R.layout.foo_layout);
    getWindow().setFeatureInt(Window.FEATURE_CUSTOM_TITLE, R.layout.custom_title_bar); 

And this is my `custom_title_bar`:

    &lt;LinearLayout xmlns:android=&quot;http://schemas.android.com/apk/res/android&quot;
	    android:orientation=&quot;horizontal&quot;
	    android:layout_width=&quot;fill_parent&quot;
	    android:layout_height=&quot;fill_parent&quot;
	    android:background=&quot;@layout/custom_title_bar_background_colors&quot;&gt;
    &lt;ImageView   
				  android:layout_width=&quot;fill_parent&quot;
				  android:layout_height=&quot;wrap_content&quot;
				  android:src=&quot;@drawable/title_bar_logo&quot;
				  android:gravity=&quot;center_horizontal&quot;
				  android:paddingTop=&quot;0dip&quot;/&gt;
 
    &lt;/LinearLayout&gt;

As you can see, the background on the linear layout is defined by this guy:

    &lt;shape xmlns:android=&quot;http://schemas.android.com/apk/res/android&quot;&gt;
    &lt;gradient 
        android:startColor=&quot;#616261&quot; 
        android:endColor=&quot;#131313&quot;
        android:angle=&quot;270&quot;
     /&gt;
    &lt;corners android:radius=&quot;0dp&quot; /&gt;
    &lt;/shape&gt;


What I would like to do is set those gradient colors dynamically in my code.  I do not want to hard code them in my XML file like they currently are.

I am open to all ideas if you have a better way of setting a background gradient.  

Thank you in advance!!

How do I programmatically set the background color gradient on a Custom Title Bar?

Does anyone know how to set a scheduled task to run in background using Windows Task Scheduler?&lt;br&gt;
There doesn&#39;t seem to be any option to do this.

How do I set a Windows scheduled task to run in the background?

I want to remove the background drawable `@drawable/bg` programmatically.
Is there a way to do that? 

Currently, I have the following XML in my layout:

	&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
	&lt;RelativeLayout
		android:id=&quot;@+id/widget29&quot;
		android:layout_width=&quot;fill_parent&quot;
		android:layout_height=&quot;fill_parent&quot;
		xmlns:android=&quot;http://schemas.android.com/apk/res/android&quot;
		android:background=&quot;@drawable/bg&quot;&gt;

	&lt;/RelativeLayout&gt;


Remove background drawable programmatically in Android

Let&#39;s say I have

    &lt;div class=&quot;myDiv&quot;&gt;Hi there&lt;/div&gt;

I want to put a `background-image` and give it an `opacity` of `0.5` – but I want that the text I have written will have full opacity (`1`). 

If I would write the CSS like this

&lt;!-- language: lang-css --&gt;

    .myDiv { opacity:0.5 }

 **everything** will be in low opacity – and I don&#39;t want that.

So my question is – How can I get low-opacity background image with full opacity text?

Can I set an opacity only to the background image of a div?

Looking at a random [source file][1] of the `express` framework for `NodeJS`, there are two lines of the code that I do not understand (these lines of code are typical of almost all NodeJS files).

    /**
     * Expose `Router` constructor.
     */
        
    exports = module.exports = Router;
and

    /**
     * Expose HTTP methods.
     */
    
    var methods = exports.methods = require(&#39;./methods&#39;);

I understand that the _first piece of code_ **allows the rest of the functions in the file to be exposed to the NodeJS app**, but I don&#39;t understand exactly **how it works**, or what the code in the line means. 

&gt; What do `exports` and `module.exports` actually mean?

I believe the 2nd piece of code allows the functions in the file to access `methods`, but again, how exactly does it do this.

Basically, what are these magic words: **`module`** and **`exports`**?




  [1]: https://github.com/visionmedia/express/blob/master/lib/router/index.js

What do &quot;module.exports&quot; and &quot;exports.methods&quot; mean in NodeJS / Express?

I&#39;m getting this warning in Eclipse:

&gt; Classpath entry org.eclipse.m2e.MAVEN2_CLASSPATH_CONTAINER will not be exported or published. Runtime ClassNotFoundExceptions may result

After searching I found that I need fix export. I did it.

![Eclipse Java Build Path properties][1]


  [1]: http://i.stack.imgur.com/dpAfD.jpg

But this warning persists!
What else can be done to fix it?
Thanks.

Classpath entry org.eclipse.m2e.MAVEN2_CLASSPATH_CONTAINER will not be exported

I have a table of data in an html table on a website and need to know how to export that data as .csv file.

How would this be done?

How do I export html table data as .csv file?

&gt; **Possible Duplicate:**  
&gt; [PDF Generation Library for Java](https://stackoverflow.com/questions/3986105/pdf-generation-library-for-java)  

&lt;!-- End of automatically inserted text --&gt;

I&#39;m working on an invoice program for a local accounting company.
What is a good way to create a PDF file with Java? Any good library?
I&#39;m totally new to PDF export (On any language).

Create PDF with Java

I have a bash script that sets an environment variable an runs a command

    LD_LIBRARY_PATH=my_path
    sqsub -np $1 /homedir/anotherdir/executable

Now I want to use python instead of bash, because I want to compute some of the arguments that I am passing to the command.

I have tried

    putenv(&quot;LD_LIBRARY_PATH&quot;, &quot;my_path&quot;)

and

    call(&quot;export LD_LIBRARY_PATH=my_path&quot;)

followed by

    call(&quot;sqsub -np &quot; + var1 + &quot;/homedir/anotherdir/executable&quot;)

but always the program gives up because LD_LIBRARY_PATH is not set.

How can I fix this?

Thanks for help!

(if I export LD_LIBRARY_PATH before calling the python script everything works, but I would like python to determine the path and set the environment variable to the correct value)

set environment variable in python script

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 Developer?

How to generate an entity-relationship (ER) diagram using Oracle SQL Developer

I&#39;m trying to connect to a PostgreSQL 9.1 database using Oracle SQL Developer 3.0.04, but I&#39;m not having any success so far.

First, if I add a third party driver on preferences, when adding a new connection there&#39;s no tab for PostgreSQL (it works fine for MySQL though). I&#39;m using a JDBC4 version 9.1 driver, but I tried a JDBC3 of the same version and still get the same thing.

Second, there&#39;s nothing like manual configuration tab when adding a new connection. The closest is the Advanced option on Oracle tab, where I can provide a custom URL, but it fails because complains about the selected Driver (of course).

Finally, I got connected importing a connection from an XML file (contents below), but it displays only my schemas and doesn&#39;t show my tables inside them.

So, my question is: does Orable SQL Developer support PostgreSQL connections? Is there any other way to have my tables being displayed in the ObjectViewer?

    &lt;?xml version = &#39;1.0&#39; encoding = &#39;UTF-8&#39;?&gt;
    &lt;References xmlns=&quot;http://xmlns.oracle.com/adf/jndi&quot;&gt;
        &lt;Reference name=&quot;Lumea&quot; className=&quot;oracle.jdeveloper.db.adapter.DatabaseProvider&quot; credentialStoreKey=&quot;Lumea&quot; xmlns=&quot;&quot;&gt;
            &lt;Factory className=&quot;oracle.jdeveloper.db.adapter.DatabaseProviderFactory&quot;/&gt;
            &lt;RefAddresses&gt;
                &lt;StringRefAddr addrType=&quot;user&quot;&gt;
                    &lt;Contents&gt;lumea&lt;/Contents&gt;
                &lt;/StringRefAddr&gt;
                &lt;StringRefAddr addrType=&quot;subtype&quot;&gt;
                    &lt;Contents&gt;thirdParty&lt;/Contents&gt;
                &lt;/StringRefAddr&gt;
                &lt;StringRefAddr addrType=&quot;customUrl&quot;&gt;
                    &lt;Contents&gt;jdbc:postgresql://localhost:5432/versates&lt;/Contents&gt;
                &lt;/StringRefAddr&gt;
                &lt;StringRefAddr addrType=&quot;SavePassword&quot;&gt;
                    &lt;Contents&gt;true&lt;/Contents&gt;
                &lt;/StringRefAddr&gt;
                &lt;StringRefAddr addrType=&quot;password&quot;&gt;
                    &lt;Contents&gt;myencryptedpass&lt;/Contents&gt;
                &lt;/StringRefAddr&gt;
                &lt;StringRefAddr addrType=&quot;driver&quot;&gt;
                    &lt;Contents&gt;org.postgresql.Driver&lt;/Contents&gt;
                &lt;/StringRefAddr&gt;
                &lt;StringRefAddr addrType=&quot;DeployPassword&quot;&gt;
                    &lt;Contents&gt;true&lt;/Contents&gt;
                &lt;/StringRefAddr&gt;
            &lt;/RefAddresses&gt;
        &lt;/Reference&gt;
    &lt;/References&gt;

Oracle SQL Developer and PostgreSQL

I am running a non-english Windows 7 system, and apparently Oracle SQL Developer (version 3.0.04.34, 64-bit) tries to auto-guess my preferred language based on the OS. Is there any way to change the language to english?

I&#39;ve tried the tip found at http://misteratmisis.com/infotech/how-change-oracle-sql-developer-interface-japanese-english, namely adding the VM options

&lt;pre&gt;
AddVMOption -Duser.language=en
AddVMOption -Duser.country=US
&lt;/pre&gt;

to file ide.conf in directory

&lt;pre&gt;
/ide/bin
&lt;/pre&gt;

within the SQL Developer installation directory, as suggested, but that didn&#39;t help.

**Solution (edited on 13.09.2012):**

I decided to try again the solution proposed by Alex K. and this time it worked, namely adding

    AddVMOption  -Duser.language=en

to the file `sqldeveloper.conf` file located in `sqldeveloper\bin\` folder. I presume that it did work now but not before, because meanwhile I have changed my UAC (user access control) settings in Windows 7 so that I am administrator by default. What happened before was probably that even though the changes appeared to be there, the configuration file read by the program was another one (shadow copy).

**Solution for Mac OS X (added on 26.02.2016):**

Edit file at

`/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf` 

and add the line

    AddVMOption  -Duser.language=en

(Tested with SQL Developer 4.1.3.20)

How can I change the language (to english) in Oracle SQL Developer?

I wanted to print the value of a particular variable which is inside an anonymous block. I am using Oracle SQL Developer. I tried using `dbms_output.put_line`. But it is not working. The code which I am using is shown below.

    SET SERVEROUTPUT ON

    DECLARE

      CTABLE USER_OBJECTS.OBJECT_NAME%TYPE;
      CCOLUMN ALL_TAB_COLS.COLUMN_NAME%TYPE;
      V_ALL_COLS VARCHAR2(500);
  
      CURSOR CURSOR_TABLE
        IS
        SELECT OBJECT_NAME 
        FROM USER_OBJECTS 
        WHERE OBJECT_TYPE=&#39;TABLE&#39;
        AND OBJECT_NAME LIKE &#39;tb_prm_%&#39;;
      
      CURSOR CURSOR_COLUMNS (V_TABLE_NAME IN VARCHAR2)
        IS
        SELECT COLUMN_NAME
        FROM ALL_TAB_COLS
        WHERE TABLE_NAME = V_TABLE_NAME;
   
    BEGIN
    
      OPEN CURSOR_TABLE;

      LOOP
        FETCH CURSOR_TABLE INTO CTABLE;
        EXIT WHEN CURSOR_TABLE%NOTFOUND;
    
        OPEN CURSOR_COLUMNS (CTABLE);
    
        V_ALL_COLS := NULL;
    
        LOOP
          FETCH CURSOR_COLUMNS INTO CCOLUMN;
          V_ALL_COLS := V_ALL_COLS || CCOLUMN;
          IF CURSOR_COLUMNS%FOUND THEN
            V_ALL_COLS := V_ALL_COLS || &#39;, &#39;;
          ELSE
            EXIT;
          END IF;
        END LOOP;
     
        DBMS_OUTPUT.PUT_LINE(V_ALL_COLS);
    
      END LOOP;
      CLOSE CURSOR_TABLE;

    END;

And I am getting the output only as `anonymous block completed`. 


Printing the value of a variable in SQL Developer

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 Oracle SQL Developer?

Content Type	Original Author	Original Content on Stackoverflow
Question	venky80	View Question on Stackoverflow
Solution 1 - Oracle	Simon LG	View Answer on Stackoverflow

How to see if the background process is complete in SQLDEVELOPER

Oracle Problem Overview

Oracle Solutions

Solution 1 - Oracle

Why would I put code in init.py files?

How to initialize an array of objects in Java

Attributions