CREATE TYPE price_arr AS VARRAY(10) OF NUMBER(12,2); -- CREATE type share_t as object( cname varchar(12), cprice number(6,2), exchanges price_arr, dividend number(4,2), earninngs number(6,2) ) INSERT INTO shares values('BHP',10.50,excharray('sydney','new york'),1.50,3.20);
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter