Help Transact-SQL -->PL/SQL porting

From: Dmitry Babitsky <dimitry_at_ix.netcom.com>
Date: 1997/07/16
Message-ID: <01bc922e$9f391340$81ccb7c7@dmitry40e>#1/1

Hi,
I am an expert Transact-SQL programmer(Microsoft), but have only limited experience with PL/SQL. So, just a few questions: 1) In T/SQL I create temp. tables in my stored procedure(#table_name), then

query    	them. How do I do the same in PL/SQL?  Looks like PL/SQL tables
is not what 	I want, 	because you cannot use SQL to query them.

2) Is there an equivalent of tempdb? Can temporary tablespace be used for that?

3) In T/SQL I can do this:

	CREATE PROCEDURE xyz
	AS
		SELECT * FROM TABLE

  Looks like you cannot do the same in PL/SQL? What's the equivalent?

Thank you for any help.

Dmitry Babitsky. MCSE, MCSD

dimitry_at_ix.netcom.com Received on Wed Jul 16 1997 - 00:00:00 CDT