Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with oracle
Search options not deleted
user 109
All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.
2
votes
2
answers
5k
views
Oracle Forms 6i on Windows 7
Given I have a system of Oracle Forms 6i (legacy software), how could I make it work on Windows 7. … We have serious problems with apps like PLUS80.exe crashing ("Oracle SQL*Plus has stopped working").
Is it possible at all? We also consider downgrading to XP if problems persist.. …
- 1,356
17
votes
Accepted
How to find the latest SQL statements within the database?
Here is the SQL to do the job. Open for trial.
Step 1: Determine the installatin IDs & user IDs.
SELECT inst_id,sid FROM gv$session WHERE username='<ENTER-USERNAME>';
Step 2:
SELECT
s.sid …
- 1,356
7
votes
2
answers
16k
views
Can I use OpenLDAP to authenticate users in Oracle?
I like to use OpenLDAP to authenticate my Oracle users. It should be possible to fetch at least the password from the directory. … There appearently is something for the Oracle LDAP servers, but would it work with OpenLDAP (plain, from i.e. Debian)? …
- 1,356
2
votes
How do you version your Oracle database changes?
We used to work with Oracle SQL Designer, which (I guess) has been replaced with SQL Developer Data Modeler now. http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html
That …
- 1,356
7
votes
1
answer
446
views
Oracle Support Tips & Tricks
How can My Oracle Support (Metalink) be used effectively?
What are your secret hints to this system? What saved you the most time? …
- 1,356
13
votes
2
answers
30k
views
ORDER BY using custom priorities for text columns
This is a sample table:
name | cat
----------
hugo | sal
bob | mgr
mike | dev
jeff | mgr
john | dev
Both name and cat being Varchar.
cat reflects a category for these names, but I like to assign …
- 1,356
21
votes
14
answers
7k
views
Comfortable sqlplus interface? [closed]
SQL*Plus is the main command line tool to operate with the Oracle Database. …
- 1,356
27
votes
4
answers
131k
views
How to find the latest SQL statements within the database?
I like to get the latest executed statements within my database, along with performance indicators.
As such, I like to know, which SQL statements were most CPU/DISK intensive.
- 1,356
7
votes
1
answer
8k
views
How can I query names using regular expressions?
(btw: this is tagged oracle, but it might be interesting in other RDBMS as well). …
- 1,356