Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Probably not the answer youre looking for but I would seriously question the wisdom of having a mobile device connect directly to oracle, or any dbms.</p> <p>Instead, consider putting a REST or SOAP service in front of your dbms and let your mobile apps connect to that.</p> <p>Some of the benefits include:</p> <ul> <li>When your dbms or dbms drivers change versions, you only have to update your service...not potentially lots of mobile devices.</li> <li>You dont have the credentials to your dbms on a mobile device which potentially gets lost or otherwise ends up in hostile environment where someone can try to brute force whatever way youve attempted to secure the credentials.</li> <li>Your service can support lots of different kinds of clients/mobile devices without having to worry about finding an oracle driver for that device, say iOS, for example.</li> <li>You can more gracefully handle service outage / planned downtime via the service...announcing unavailability or alternatives via service responses, rather than just not being able to get a connection which could be indistinguishable from bad network connections.</li> <li>You'll have a wealth of options for augmenting the service with various caching options, validations, and applying finer grained or context specific authorization than what you might want to implement in oracle. -</li> </ul> <p>Perhaps you really have some hard requirement to connect directly but I think that would be a rare and very specific requirement. The much more common practice seems to be to buffer the connection with a service layer that gives you much more flexibility, IMHO.</p> <p>Good luck.</p>
    singulars
    1. This table or related slice is empty.
    1. POandroid odbc connection for oracle 10g
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USmmeyer
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1, a very useful tips on benefits of using service instead of directly connecting to oracle.
      singulars
      1. PO
      1. USNaved
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload