title: Initialize User defined type attributes in PL SQL
body: <p>I have pretty new to PL SQL world..and could not find an answer to my question... so here it is:</p>
  
  <pre><code>create or replace 
  TYPE "A" as object{
  school_category  varchar(10);
  }
  
  create or replace 
  TYPE "B" UNDER A {
  school_name varchar(10);
  school_ranking INTEGER;
  }
  </code></pre>
  
  <p>My Question:
  1. How to initialize an object of type B, and initialize its parent's attributes?
  2. Is there anyway of explicitly assigning values to attributes at the time of creating the object? for example do we have such a thing:</p>
  
  <p>B_obj B := B(school_name :="example", school_ranking :="1", school_category:="elementary school");</p>
  
  <p>Thanks in advance guys...</p>