User Profile

Collapse

Profile Sidebar

Collapse
rsankpal
rsankpal
Last Activity: Jul 27 '06, 06:40 AM
Joined: Jul 19 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rsankpal
    replied to PL/SQL - Can function have OUT, IN OUT parameter ?
    in Oracle
    Yes, we have in-out parameter in function. we can use it in select statement.
    we can have more than one OUT parameter in function.But to execute this unction all this function in anonomous block and use dbms_output.put _line :)
    See more | Go to post
    Last edited by rsankpal; Jul 27 '06, 06:27 AM.

      Leave a comment:

    • rsankpal
      started a topic oracle object relatedquery
      in Oracle

      oracle object relatedquery

      CREATE OR REPLACE TYPE cust_address_t
      AS OBJECT (
      street_address VARCHAR2(40),
      postal_code VARCHAR2(10),
      city VARCHAR2(30),
      state_province VARCHAR2(2),
      country_id VARCHAR(2));
      /

      CREATE OR REPLACE TYPE address_book_t AS TABLE OF cust_address_t;

      CREATE TABLE cust_address (
      custno NUMBER(10),
      street_address VARCHAR2(40),
      postal_code...
      See more | Go to post
      No activity results to display
      Show More
      Working...