Skip to content Skip to sidebar Skip to footer
Showing posts with the label Plsql

Using A Trigger In Oracle To Log Changes To A Table

I have a project for one of my classes. We need to create a log when two of our tables have changes… Read more Using A Trigger In Oracle To Log Changes To A Table

Looking Null Values For Different Oracle Type

I'm doing collection of two columns(col & val). Into second select col is parameter of othe… Read more Looking Null Values For Different Oracle Type

Executing A Dynamic Sql Statement Into A Sys_refcursor

is it possible to execute a dynamic piece of sql within plsql and return the results into a sys_ref… Read more Executing A Dynamic Sql Statement Into A Sys_refcursor

Problem With Execute Procedure In Pl/sql Developer

I this is my first attempt to create procedure and execute it. First I create simple table. DB sche… Read more Problem With Execute Procedure In Pl/sql Developer