Tagged Questions
3
votes
1answer
73 views
Index on foreign key makes query extremely slow
We are recently experiencing a tremendous query slowdown with spilled over temp tablespace. A specific query causes this problem.
The queried table (table3) has an indexed PK, three FK with indexes ...
2
votes
0answers
215 views
Help with SELECT queries
I need help with some queries. I struggled do find out how to do it, but I think I finally caught on or at least got the results I was looking for in the database.
These are the tables (given by my ...
0
votes
1answer
159 views
Select fields from multiple tables
I want to make a query a little complicated, and I'm not able to do it alone.
I have the following tables:
Table color:
id_uo P
id_cor PF
id_area F
text_cor
Table area:
id_area P
...
8
votes
3answers
772 views
Why do I have to select from the dual table?
This works in the major Relation Database Management Systems most likely to appear on StackOverflow/dba.stackexchange, being SQL Server, MySQL, PostgreSQL and SQLite (WebSQL).
select 'abc' abc, 1 ...
2
votes
1answer
650 views
Oracle error “too many values”, must be solved with nested SELECTs
I have hit upon a "too many values" error in Oracle, when working with some intricate nested SELECTs.
A simplified description of my problem, on a toy problem describing the hierarchy in a company. ...
2
votes
1answer
581 views
Simple Oracle query hangs depending on WHERE clause
Not used to using Oracle, but we have a large database where a non-unique query like
SELECT * FROM employees where department = 'HR'
is working, results list up no problem.
But when I do
...
0
votes
3answers
347 views
Can a RDBMS connect to a remote server, execute a select query and copy them into a local table just with SQL commands?
I'm sorry it may sound stupid but I've been wondering about how multiple databases are automated before the virtualization era. Can a DB Adminsitrator make a stored procedure to get data from a remote ...
8
votes
2answers
22k views
oracle - list users with access to certain tables
I'm sure this has been asked before but I can't seem to find the relevant details for the following.
Is there some sort of pre-built table that can do the following (I have used dba_tab_privs but it ...
7
votes
3answers
2k views
What does the term “projection” refer to in an SQL query (or view definition)
In Oracle's document The Query Optimizer, under View Merging, I found the following information
The view merging optimization applies to views that contain only
selections, projections, and ...
5
votes
4answers
547 views
Multiple operations using WITH
Is there a way to execute multiple operations using the WITH statement?
Something like
WITH T AS
(
SELECT * FROM Tbl
)
BEGIN
OPEN P_OUTCURSOR FOR
SELECT * FROM T;
SELECT COUNT(*) INTO ...
0
votes
3answers
145 views
How can I select data and the total to cursors?
I have a table like this:
ID | Name
------------
1 | AA
2 | AA
3 | AA
4 | BB
I want to select all rows where Name like 'AA' in a cursor and get the count from this result in another ...
