Showing TYPE’d Column Values in SQL Developer

thatjeffsmith SQL Developer 3 Comments

Someone on the innerwebs asked how to show the data inside their user defined TYPE’d column in a table when querying it with SQL Developer. Here’s their code: CREATE OR REPLACE TYPE ANSCHRIFT_T AS OBJECT (STRASSE CHAR(12), HAUSNR CHAR(3));   CREATE TABLE VERTRETER(V_NR NUMBER(4) PRIMARY …

Related Posts Plugin for WordPress, Blogger...