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
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
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 Search options user 119155

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.

1
vote
2answers
In our system relationships between tables are often (but not always) defined in the application code rather than the database (annoying I know). There's a naming convention which outlines any soft (a …
asked Jun 13 '17 by Michael Oddie
1
vote
This is how I solved it in the end. I made a view called pk_v with the OWNER, TABLE_NAME, COLUMN_NAME and DATA_PRECISION and then joined it with the DBA_TAB_COLUMNS view and compared them. SELECT t …
answered Jun 15 '17 by Michael Oddie
1
vote
1answer
Is there any downside to creating a index on a already populated date field? Will the new index perform the same as it would if it was created when the table was? Would it be costly from a database …
asked Apr 4 '17 by Michael Oddie
1
vote
3answers
I haven't got a particular problem here, I'm just interested. One of my associates uses COUNT(DISTINCT(PRIMARY_KEY)) every time he needs to select all the data from a table (with 100m + rows) is it an …
asked Mar 24 '17 by Michael Oddie
1
vote
1answer
I'm writing a script to check SQL against a standards document before it's implemented. I'm currently trying to write a script that compares the Primary and Foreign key's data type and precision. I kn …
asked Mar 31 '17 by Michael Oddie
0
votes
The replace function will find a character in a string and replace it. Use: REPLACE(str, find_string, replace_with) in your case: where UPPER(REPLACE(city, 'Ì', 'I') like 'UPPER()%' Hope this helps …
answered Apr 5 '17 by Michael Oddie
0
votes
1answer
The issue I'm having is I have a block of dynamic SQL that I can't get the results from. Here's the SQL: CREATE OR REPLACE PROCEDURE GGCHECKER IS cursor c1 is SELECT TABLE_NAME, TABLE …
asked Oct 9 '17 by Michael Oddie
0
votes
I've found a solution but it's probably not the best way of doing it. CREATE OR REPLACE PROCEDURE GGCHECKER IS cursor c1 is SELECT TABLE_NAME, TABLE_OWNER, PERCENTAGE_CHECK, LAST_UPDAT …
answered Oct 10 '17 by Michael Oddie