Objects in db

[Geek_Guest]

1) How many DB can be created in a machine
2) How many column can be used in a Select Statement
3) How many tables that can be joined in a select statement
4) How many SUB QUERY that can be written in a session
5) How many column can we have in a Table
6) What is the Max size of Procedure
7) How many parameter you can pass in a procedure
8) How many Objects you can create in DB

Question asked by visitor Viji

[debasisdas]

Dear you badly need to go through some oracle books for answer of all the above question.

[mahendran]

1) How many DB can be created in a machine
Ans: There is no particular limit for DB in a machine but it depends on the size of RAM and size of the DB.
2) How many column can be used in a Select Statement
3) How many tables that can be joined in a select statement
4) How many SUB QUERY that can be written in a session
5) How many column can we have in a Table
6) What is the Max size of Procedure
7) How many parameter you can pass in a procedure
8) How many Objects you can create in DB
Ans:There is no limit for objects. You can create n number of objects in DB

Question asked by visitor Viji[/QUOTE]

[susarlasireesha]

To get some answers to ur questions, follow this link