hi
u will get four records in the output
Type: Posts; User: sqlquiz82; Keyword(s):
hi
u will get four records in the output
the promblem may be with the table
i think it would have been locked
to check that just select the table and see
if it is not giving the rows then the table is locked
ask the dba's to...
Truncate
this command will removes the data from the table
for ex
if u have a table with data if u give
truncate table-name;
command it removes the record Permanently
Delete