Question: Hello I am new to nodejs and mongodb.

I have 3 models:

1. "user" with fields "name phone"
2. "Shop" with fields "name, address"
3. "Member" with fields "shop user status". (shop and user hold the "id" of respective collections).

Now when I create "shops" api to fetch all shop, then I need to add extra field "isShopJoined" which is not part of the model. This extra field will true if user who see that shop is joined it otherwise it will be false.

The problem happens when I share my model with frontend developers like Android/iOS and others, They will not aware of that extra field until they see the API response.

So is it ok if I add extra field in shops listing which is not part of the model? Or do I need to add that extra field in model?

Answer: 
Client tools typically need something to separate two PL/SQL blocks, such as a line containing a slash character between the first `END;` and `CREATE OR REPLACE PACKAGE BODY`, so this

```
end;

create or replace package body hr

```

needs to become

```
end;
/

create or replace package body hr

```

otherwise it all gets treated as a single block of code with `CREATE` at line 9, which then won't compile because for one thing PL/SQL has no `CREATE` keyword.

For production code, it is considered good practice to maintain the package header and body in two separate version-controlled source files.
```
create table employee(
employee_id number(10) NOT NULL,
employee_name varchar2(50),
employee_sal number(10),
employee_role varchar2(50),
employee_age number(10),
CONSTRAINT employee_pk PRIMARY KEY(employee_id)
);

insert into employee(employee_id, employee_name, employee_sal, employee_role, employee_age)values(12,'ravi',5676,'dse',23);
insert into employee(employee_id, employee_name, employee_sal, employee_role, employee_age)values(13,'sai',85676,'tester',21);
insert  into employee(employee_id, employee_name, employee_sal, employee_role, employee_age)values(15,'chandu',4676,'developer',28);
insert  into employee(employee_id, employee_name, employee_sal, employee_role, employee_age)values(16,'raju',7676,'tech lead',22);
insert  into employee(employee_id, employee_name, employee_sal, employee_role, employee_age)values(17,'teja',9676,'manager',29);

  select * from employee;

create or replace package hr
  as
    procedure hire(enum in number, ename in varchar2, sal in  number, erole in varchar2, age in number);

    procedure fire(enum in number);

end;
/
CREATE OR REPLACE PACKAGE BODY hr
    AS
      PROCEDURE hire (enum   IN NUMBER,
                      ename  IN VARCHAR2,
                      sal    IN NUMBER,
                      erole  IN VARCHAR2,
                      age    IN NUMBER)
      IS
      BEGIN
         INSERT INTO employee (employee_id,
                              employee_name,
                              employee_sal,
                              employee_role,
                              employee_age)
              VALUES (enum,
                      ename,
                     sal,
                     erole,
                      age);

         COMMIT;
      END hire;

      PROCEDURE fire (enum IN NUMBER)
      IS
      BEGIN
        DELETE FROM employee
              WHERE employee_id = enum;

         COMMIT;
      END fire;
  END;

```