1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

i have a table with column sno with 30 records. i want to
update this column by item by item in asp.net. i wantto
enter new values into that from 1 to 30 how is it possible
with backend c#

Question Posted / satyagopi


i have a table with column sno with 30 records. i want to update this column by item by item in as..

Answer / guest

This will be possible by writing an updatable cursor, as
cursor does row by row manipulatio in table records.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is scalar data type in pl sql?

0 Answers  

Can we use distinct and group by together?

0 Answers  

Show code of a cursor for loop.

0 Answers  

How many aggregate functions are available there in sql?

0 Answers  

What is sql in java?

0 Answers  




what is explain plan?

4 Answers  

What is the life of an sql statement?

0 Answers  

How can I see all tables in sql?

0 Answers  

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

How does sql store data?

0 Answers  

How do I truncate a word?

0 Answers  

Can a table contain multiple primary key’s?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories