Skip to Main Content
Forums

Data Science & Machine Learning

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to check version of ORE installed in the Oracle database

Kevin ZhangSep 14 2017 — edited Sep 20 2017

Hi All:

I am using Oracle BigDataLite VM4.7 and the VM is already has Oracle R Enterprise (ORE) installed in the database 12c packaged with this VM.

My question is: what command I can run (either in database or R) to tell me the version of the ORE that has been installed?

I am looking for a systematic way to confirm/check the version of the ORE.

Thanks!

Kevin
This post has been answered by rtiran on Sep 15 2017
Jump to Answer

Comments

Arpad Kiss

I think you wanted DESC, not DEPT.
DESC tablename;

Pictures are worth many words, show us

image.png

user527460

Hi, @thatjeffsmith-oracle ,
Here is the picture from SQL Developer version 21.4.3.x,
Picklist is not showing with table alias 'a' as shown here.

image.png

That query to get the column list might take a half-second, be patient
Windows 10/21.4.3
image.png

user527460

hi @thatjeffsmith-oracle ,
No luck, i waited for a min but pick list not showing. I tried to change theme to dark as showing in your image, still no pick list pops up.

ask for it multiple times, if the query takes too long, we give up

Robert Kilmer

Try Ctrl-Space.

670554

Ctrl-Space is not working in Version 22.2.1.234

it brings up a different menu.

thatJeffSmith-Oracle

23.1.1 is latest and this is your example in 23.1.1

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

Post Details

Locked on Oct 18 2017
Added on Sep 14 2017
#r-technologies
4 comments
3,881 views