| 292 |
|
Size = 2 |
| 293 |
|
Value = 0 |
| 294 |
|
|
| 295 |
+ |
Results for Cursor: Test Cursor |
| 296 |
|
EMP_NO = 8 |
| 297 |
|
FIRST_NAME = Leslie |
| 298 |
|
LAST_NAME = Johnson |
| 520 |
|
Size = 2 |
| 521 |
|
Value = 0 |
| 522 |
|
|
| 523 |
+ |
Results for Cursor: Test Cursor |
| 524 |
|
EMP_NO = 8 |
| 525 |
|
FIRST_NAME = Leslie |
| 526 |
|
LAST_NAME = Johnson |
| 533 |
|
SALARY = 64,635.00 |
| 534 |
|
FULL_NAME = Johnson, Leslie |
| 535 |
|
|
| 536 |
+ |
Scollable Cursors |
| 537 |
+ |
Do Fetch Next: |
| 538 |
+ |
EMP_NO = 2 |
| 539 |
+ |
FIRST_NAME = Robert |
| 540 |
+ |
LAST_NAME = Nelson |
| 541 |
+ |
PHONE_EXT = 250 |
| 542 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
| 543 |
+ |
DEPT_NO = 600 |
| 544 |
+ |
JOB_CODE = VP |
| 545 |
+ |
JOB_GRADE = 2 |
| 546 |
+ |
JOB_COUNTRY = USA |
| 547 |
+ |
SALARY = 105,900.00 |
| 548 |
+ |
FULL_NAME = Nelson, Robert |
| 549 |
+ |
Do Fetch Last: |
| 550 |
+ |
EMP_NO = 145 |
| 551 |
+ |
FIRST_NAME = Mark |
| 552 |
+ |
LAST_NAME = Guckenheimer |
| 553 |
+ |
PHONE_EXT = 221 |
| 554 |
+ |
HIRE_DATE = 1994/05/02 00:00:00.0000 |
| 555 |
+ |
DEPT_NO = 622 |
| 556 |
+ |
JOB_CODE = Eng |
| 557 |
+ |
JOB_GRADE = 5 |
| 558 |
+ |
JOB_COUNTRY = USA |
| 559 |
+ |
SALARY = 32,000.00 |
| 560 |
+ |
FULL_NAME = Guckenheimer, Mark |
| 561 |
+ |
Do Fetch Prior: |
| 562 |
+ |
EMP_NO = 144 |
| 563 |
+ |
FIRST_NAME = John |
| 564 |
+ |
LAST_NAME = Montgomery |
| 565 |
+ |
PHONE_EXT = 820 |
| 566 |
+ |
HIRE_DATE = 1994/03/30 00:00:00.0000 |
| 567 |
+ |
DEPT_NO = 672 |
| 568 |
+ |
JOB_CODE = Eng |
| 569 |
+ |
JOB_GRADE = 5 |
| 570 |
+ |
JOB_COUNTRY = USA |
| 571 |
+ |
SALARY = 35,000.00 |
| 572 |
+ |
FULL_NAME = Montgomery, John |
| 573 |
+ |
Do Fetch First: |
| 574 |
+ |
EMP_NO = 2 |
| 575 |
+ |
FIRST_NAME = Robert |
| 576 |
+ |
LAST_NAME = Nelson |
| 577 |
+ |
PHONE_EXT = 250 |
| 578 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
| 579 |
+ |
DEPT_NO = 600 |
| 580 |
+ |
JOB_CODE = VP |
| 581 |
+ |
JOB_GRADE = 2 |
| 582 |
+ |
JOB_COUNTRY = USA |
| 583 |
+ |
SALARY = 105,900.00 |
| 584 |
+ |
FULL_NAME = Nelson, Robert |
| 585 |
+ |
Do Fetch Abs 8 : |
| 586 |
+ |
EMP_NO = 14 |
| 587 |
+ |
FIRST_NAME = Stewart |
| 588 |
+ |
LAST_NAME = Hall |
| 589 |
+ |
PHONE_EXT = 227 |
| 590 |
+ |
HIRE_DATE = 1990/06/04 00:00:00.0000 |
| 591 |
+ |
DEPT_NO = 900 |
| 592 |
+ |
JOB_CODE = Finan |
| 593 |
+ |
JOB_GRADE = 3 |
| 594 |
+ |
JOB_COUNTRY = USA |
| 595 |
+ |
SALARY = 69,482.63 |
| 596 |
+ |
FULL_NAME = Hall, Stewart |
| 597 |
+ |
Do Fetch Relative -2 : |
| 598 |
+ |
EMP_NO = 11 |
| 599 |
+ |
FIRST_NAME = K. J. |
| 600 |
+ |
LAST_NAME = Weston |
| 601 |
+ |
PHONE_EXT = 34 |
| 602 |
+ |
HIRE_DATE = 1990/01/17 00:00:00.0000 |
| 603 |
+ |
DEPT_NO = 130 |
| 604 |
+ |
JOB_CODE = SRep |
| 605 |
+ |
JOB_GRADE = 4 |
| 606 |
+ |
JOB_COUNTRY = USA |
| 607 |
+ |
SALARY = 86,292.94 |
| 608 |
+ |
FULL_NAME = Weston, K. J. |
| 609 |
+ |
Do Fetch beyond EOF : |
| 610 |
+ |
Fetch returned false |
| 611 |
|
|
| 612 |
|
|
| 613 |
|
------------------------------------------------------ |
| 645 |
|
SALARY = 64,635.00 |
| 646 |
|
FULL_NAME = Johnson, Leslie |
| 647 |
|
|
| 648 |
< |
Current memory = 19,693,312 |
| 648 |
> |
Current memory = 19,694,032 |
| 649 |
|
Delta memory = 4,480 |
| 650 |
< |
Max memory = 19,755,424 |
| 650 |
> |
Max memory = 19,755,888 |
| 651 |
|
Elapsed time= 0.001 sec |
| 652 |
|
Cpu = 0.000 sec |
| 653 |
|
Buffers = 2048 |
| 811 |
|
JOB_CODE = Eng |
| 812 |
|
JOB_GRADE = 4 |
| 813 |
|
JOB_COUNTRY = England |
| 814 |
< |
SALARY = 40,000.58 |
| 814 |
> |
SALARY = 40,000.59 |
| 815 |
|
FULL_NAME = Major, Major |
| 816 |
|
|
| 817 |
|
Now Delete the rows |
| 2799 |
|
Database Created: 09/1/2020 13:13:45 |
| 2800 |
|
Pages Used = 297 |
| 2801 |
|
Pages Free = 10 |
| 2802 |
< |
Server Memory = 19195664 |
| 2802 |
> |
Server Memory = 19196128 |
| 2803 |
|
Forced Writes = 1 |
| 2804 |
< |
Max Memory = 19316176 |
| 2804 |
> |
Max Memory = 19316896 |
| 2805 |
|
Num Buffers = 2048 |
| 2806 |
|
Sweep Interval = 20000 |
| 2807 |
|
Logged in Users: SYSDBA, |
| 3395 |
|
Nullable |
| 3396 |
|
Size = 8 |
| 3397 |
|
|
| 3398 |
+ |
Expected Error - Dynamic SQL Error |
| 3399 |
+ |
-SQL error code = -303 |
| 3400 |
+ |
-conversion error from string "1,000" |
| 3401 |
+ |
Expected Error - Dynamic SQL Error |
| 3402 |
+ |
-SQL error code = -303 |
| 3403 |
+ |
-conversion error from string "10.0.0" |
| 3404 |
|
ROWID = 1 |
| 3405 |
|
ITYPE = 101 |
| 3406 |
|
I64TYPE = 9223372036854775807 |
| 3407 |
|
CURRTYPE = 10,000.12340000 |
| 3408 |
|
DTYPE = 9,999.12345678 |
| 3409 |
< |
FIXEDPOINT = 1,234,567,890.12345600 |
| 3409 |
> |
FIXEDPOINT = 1,234,567,890.12345700 |
| 3410 |
|
ROWID = 2 |
| 3411 |
|
ITYPE = -32457 |
| 3412 |
|
I64TYPE = -9223372036854775808 |
| 3413 |
|
CURRTYPE = 1,000,001.12000000 |
| 3414 |
|
DTYPE = 1.7E308 |
| 3415 |
< |
FIXEDPOINT = -1,234,567,890.12345600 |
| 3415 |
> |
FIXEDPOINT = -1,234,567,890.12345700 |
| 3416 |
|
ROWID = 3 |
| 3417 |
|
ITYPE = 0 |
| 3418 |
|
I64TYPE = 0 |
| 3419 |
|
CURRTYPE = .00000000 |
| 3420 |
|
DTYPE = .00000000 |
| 3421 |
|
FIXEDPOINT = .00000000 |
| 3422 |
+ |
ROWID = 4 |
| 3423 |
+ |
ITYPE = 1 |
| 3424 |
+ |
I64TYPE = 10 |
| 3425 |
+ |
CURRTYPE = .02300000 |
| 3426 |
+ |
DTYPE = .00000000 |
| 3427 |
+ |
FIXEDPOINT = 233.45600000 |
| 3428 |
|
|
| 3429 |
|
|
| 3430 |
|
|
