Sponsored Content
Special Forums UNIX and Linux Applications Passing the value of a cursor to another cursor Post 302567268 by radoulov on Sunday 23rd of October 2011 04:07:36 PM
Old 10-23-2011
Code:
cursor c1 IS
  select 
    employee_id 
  from 
    employee;
    
cursor c2 (p_employee_id) IS
  select 
    department_id 
  from 
    department 
  where 
    employee_id = p_employee_id;

BEGIN
  FOR c1_rec IN c1
  LOOP
    FOR c2_rec IN c2 (c1_rec.employee_id)
    LOOP
    ...

Or why not:

Code:
cursor c1 IS
  select 
    d.department_id 
  from 
    employee e,
    department d    
  where 
    d.employee_id = e.employee_id;

rec c1%rowtype;

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get the cursor position

Hello, Is there a way to get the current cursor position? I know "tput sc" saves it. Is there a way to find out the value saved? Thanks. (0 Replies)
Discussion started by: bestbuyernc
0 Replies

2. UNIX for Dummies Questions & Answers

Cursor Positioning

Can anyone tell me how to ouput the current cursor coordinate? I have tried using tput sc and tput rc. However I want to know what the coordinate is. Thanks. (1 Reply)
Discussion started by: bestbuyernc
1 Replies

3. Programming

positioning cursor

I am using curses.h and signals.h to control output to screen. My code displays an unchanging prompt that waits for user input. Meanwhile alarm signals are being generated that cause other ancillary messages to appear at other locations on the screen at various times. The problem I have is with... (2 Replies)
Discussion started by: enuenu
2 Replies

4. UNIX for Dummies Questions & Answers

Blinking cursor

Cursor is blinking (slightly) while loading page in Firefox, or during scrolling a window. I tried some variants of linux (gnome permanently) and of course my solaris. May be an artifact of X-window? Cause in windows cursor is stable (i'm feeling more confident). PS: It makes me nervous. (0 Replies)
Discussion started by: Xcislav
0 Replies

5. Shell Programming and Scripting

scrolling cursor

Hi, I'm writing scripts in perl and shell and want to add the oprion of scrolling cursor on the screen when there is no output to the screen for long time. I saw it in some script but I don't have the source code. Are anyone know how can I perform this ? Thanks (1 Reply)
Discussion started by: Alalush
1 Replies

6. UNIX for Dummies Questions & Answers

Cursor position

Is there a way of finding the current cursor position (line & column) within AIX (4 Replies)
Discussion started by: gefa
4 Replies

7. UNIX for Dummies Questions & Answers

flashing cursor

I am running a psychology experiment with a UNIX shell script as a front end. This precedes each trial: echo -e "\n\n\n ***Ready***" sleep 1 clear Is there a way to get rid of the flashing cursor after the clear command has been executed or another command I could use instead? It is a... (0 Replies)
Discussion started by: darwin_886
0 Replies

8. Shell Programming and Scripting

cursor positioning

Hi All, please help me to know how to move the cursor to the desired position? For example, in a shell script, I am displaying echo "\t Enter your Name:" please help me how to move cursor near the first word. for example, if the output is as below ... (3 Replies)
Discussion started by: little_wonder
3 Replies

9. Shell Programming and Scripting

Using Cursor in Unix - How to do it (Need Help)

Hi, I have a table in which i have the following data JOB_NO FILE_ID FILE_NAME 1546148 1378788 PDF Sample -1.pdf 1546148 1378789 PDF Sample -2.pdf 1546149 1378790 PDF Sample -3.pdf Now I would like use a cursor like thing in unix to download the files using the file ids and send... (1 Reply)
Discussion started by: uuuunnnn
1 Replies

10. Shell Programming and Scripting

Getting the cursor position

I need to get the cursor position, and put it inside a variable. Problem is, i don't have the tput command, or ncurses. Apparently I was supposed to try the following: echo -e '\E But I don't get a value or anything. Please help. (3 Replies)
Discussion started by: tinman47
3 Replies
XRecolorCursor(3X11)													      XRecolorCursor(3X11)

NAME
XRecolorCursor, XFreeCursor, XQueryBestCursor - manipulate cursors SYNOPSIS
XRecolorCursor(display, cursor, foreground_color, background_color) Display *display; Cursor cursor; XColor *foreground_color, *background_color; XFreeCursor(display, cursor) Display *display; Cursor cursor; Status XQueryBestCursor(display, d, width, height, width_return, height_return) Display *display; Drawable d; unsigned int width, height; unsigned int *width_return, *height_return; ARGUMENTS
Specifies the RGB values for the background of the source. Specifies the cursor. Specifies the drawable, which indicates the screen. Specifies the connection to the X server. Specifies the RGB values for the foreground of the source. Specify the width and height of the cursor that you want the size information for. Return the best width and height that is closest to the specified width and height. DESCRIPTION
The XRecolorCursor function changes the color of the specified cursor, and if the cursor is being displayed on a screen, the change is vis- ible immediately. The pixel members of the XColor structures are ignored; only the RGB values are used. XRecolorCursor can generate a BadCursor error. The XFreeCursor function deletes the association between the cursor resource ID and the specified cursor. The cursor storage is freed when no other resource references it. The specified cursor ID should not be referred to again. XFreeCursor can generate a BadCursor error. Some displays allow larger cursors than other displays. The XQueryBestCursor function provides a way to find out what size cursors are actually possible on the display. It returns the largest size that can be displayed. Applications should be prepared to use smaller cursors on displays that cannot support large ones. XQueryBestCursor can generate a BadDrawable error. DIAGNOSTICS
A value for a Cursor argument does not name a defined Cursor. A value for a Drawable argument does not name a defined Window or Pixmap. SEE ALSO
XCreateColormap(3X11), XCreateFontCursor(3X11), XDefineCursor(3X11) Xlib -- C Language X Interface XRecolorCursor(3X11)
All times are GMT -4. The time now is 04:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy