Home » SQL & PL/SQL » SQL & PL/SQL » Basic Questions
Basic Questions [message #203371] Tue, 14 November 2006 23:02 Go to next message
venkata_sri
Messages: 3
Registered: November 2006
Location: Hyderabad
Junior Member
Hi,

Please update me on these questions:

1. How many triggers can i create on one table?

2. How many columns can i have in one table?

3. What is the maximum length of constraint name that i can have?

4. what is the maximum number of nested subquires i can have with both FROM and WHERE clause?

Regards,
Sri
Re: Basic Questions [message #203393 is a reply to message #203371] Wed, 15 November 2006 00:20 Go to previous messageGo to next message
rameshuddaraju
Messages: 69
Registered: June 2005
Location: India
Member

1. How many triggers can i create on one table?
12 triggers
They are
insert, update,delete
before,after
statement , row

2. How many columns can i have in one table?
1000 columns in 9i

3. What is the maximum length of constraint name that i can have?
30 characters

4. what is the maximum number of nested subquires i can have with both FROM and WHERE clause?
subqueries allowed upto 256.
Re: Basic Questions [message #203418 is a reply to message #203393] Wed, 15 November 2006 01:55 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
rameshuddaraju wrote on Wed, 15 November 2006 07:20
1. How many triggers can i create on one table?
12 triggers
They are
insert, update,delete
before,after
statement , row


SQL> create table faq (id number);

Table created.

SQL> create or replace trigger faq_bir1
  2  before insert on faq
  3  for each row
  4  begin
  5    null;
  6  end;
  7  /

Trigger created.

SQL> create or replace trigger faq_bir2
  2  before insert on faq
  3  for each row
  4  begin
  5    null;
  6  end;
  7  /

Trigger created.

You can have more than 1 trigger using the same triggering moments/table/conditions.

@OP: These things can all be found in the documentation. Also, if you name your post Basic Questions, then WHY post them in the Expert forum??
Previous Topic: RDBMS BASIC Concepts PDF needed urgently
Next Topic: Converting Date of Birth to Age
Goto Forum:
  


Current Time: Sat Dec 03 20:29:00 CST 2016

Total time taken to generate the page: 0.08223 seconds