Problem Is there a more efficient way to write the following PLSQL statement? It seems inefficient to me to have […]
Tag: plsql
Oracle trigger to keep a copy of deleted records in another table
Problem I am using this trigger to keep a copy of the deleted record from table Orders_Details in table Orders_Details_Deleted. […]
Checking whether a grade combination exists
Problem Below function checks if a grade exists —————————————————————————- — CHECK IF THE VALUES WE PASSED AS PARAMETERS EXISTS AS […]
Calculate the midpoint of a polyline
Problem I have polylines in a GIS database. The polylines are stored using a user-defined type called ST_GEOMETRY. ST_GEOMETRY has […]
Highest andLowest in PLSQL
Problem I have made a procedure to display the highest and the lowest popular Items for a particular time of […]