sasfvs icon

Untitled

sasfvs | PRO | 07/05/17 07:15:33 AM UTC | 0 ⭐ | 7400 👁️ | Never ⏰ | []
PL/SQL |

290 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
SET SERVEROUTPUT ON; 
DECLARE
    v_fname students.first_name%TYPE; -- we declare an identical variable with the name v_fname and the identical type of first_name column from student
BEGIN
    SELECT first_name INTO v_fname FROM students WHERE stu_id = 1;
    DBMS_OUTPUT.PUT_LINE(v_fname);
END;

Comments

  • icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
    
    

    

            
    • 
            
            
  • 
                
    
                    
    
                         icon
                    
    
                    
    
                        
                        
                        
                    
    
                    
    
                        
                        01/01/70 12:00:00 AM UTC
                        
                    
    
                
    
                

    
    
    
        
    
            Plain Text
            |
            
    0 B
    
            
            |
            
     👍
    
            /
            
     👎
    
        
    
        
    
    
    
    
        
    
    
    

    

            
    •