RE: Query

"Tony Andrews" <[email protected]> Wed, 19 Feb 2003 10:53:12

Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-880236-2003.02.19-10.37.16--gcdod-oracle#[email protected]>

> 1. Can u tell me the maxm no of columns that can be included in
index....is it 32??

Yes, 32 in a regular index, 30 in a bitmap index.  But don't worry, you 
should never be wanting to have that many in one index - if you did, I 
would seriously doubt your database design.  I think the most I have ever 
used in 13 years is about 6.

> 2. which package is used for debugging of procedures, triggers and
functions.....(dbms_output or dbms_describe or dbms_SQL or
dbms_transaction or ????)

DBMS_OUTPUT.PUT_LINE is the simple routine for adding debug messages to 
your code.  It only works if you run your code from SQL Plus and you SET 
SERVEROUTPUT ON before running the program.
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].