In my table having 3000 Records. How can I delete the 500th
row? (we don't know what is data inside the table)

Answer Posted / venkata subbaiah

Delete from table where rowid=500;

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between cobol and cobol-ii?

978


What is the difference between a binary search and a sequential search what are the pertinent cobol?

962


1.Is it possible to move the data from 99.99 to 99v99? 2.What is the CICS-vsam Compilation process? 3.In My GDG 5 generation will be there GDG3 got an abend what will happen? 4.In my GDG first generation is +1 And I want to add the new generation what will happen previous generation? 5.How can you give the PIC clause below conditions A). s9 (reddy), B). s9 (5) occurs 5 times? 6.How override the proc from a particular step? and what is symbolic and override Procs?

5640


Which is not true about evaluate statement

2159


Name the divisions, which are available in a cobol program?

961


What are the different data types in cobol?

1090


Explain what you understand by passing by value.

947


What is cobol?

987


here is my requirement A1 is alphanumeric with value 'A1B2C3D4' as defined below 05 A1 PIC X(8) VALUE IS 'A1B2C3D4' but i need to have A2,A3 as ABCD & 1234 repectively...... A2 = ABCD A3 = 1234 Can you please explain me what are the different ways to do it?

7381


I have a File that has duplicate records. I need only those records that occur more than thrice.?

9332


Why would you use find and get rather than to obtain?

946


What are declaratives and what are their uses in cobol?

985


What is the difference between comp and comp-3?

942


if we display var1 then what will b displayed in below condition. 77 var1 pic s9(2) value -10. 77 var1 pic s9(2) value -11. " " " -12. " " " -13. -14 ... ... -19.

6166


What are the various section in data division and briefly explain them.

949