Create a plsql object

CREATE TYPE emp_object AS OBJECT(
emp_no NUMBER,
emp_name VARCHAR2(50),
salary NUMBER,
manager NUMBER,
CONSTRUCTOR FUNCTION emp_object(p_emp_no NUMBER, p_emp_name VARCHAR2,
p_salary NUMBER) RETURN SELF AS RESULT),
MEMBER PROCEDURE insert_records,
MEMBER PROCEDURE display_records);
/

Source: guru99.com

Similar codes

15 votes202 views4 answers
How to get all tables in sql
SQL
0 vote223 views1 answer
Display all node label neo4j
SQL
2 votes210 views1 answer
Oracle kill job by sid
SQL
4 votes194 views1 answer
Oracle error compilation line
SQL
0 vote219 views1 answer
Where date major today mysql
SQL
1 vote201 views3 answers
Mysql disable foreign keys check
SQL
12 votes217 views5 answers
Rename table in mysql
SQL
0 vote213 views1 answer
Watch mysql command line
SQL
0 vote197 views1 answer
View acl table oracle
SQL
1 vote220 views1 answer
Oracle create as select
SQL