Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to delete a repository

user645399May 5 2010 — edited Jun 21 2010
Hi Buddies,

I created a test database in sql server and another one in oracle to test the migration.

I am connected to both through Sql Developer.

I am getting this error.
SQL Error on Script Execution
Try deleting repository before Creating Repository
I tried to delete using the menu but it just didn't work.

Please advice me on how to go about it.

Cheers!

Nith
This post has been answered by Dermot ONeill-Oracle on May 6 2010
Jump to Answer

Comments

Frank Kulash
Answer

Hi,
Whenever you have a question, please post a little sample data in a usable form (such as CREATE TABLE and INSERT statements), so the people who want to help you car re-create the problem and test their ideas. Also post the exact results you want from the given data, and an explanation (in general terms) of you get those results from that data. Always say which version of Oracle you're using (e.g. 12.2.0.1.0).
See: https://community.oracle.com/tech/apps-infra/kb/articles/4-how-to-ask-questions-in-developer-community-spaces
If col1, col2, col3, ... are NUMBER columns (or any kind of NUMBER expressions) you can find how many of them that are positive numbers like this:

CASE WHEN col1 > 0 THEN 1 ELSE 0 END +
CASE WHEN col2 > 0 THEN 1 ELSE 0 END +
CASE WHEN col3 > 0 THEN 1 ELSE 0 END ...

If all the expressions are 0 or greater (i.e. no NULLs or negative values) then you can use:

SIGN (col1) +
SIGN (col2) +
SIGN (col3) ...

You can reduce the amount of code by unpivoting the columns, but that will make the query slower. Which is more important in this case: concise code or performance?

Marked as Answer by Sainaa · Jan 27 2021
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 19 2010
Added on May 5 2010
16 comments
19,879 views