select statement

[bhaski]

i found a code like ----

CURSOR check_options IS
SELECT 1
FROM PURCHASE_ORDER_OPTION
WHERE order_no = order_no_
AND line_no = line_no_
AND release_no = release_no_;

i cannot understand why select 1 is taken

simply by select 1 ony 1 is only selected though there are values in table.

[debasisdas]

it might be the user want to show the number of records where these field sare matching.

but there is nosense writing such a cursor.

[bhaski]

but why generally 1 in select statement is used? i have seen it in many other statements.

[Saii]

but why generally 1 in select statement is used? i have seen it in many other statements.

just to display that there are some rows in table for these filters

[r035198x]

it might be the user want to show the number of records where these field sare matching.

but there is nosense writing such a cursor.

Yep, this returns at least one record in the table because the fields being compared are the same anyway. It can be used perhaps to check if the table is empty ...