Recent content by shantanu

I have select priveledge (actually logging in as SYSDBA), because I can right click on the table and click on Edit Data or View Data to view all the data in the table. Thanks Shantanu

-- Create table create table ARIES.ML_TABLE ( TABLE_ID NUMBER(5) not null, TABLE_NAME VARCHAR2(30) not null, TABLE_DESCRIPTION VARCHAR2(4000) ) tablespace A_FARAD_MARS_DATA_AND_INDEXES pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1...

That did it. It is working now. Thanks a lot for your help.

Hi, I am using the Query Builder and when I drag a table from the browser (left window) on to the drawing pane, it draws the table, but only display 2 columns in it, and they are 1. * 2. rowid Is there something extra I need to do. I check the docs but could not find anything. Thanks for the...

The hello world procedure takes in a parameter i.e. the name of the person and the does screen output of Hello... with the person name. Here is the code: create or replace procedure Hello_World( pi_name in varchar2 ) IS lv_message varchar2(60); BEGIN lv_message := 'Hello World! How are you '...

I have created the stored procdure, so I am hoping that I should be the owner. Note: I am new to Oracle, primarly being working on SQL Server. Thanks SN

Hi, I am trying to debug a PLSQL procedure (say Hello_World) and I start the debugging by calling a test script which calls this procedure (Hello_World). When I try to debug the test script and click on Step Into, it does not step in to the Hello_World procedure, but simply executes it. What am...