Home > Mobile >  Oracle SQL - Remove Null rows in aliased results
Oracle SQL - Remove Null rows in aliased results

Time:04-04

Hi devs I'm developing a small pro bono project that's use oracle sql but I'm not able to hide the null results.

Table Structure:

CREATE TABLE "church-members" (
ID NUMBER(10),
NAME varchar(30)  NOT NULL,
LOGIN varchar(20)  NOT NULL,
PASS  varchar(12)  NOT NULL,
REGISTER_YEAR_MONTH varchar(15)  NOT NULL,
USER_SCORE NUMBER(10),
PRIMARY KEY (ID));

The queries:

INSERT INTO "church-members" VALUES
('1', 'John Doe', 'John', 'Xo8*d_d           
  • Related