SQL Developer can start a new tab every time you select a database object to view; but, you will have to close the tab manually.

Set this in:
_Tools-&gt;Preferences-&gt;Database-&gt;ObjectViewer-&gt;Automatically Freeze Object Viewer Windows_

You can pin a tab by clicking the button below :

![Tab pin button][1]
  [1]: http://i.stack.imgur.com/V2if9.png


----------


No need to configure anything, plus sometimes you don&#39;t want to have a tab automatically pinned.

Jeff Smith posted a nice write up on how to do this in SQL Developer.

There are multiple ways to do it.

 - Freeze content (ctrl-shift-P)
 - New Document Tab Group (will allow viewing tables simultaneously)
 - Change the preferences (If this is desired default behavior)

The post can be found [here](http://www.thatjeffsmith.com/archive/2013/05/how-to-see-two-tables-at-the-same-time-in-oracle-sql-developer/).


Which redirect rule would I use to redirect all pages under `olddomain.example` to be redirected to `newdomain.example`?

The site has a totally different structure, so I want **every page** under the old domain to be redirected to the new domain **index page**.

I thought this would do (under olddomain.example base directory):

    RewriteEngine On
    RewriteRule ^(.*)$ http://newdomain.example/ [R=301]

But if I navigate to `olddomain.example/somepage` I get redirected to `newdomain.example/somepage`. I am expecting a redirect only to `newdomain.example` without the page suffix.

How do I keep the last part out?



.htaccess redirect all pages to new domain

I have a JSON file I want to convert to a CSV file. How can I do this with Python?

I tried:
```python
import json
import csv

f = open(&#39;data.json&#39;)
data = json.load(f)
f.close()

f = open(&#39;data.csv&#39;)
csv_file = csv.writer(f)
for item in data:
    csv_file.writerow(item)

f.close()
```

However, it did not work. I am using Django and the error I received is:
```none
`file&#39; object has no attribute &#39;writerow&#39;`
```

I then tried the following:
```python
import json
import csv

f = open(&#39;data.json&#39;)
data = json.load(f)
f.close()

f = open(&#39;data.csv&#39;)
csv_file = csv.writer(f)
for item in data:
    f.writerow(item)  # ← changed

f.close()
```

I then get the error:
```none
`sequence expected`
```

Sample json file:

```json
[{
        &quot;pk&quot;: 22,
        &quot;model&quot;: &quot;auth.permission&quot;,
        &quot;fields&quot;: {
            &quot;codename&quot;: &quot;add_logentry&quot;,
            &quot;name&quot;: &quot;Can add log entry&quot;,
            &quot;content_type&quot;: 8
        }
    }, {
        &quot;pk&quot;: 23,
        &quot;model&quot;: &quot;auth.permission&quot;,
        &quot;fields&quot;: {
            &quot;codename&quot;: &quot;change_logentry&quot;,
            &quot;name&quot;: &quot;Can change log entry&quot;,
            &quot;content_type&quot;: 8
        }
    }, {
        &quot;pk&quot;: 24,
        &quot;model&quot;: &quot;auth.permission&quot;,
        &quot;fields&quot;: {
            &quot;codename&quot;: &quot;delete_logentry&quot;,
            &quot;name&quot;: &quot;Can delete log entry&quot;,
            &quot;content_type&quot;: 8
        }
    }, {
        &quot;pk&quot;: 4,
        &quot;model&quot;: &quot;auth.permission&quot;,
        &quot;fields&quot;: {
            &quot;codename&quot;: &quot;add_group&quot;,
            &quot;name&quot;: &quot;Can add group&quot;,
            &quot;content_type&quot;: 2
        }
    }, {
        &quot;pk&quot;: 10,
        &quot;model&quot;: &quot;auth.permission&quot;,
        &quot;fields&quot;: {
            &quot;codename&quot;: &quot;add_message&quot;,
            &quot;name&quot;: &quot;Can add message&quot;,
            &quot;content_type&quot;: 4
        }
    }
]
```


How can I convert JSON to CSV?

In **Oracle SQL Developer**, one can list the data in a table using the Data tab when viewing a table. there where can add, delete, edit or just viewing records of table currently viewd

the problem is that we often really need to view more than one table at once, then we need more than one tab opened, thing that i dont know how to do that, any sugestion. tq in advance

Oracle SQL Developer multiple table views

In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. there where can add, delete, edit or just viewing records of table currently viewd
the problem is that we often really need to view more than one table at once, then we need more than one tab opened, thing that i dont know how to do that, any sugestion. tq in advance

I have always only used MySQL and no other database system.

A question came up at a company meeting today and I was embarrassed I did not know:
To a developer, what earth-shaking functionality do MS or Oracle offer that MySQL lacks and which allows MS and Oracle to charge for their systems?

MySQL vs. SQL Server vs. Oracle

We have a large Oracle database with many tables.  Is there a way I can query or search to find if there are any tables with certain column names?

IE show me all tables that have the columns: `id, fname, lname, address`

Detail I forgot to add: I need to be able to search through different schemas.  The one I must use to connect doesn&#39;t own the tables I need to search through.

Search an Oracle database for tables with specific column names?

I am using the following SQL query and the `ExecuteScalar()` method to fetch data from an Oracle database:

    sql = &quot;select username from usermst where userid=2&quot;
    string getusername = command.ExecuteScalar();

It is showing me this error message:

&gt;*System.NullReferenceException: Object reference not set to an instance of an object*

This error occurs when there is no row in the database table for `userid=2`.&lt;br/&gt;
How should I handle this situation?

Handling ExecuteScalar() when no results are returned

I am evaluating [Oracle SQL Developer][1].

My `tnsnames.ora` is populated, and a `tnsping` to a connection defined in `tnsnames.ora` works fine. Still, SQL Developer does not display any connections.

[Oracle SQL Developer Soars ][2] mentions, that if
&gt; you have Oracle client software and a tnsnames.ora file already installed on your machine, Oracle SQL Developer will automatically populate the Connections navigator from the net service names defined in tnsnames.ora.

I also tried to set my `TNS_ADMIN` environment variable, but after restarting SQL Developer there are still no connections displayed.

Any ideas?&lt;br&gt;
Anyone successfully working with SQL Developer and tnsnames.ora?

  [1]: http://www.oracle.com/technology/products/database/sql_developer/index.html
  [2]: http://www.oracle.com/technology/oramag/oracle/06-may/o36sql.html

Use tnsnames.ora in Oracle SQL Developer

I tried to create a foreign key on one of my tables, referencing a column of a table in a different schema.

Something like that:

    ALTER TABLE my_schema.my_table ADD (
      CONSTRAINT my_fk
        FOREIGN KEY (my_id)
        REFERENCES other_schema.other_table(other_id)
    )

Since I had the necessary grants, this worked fine.

Now I wonder if there are reasons for not referencing tables in a different schema, or anything to be careful about?

Foreign key reference to table in another schema

When I try to execute this statement in Oracle SQL Developer 2.1 a dialog box *&quot;Enter Substitution Variable&quot;* pops up asking for a replacement value for *TOBAGO*,

    update t set country = &#39;Trinidad and Tobago&#39; where country = &#39;trinidad &amp; tobago&#39;;

How can I avoid this without resorting to `chr(38)` or `u&#39;trinidad \0026 tobago&#39;` which both obscure the purpose of the statement?

How to avoid variable substitution in Oracle SQL Developer

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?

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? 

Content Type	Original Author	Original Content on Stackoverflow
Question	user232627	View Question on Stackoverflow
Solution 1 - Oracle	a70m	View Answer on Stackoverflow
Solution 2 - Oracle	Jerome Dalbert	View Answer on Stackoverflow
Solution 3 - Oracle	Nathan	View Answer on Stackoverflow

Oracle SQL Developer multiple table views

Oracle Problem Overview

Oracle Solutions

Solution 1 - Oracle

Solution 2 - Oracle

Solution 3 - Oracle

How can I convert JSON to CSV?

.htaccess redirect all pages to new domain

Attributions