dhiraj


{ City } mumbai
< Country > india
* Profession * developer
User No # 60561
Total Questions Posted # 1
Total Answers Posted # 2

Total Answers Posted for My Questions # 7
Total Views for My Questions # 11947

Users Marked my Answers as Correct # 28
Users Marked my Answers as Wrong # 6
Questions / { dhiraj }
Questions Answers Category Views Company eMail

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

Cognizant,

7 SQL PLSQL 11947



Answers / { dhiraj }

Question { TCS, 5606 }

I have a package in which a table was used in a procedure
and compiled later i have dropped the table used in the
package what would be the status of package specification
and body


Answer

Package specification remain valid package body will become
invalid

Is This Answer Correct ?    21 Yes 1 No

Question { IBM, 8978 }

why we go for package? what are the advantages of using
instead of seperate procuderes or functions


Answer

Packages are bunch of procedures and functions instead of
granting one by one procedure and function DBA can grant
packge to user.

Is This Answer Correct ?    7 Yes 5 No