Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Category: Oracle
How does Oracle know who I am?
Question : Slightly unimportant but it’s piqued my curiousity. I’ve just logged into an Oracle 10g database for the first […]
Postgresql 9.6 db connection our Oracle 11.2.0.4. db
Question : I am trying to do a connection between tables/fields between our Postgresql database and an Oracle database. When […]
What’s the difference between a v$ view and its dba_ equivalent?
Question : What’s the general difference between a v$ view and its dba_ equivalent? Take, for example, v$tablespace and dba_tablespaces. […]
jdbc connection string ORACLE , integrated security
Question : we are trying to configure Spotfire to use JDBC connection to ORACLE. We would like it to use […]
Oracle table and number of blocks
Question : What is the easiest way of finding out the number of blocks a table (oracle) occupies and the […]
Error when installing JServer JVM in Oracle XE on Linux AMI
Question : I’m trying to install OJVM on Oracle 11g (11.2.0.2.0) on Amazon Linux AMI (20016.09). And I’m getting the […]
Best practices for service name / aliases in tnsnames
Question : I have this idea that service names / aliases given to connections descriptors in a tnsnames.ora (not the […]
Trigger that records values for 5 columns from 3 tables when a value for column Z in table 3 is of a certain value
Question : I am new to triggers and SQL in general. Sorry in advance if this forum is only for […]
Are there any benefits in certain ordering of columns when defining indexes
Question : For example, if I have two indexes: CREATE INDEX IDX_1 ON MY_TABLE_1 (ITEM, DATE, LOCATION) COMPUTE STATISTICS; CREATE […]