Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to know that the data block is empty? 1

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
How to know that the data block is empty?

The block status cab be NEW, CHANGED or INSERT. how about if use deletes all record from the data block, how can I know the blcok is empty?
 
Sort by date Sort by votes
Navigate to the first record and if :block.ROWID is null then the block is empty.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

faizsaadq
  • Locked
  • Question
How to call crystal reports XI from Oracle Forms 10G
Replies
1
Views
154
oradba101
oradba101
deeptic
  • Locked
  • Question
Displaying Date & Time when the form is run
Replies
1
Views
110
sem
sem
puma51
  • Locked
  • Question
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
Replies
1
Views
172
BJCooperIT
BJCooperIT
meridian99
  • Locked
  • Question
what record is the cursor on
Replies
1
Views
87
BJCooperIT
BJCooperIT
GROKING
  • Locked
  • Question
Package that executes two Stored Procedures
Replies
1
Views
71
lewisp
lewisp

Part and Inventory Search

Sponsor

Back
Top