A cursor make it possible to define a result set and perform complex logic on a row by row basis. In order to perform this ,predict the parameters in fetching the cursor.

When fetching a cursor in SQL, you typically need the following parameters:

1. Cursor Name: This is the identifier for the cursor. It is used to control the cursor for various operations like fetching rows, closing the cursor, etc.

2. Operation: This specifies what operation to perform. For fetching rows, the operation would be FETCH.

3. Fetch Type: This specifies how to fetch the rows. There are several options like NEXT, PRIOR, FIRST, LAST, ABSOLUTE n, RELATIVE n. NEXT is the most common and fetches the next row in the result set.

4. Into Clause: This specifies the variables where the fetched data will be stored.

So, a typical fetch operation might look like this:

FETCH NEXT FROM cursor_name INTO @variable_name;

This statement fetches the next row from the cursor and stores the data in the specified variable.