Oracle update and change few columns records in two tables with a single query

I have two tables with names of Locations and Countries in My Oracle database. Locations table has columns with names location_id(fk), street_address, state_province, and country_id. Countries table …

Oracle PL/SQL: how to execute a procedure with a varray as out parameter?

I’m writing a stored procedure that will receive a code and return one or more VARCHAR2 values. The number of values will vary according to the code the procedure receives. I don’t know if this is …

SP2-0552: Bind Variable “NEW” is not declared

I am trying to learn pl/sql triggers. I am trying to create a simple trigger by tracking tutorial http://www.tutorialspoint.com/plsql/plsql_triggers.htm but I got below error. I searched on the …

Connect to External WebDAV with PL/SQL

Does anyone have resources/advice on how to connect to a third party WebDAV with PL/SQL? I will be placing a file onto their server and retrieving a log file. Is it as simple as using UTL_HTTP & ‘…

Oracle case inside where clause

This is a simple question, I’ve read some details about using CASE in WHERE clause, but couldn’t able to make a clear idea how to use it. The below is my sample query: 1 SELECT * FROM dual 2 …

ORA-00054 Resource busy when dropping table

Can somebody explain this error? ORA-00054: Resource busy and aquire with NOWAIT specified This error came in a DROP TABLE. Because of it, procedures and packages are not getting compiled.

How can I select records ONLY from yesterday?

I’ve spent hours searching the web for an answer to this question… Here’s what I currently have: select * from order_header oh where tran_date = sysdate-1