l.meher


{ City } chennai
< Country > india
* Profession *
User No # 32629
Total Questions Posted # 1
Total Answers Posted # 2

Total Answers Posted for My Questions # 1
Total Views for My Questions # 4614

Users Marked my Answers as Correct # 16
Users Marked my Answers as Wrong # 12
Questions / { l.meher }
Questions Answers Category Views Company eMail

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

 1 SQL PLSQL 4614



Answers / { l.meher }

Question { TCS, 31083 }

what is the difference between binary_integer and
pls_integer


Answer

The difference is :

PLS_INTEGER and BINARY_INTEGER have the same magnitude
range, they are not fully compatible. When a PLS_INTEGER
calculation overflows, an exception is raised. However,
when a BINARY_INTEGER calculation overflows, no exception
is raised if the result is assigned to a NUMBER variable.

Also, PLS_INTEGER operations use machine arithmetic, so
they are faster than NUMBER and BINARY_INTEGER operations,
which use library arithmetic.

In new applications, always use PLS_INTEGER for better
performance.

Is This Answer Correct ?    15 Yes 11 No

Question { 5110 }

I want to create synonym for table emp but in my pc it is
giving insufficient previliges.I am using user scott.Please
suggest me.


Answer

do login as sysdba and create the synonym.
you dont have privileges to do the same from scott user.

Is This Answer Correct ?    1 Yes 1 No