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.
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
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
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
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
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
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
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
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
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