SQLPlus commands

[pwdmarshall]

Hi SQLPlus Gurus,

We're using Pro/I 3.3 M022, the server is Win2K.
I'm working with a Pro/Intralink Toolit app developed by someone else.


Quick question:
Can anyone tell me what sql commands I can use to find out the names of
attributes in Pro/Intralink?


More detail:
We have a Pro/E parameter Description, which seems to clash with the
Pro/Intralink default parameter Description. As a result, Pro/Intralink
seems to have created another attribute called Description* (see
screenshot).
If I use 'piv_desc' or 'description' the Pro/I Toolkit app returns the
values for the Intralink default description. If I use 'description*' the
search fails completely; so I want to use the name for 'description*' as
it's referred to in the Oracle table.


Thanks in advance,
Paul

This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

[brianadkins]

For browsing your Intralink Oracle tables, I recommend a free tool
called "FreeTOAD"

[unknown1]

Hello

I am no sql or intralink guru, but I have a little to add.

By the way, thanks for the toad link, I will use it once I get
back to work...ha..ha

My add is: I wrote a java gui to query oracle &/or Intralink.

http://www.datajett.com/Java/DbJettJT/

No, I'm not a java guru either. I just try to make all work.

It has a few drop-downs for sql to:

few oracle tuning/monitoring
intralink queries

It could be a good start. No commits, just queries, so it should
not be dangerous for a beginner (which I am still).

IN the above shown folder on my web site, you can use the jar,
complie the java & go form there.

You just enter/modify the URL string:

jdbc:oracle:thin:@Host_Name:1521:ilnk

with your host-name:port:SID.

All this info can be obtained from your tnsnames.ora (usually
located ion your .proi folder or near there).

Then enter user name & pass word (system/manager usually works).

Then select from drop downs: