if i am updating one record in a table at that time no other user can't able insert ,update the record in same table How is it possible

Aditya

• Feb 28th, 2018

Lock table < table name > in exclusive mode;

Smruti R Das

• Sep 26th, 2012

GRANT SELECT ON table_name TO user_name

Answer Question  Select Best Answer

priya dharan raj

 Profile Answers by priya dharan raj Questions by priya dharan raj

• Nov 14th, 2011

Code
SELECT * FROM user_tab_columns WHERE column_id IN 
(SELECT max(column_id) FROM user_tab_columns WHERE   table_name=v_table_name)
AND table_name=v_table_name

Nitesh Srivastava TechM

• Nov 10th, 2011

See the code below

Code
SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME='EMP' 
AND column_id = (SELECT MAX(column_id) FROM USER_TAB_COLUMNS WHERE TABLE_NAME='EMP')
ORDER BY COLUMN_ID

Answer Question  Select Best Answer

rayavarapu

 Profile Answers by rayavarapu Questions by rayavarapu

• Jan 23rd, 2013

Null is not a value and not a string. It is unknown it is maximum in descending order and minimum value in ascending order.

Sandeep

• Mar 7th, 2012

Char(0)

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: answertoyourquery

• Nov 9th, 2005

---

Yes, we can use the TCL commands(commit/rollback) in the exception block of a stored procedure/function. The code in this part of the program gets executed like those in the body without any restriction. You can include any business functionality whenever a condition in main block(body of a proc/func) fails and requires a follow-thru process to terminate the execution gracefully!

Leena Roja

• Jul 13th, 2015

Correct Subhash..

Susil Kumar Nagarajan

• Jan 21st, 2012

Yes. You can very well use COMMIT or ROLLBACK in exception block. But it is not a good idea to use, as it will commit the previous transactions in the same PLSQL block. Make use of creating SAVEPOINTS and commiting them when required.

Improve Answer

 %  ROWTYPE  is to be used whenever query returns a entire row of a table or view. TYPE  rec  RECORD is to be used whenever query returns columns of differenttable or views and variables.      E.g.  TYPE  r_emp is RECORD (eno emp.empno% type,ename emp ename %type);     e_rec emp% ROWTYPE     cursor...

Nupur

• Apr 30th, 2015

This is my understanding: Declare : eno employee.emp_id%type - specifically tells you that the variable type or data that it will be holding will be same as th e employee_id type in the employee tabl...

Nupur

• Apr 24th, 2015

When we declare a var as %row type, then the variable holds all the column type attributes. Developer does not need to know what the individual column types are. Type record is used when we declare a variable to be of the records of the table. 

Answer Question  Select Best Answer