All Questions
11 questions
0
votes
1
answer
102
views
2
votes
3
answers
612
views
Calculate the midpoint of a polyline
I have polylines in a GIS database. The polylines are stored using a user-defined type called ST_GEOMETRY.
ST_GEOMETRY has lots of spatial functions. However, it does not have a polyline midpoint ...
- 218
2
votes
1
answer
138
views
Seek to get acceptable performance of SQL request (SOLVED)
Goal: I want to output all non-standard FK constraints from clients DB, versus our "standard" DB (which contains, by default, 2,631 FK).
Trial: I wrote this code:
...
- 169
0
votes
2
answers
141
views
SQL Statement with a Select Statement Inside a Where Clause
Is there a more efficient way to write the following PLSQL statement? It seems inefficient to me to have the SQL statement nested inside the where clause.
...
- 344
1
vote
1
answer
4k
views
Oracle trigger to keep a copy of deleted records in another table
I am using this trigger to keep a copy of the deleted record from table Orders_Details in table Orders_Details_Deleted.
I am ...
- 23
4
votes
1
answer
144
views
Highest andLowest in PLSQL
I have made a procedure to display the highest and the lowest popular Items for a particular time of a given date. The procedure works with no errors or exceptions ...
- 43
1
vote
2
answers
138
views
2
votes
1
answer
860
views
Oracle query to split 1 row into two where conditions are applicable
The scenario question:
"I'm having difficulties with splitting a single row into two individual ones."
My test schema is:
...
- 205
3
votes
2
answers
184
views
Searching through tables for a value
I have a PL/SQL stored procedure which searches for a row in 3 different tables (not all columns are the same).
The logic goes as follows:
...
- 175
5
votes
2
answers
327
views
Query for building a view
I am currently trying to improve on a query that is being used to build a view. The query is in PL/SQL, in an Oracle database. There are 3 different types of reports (100,200, and 300) that are ...
- 151
3
votes
2
answers
1k
views
Oracle PL/SQL decryption function breaking index?
I have a package called pkg_crypto.
My select looks like this:
...
user10103