Explain locks? : Transact sql


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

what is the different between unique+not null & primary key,

4 Answers  


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  


Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,


Can variables be used in sql statements?

0 Answers  


What is the difference between microsoft sql and mysql?

0 Answers  


table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,


how to enter characters as hex numbers? : Sql dba

0 Answers  


Is pl sql and postgresql same?

0 Answers  


How to use distinct and count in sql query? Explain

0 Answers  


Why is pl sql needed?

0 Answers  


What is a mutating table

5 Answers   TCS, Tech Mahindra,


How to call shell script from pl sql procedure?

0 Answers  


Categories