Interested to Buy Any Domain ? << Click Here >> for more details...
Write one update command to update seqno field of a table
on the basis of row number.
- 4 Answers
- 17521 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rk
update emp_test a set empno=7469 where (select empno from
(select rownum r,empno from emp_test) where r=6 )=a.empno
use seqno in place of empno
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How do I find duplicates in the same column?
how to load data files into tables with 'mysqlimport'? : Sql dba
What are the topics in pl sql?
Can you skip header records while loading? : aql loader
Explain sql data types?
Can we use threading in pl/sql?
What is procedure explain with program?
What are database links used for?
Where is sql database stored?
Which data dictionary views have the information on the triggers that are available in the database?
What is difference between ms sql and mysql?
what is the command line end user interface - mysql? : Sql dba
What is user defined functions?
