Skip to Main Content

Java Development Tools

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 activate quickDoc in JDeveloper (12.2.1.0)?

Mehdi EsteghamatianApr 6 2017 — edited Apr 9 2017

hi All,

It may sound a little bit stupid but I don't know how I can activate quickDoc/ Completion Inside (Ctrl+space / Ctrl+D) in my jdeveloper (JDev 12.2.1.0)

I get the below error messages if I try them. Might installing JDeveloper extension help?

Any clue is much appreciate it.

Jake

pastedImage_0.png

pastedImage_2.png

This post has been answered by Timo Hahn on Apr 6 2017
Jump to Answer

Comments

unknown-7404

What problem are you trying to solve?


You can use the ALL_IND_COLS view to get info about TABLE_NAME, COLUMN_NAME, COLUMN_POSITION, etc

http://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_1090.htm

>

ALL_IND_COLUMNS

ALL_IND_COLUMNS describes the columns of indexes on all tables accessible to the current user.

>

1028309

I am new in oracle and like to write to query to compare two index columns and columns order. I have no idea have to do that???

unknown-7404

e27d74c6-5fff-404b-9698-78029354fb67 wrote:

I am new in oracle and like to write to query to compare two index columns and columns order. I have no idea have to do that???

What problem are you trying to solve? What do you plan to do with the information when you have it?

And why are you the one trying to solve it if you have no experience in SQL?

1028309

I like to run this query and depends on this query result I like to do some programming in my C# application. If I would get the query result like yes or no, it would be enough for me to use it in my C# code.

1028309

I used but not worked

select

   table_name,

   index_name,

   column_name

from

   dba_ind_columns

where

   table_owner='XXXX'

order by

   table_name,

   column_position


minus


select

   table_name,

   index_name,

   column_name

from

   dba_ind_columns

where

   table_owner='XXXX'

order by

   table_name,

   column_position


unknown-7404

All you are saying is 'I want to do something based on the result'.

Well, DOH! It's obvious you want to do 'something'. I've never needed to compare indexes like that in over 25 years of SQL.

Since it is clear you don't want to tell us WHAT PROBLEM you have and why you need to do this you'll need to wait for someone else to try to help you.

1028309

you don't need to shout out "WHAT PROBLEM" please!.  I already know that you voluntarily helping me out.  Obviously I need it for something...But Instead of learning why I need it isn't be nice to help. Thanks anyway.

Umesh P

As per your explanation it seems that you want to compare data for two indexes,if all the records for two index matches or not .

Using simple sql query it seems tedious, your index are not of on identical schema. One index made up of composite keys other is not.

One scenario of comparison possible is when one out of two columns in composite key index is empty.

At the same time there could be index with more than two columns as you have shown above.

Index are nothing but set of columns . So comparison will be possible if all index have similar schema.

Etbin

Maybe (if column names might be different)

select *

  from (select t.owner,t.table_name,i.index_name,i.column_name,i.column_position,

               i.descend,t.data_type,t.data_length,t.data_precision,t.data_scale,t.nullable

          from all_ind_columns i,

               all_tab_columns t

         where t.table_name = 'STUDENT_A'

           and t.table_name = i.table_name

           and t.owner = i.table_owner

           and t.column_name = i.column_name

       ) a

       full outer join

       (select t.owner,t.table_name,i.index_name,i.column_name,i.column_position,

               i.descend,t.data_type,t.data_length,t.data_precision,t.data_scale,t.nullable

          from all_ind_columns i,

               all_tab_columns t

         where t.table_name = 'STUDENT_B'

           and t.table_name = i.table_name

           and t.owner = i.table_owner

           and t.column_name = i.column_name

       ) b

    on a.column_position = b.column_position

   and a.data_type = b.data_type

   and a.data_length = b.data_length

   and lnnvl(a.data_precision != b.data_precision)

   and lnnvl(a.data_scale != b.data_scale)

   and a.nullable = b.nullable

   and a.descend = b.descend

Regards

Etbin

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 7 2017
Added on Apr 6 2017
7 comments
218 views