Re: OracleXE.....Help!!!!!
Date: 10 May 2006 06:06:29 -0700
Message-ID: <1147266388.946927.115160_at_v46g2000cwv.googlegroups.com>
Wallace wrote:
> Hai All,
>
> I am new to Oracle.
> I am using OracleXE and Oracle SQL Developer....
> I need a simple stored procedure for the following query
> SELECT * FROM Table1 with proper syntax and also tell how to
> execute it and view the results...
> Looking forward for the response...
> Thanx in advance...
This should get you started...
1 create or replace procedure count_tab as
2 numrows number;
3 begin
4 select count(*) into numrows from user_objects;
5 dbms_output.put_line('Number of rows is '||numrows);
6* end;
SQL> /
Procedure created.
SQL> set serveroutput on
SQL> exec count_tab;
Number of rows is 1
PL/SQL procedure successfully completed.
HTH --g Received on Wed May 10 2006 - 15:06:29 CEST