Lab Sql

I just want a quick way (and preferably not using a while loop)of createing a table of every date b… Read more How To Get A Table Of Dates Between X And Y In Sql Server 2005

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

I'm having a bit confusion in using a statement like 'where 0=0' in Oracle procedures? … Read more Whats The Exact Meaning Of Having A Condition Like Where 0=0?

Can an Oracle SQL procedure return a table? I'm currently using a dbms_output to print out the … Read more Can An Sql Procedure Return A Table?

I don't necessarily need to pass the stored procedures any variables from my VBScript, I just n… Read more Simple Task: Connect To Database, Execute A Stored Procedure, Disconnect

I have a procedure and I would like that only one user could execute this procedure at same time. S… Read more Block Procedure Pl/sql With Oracle

Ive currently a procedure that deletes a customer a fairly simple procedure that's inside a pac… Read more Procedure To Delete Only If Database Higher Then Sysdate

I need to create an event inside a procedure, I read somewhere that it's possible but I don'… Read more Create An Event Inside A Procedure - Sql