Loading...

Follow Reddit - Oracle on Feedspot

Continue with Google
Continue with Facebook
or

Valid
Reddit - Oracle by /u/rhetoricaljargon - 1d ago

I'm coming from the world of Microsoft SQL, and I'm slowly transitioning into Oracle at my current job.

So from my googling, it seems like Oracle has Index-Organized-Tables, which provides the same conceptual mechanism as Clustered Indexes. Does Oracle also have regular indexes (non-clustered)?

submitted by /u/RhetoricalJargon
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Is there anyway to enable Partner CTI service such that my media toolbar will work for a user that has the the privilege to view the toolbar https://docs.oracle.com/en/cloud/saas/engagement/19b/faiec/configuring-computer-telephony-integration-cti.html#FAIEC2094235 Thanks!!

submitted by /u/quinn50
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Reddit - Oracle by /u/jshell73 - 4d ago

Has anyone gone through and had to become CIS compliant? I can come up with scripts for a lot of it but some of it might be painful, like removing public access to all the packages. I did some playing around and things like DBSNMP get access to the packages through that public role. I was curious if anyone knew of the specific packages that DBSNMP needed execute on? All of them? Or just a handful?

I assume someone out there has had to do this. I did some googling and figured that a majority of it had to be out there somewhere.

Thanks for any help!

submitted by /u/jshell73
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

For example, if I have data that looks like this:

Region State Population
West AZ 100
West CA 60
West NV 45
South MS 30
South GA 75

Is there a way to make it Apex show the output as:

Region State Population
West AZ 100
West CA 60
West NV 45
States 3
South MS 30
South GA 75
States 2

Thank you all!

submitted by /u/AbettoCliniku
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Reddit - Oracle by /u/y0d4a - 1w ago

HI, is it possible to audit user activity (specific: add/remove user roles) on oracle database in real time without enable "DBA_AUDIT_TRAIL" ?

submitted by /u/y0d4a
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

I've just started development on a new Oracle Mobile Hub web service. I come from a Microsoft Web API background.

From within an Oracle Mobile Hub node.js Custom API I need to connect to an Oracle DB system instance (Basic authentication: username, password, public ip address, port, sid). Is it possible to use the node-oracledb add-on from within a Custom API? Is this the best way to directly connect to a remote Oracle db or is there a better mechanism from with Mobile Hub?

Thanks in advance for any info.

submitted by /u/bc_uk
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Trying to solve an ongoing issue for one of my co-workers who is currently using Smartview vers.720 on Win10. To my knowledge, they are the only one that has an issue refreshing certain templates which my team has been using for years. They can refresh ad hoc files and a few other templates as normal.

I'm hoping to solve the reason behind their issue in the event that I end up being migrated to vers.720 in the future. A handful of us in the office are still on Win7 and still using vers.600. Our IT support has been little help to us.

Basically, whenever they do a refresh, it scrambles the member names so the data doesn't refresh properly.

I found this KB on the Oracle website, but I don't have an account and due to working at a large company, I can't necessarily figure out who my CUA is to grant me access to Oracle Support.

Smartview: v11.1.2.5.720: Refresh Overwriting Excel Formulas Used for Member Names

If anyone could pass along the details within the KB or know what the solution is for this issue, I would be really grateful! Thanks!

submitted by /u/orenjisoda
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Is it just me or is there something wrong with this picture? :)

PS sorry about the title, if I had a dollar for every time I typed in oralce instead of oracle I would be a rich man.

https://i.redd.it/ra7al5nvr6231.png

submitted by /u/jacquesrk
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Read Full Article

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview