Question : We’ve implemented paging in our PL/SQL procedures by building a dynamic SQL query and then selection only a […]
Tag: plsql
How can i select columns from two tables using REF
Question : I’m new to Oracle’s PL/SQL i’m using 11g. I have 2 Type Objects each one of them with […]
Oracle PLSQL code recovery
Question : I cannot connect to my database as admin, even using connect descriptor neither via RMAN. I am getting […]
Selecting from random amount of tables with identical structure
Question : I am programming along the lines of an unfavorable design. I have no influence on the schema because […]
How to differentiate between SQL and PL/SQL?
Question : I know the question might sound too stupid, but I never understood this part. SQL*Plus works with both […]
Determine if a resultset exists quickly
Question : I want to determine if a resultset exists very quickly. At the moment, I’m doing a count – […]
Best way to use insert statement on Oracle [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
How can i select columns from two tables using REF
Question : I’m new to Oracle’s PL/SQL i’m using 11g. I have 2 Type Objects each one of them with […]
Pl/SQL web application
Question : I have a PL/SQL web application,got the entire DB dump from remote DB. Its very old application, running […]
Combine multiple queries into single query
Question : I am trying to run the following query: SELECT Freight.Freight_No, Freight.Available, Locomotive.Loco_No, Locomotive.Available, Driver.Driver_No, Driver.Name, Driver.Available FROM Freight,Locomotive, […]