how to find out Primary Key in Oracle View

[joshibabu_are]

Hi guru's,

i have one view which is from Oracle eBS.i ran the query in sql developer and exported to excel .

and loaded in Qlikview application to find out Primary key or Composite key using Show frequency Option.

but iam unable to find the Key.

How to achieve this.

any help would be greatly appreciated.

please find  Qlik application.

Thanks,

Joshi

[sasikanth]

HI joshi,

Go to Table viewer and mouse over on table then it will show you no. of fields and no.. of keys

also if you mouse over on a field , if it is a key field then you can see tag as $key.

please find the below image for clarity

[joshibabu_are]

hi sasi thanks for your Time.

if it is joined with another table then only it will show whether its perfect key or not as per my knowledge.

but here i have only one table .

Thanks,

Joshi

[sasikanth]

Yes,

If it is single table just hover the mouse on field name.

you will find a tag  "$key" it doesn't mean that a key field.