QL>
SQL> conn SYS/SYS@ORCL AS SYSDBA
Connected.
SQL> CONN POS1018/P@ORCLPDB
Connected.
SQL> DESC QL>
SQL> conn SYS/SYS@ORCL AS SYSDBA
Connected.
SQL> CONN POS1018/P@ORCLPDB
Connected.
SQL> DESC ITEMS
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(10)
BARCODE NOT NULL VARCHAR2(50)
TYP CHAR(1)
NAME NOT NULL VARCHAR2(50)
DESCRIPTIONS VARCHAR2(1000)
BRANDS NUMBER(10)
UNIT_TYPE NUMBER(10)
CATEGORIES NUMBER(10)
SUB_CATEGORIES NUMBER(10)
BUY_PRICE NUMBER(11,2)
SELL_PRICE NUMBER(11,2)
STOCK NUMBER(10)
IMAGE BLOB
IMAGE_MIMETYPE VARCHAR2(2000)
IMAGE_FILENAME VARCHAR2(2000)
IMAGE_CHARACTERSET VARCHAR2(2000)
IMAGE_LAST_UPDATE DATE
ENTRY_BY NUMBER(10)
ENTRY_DATE DATE
UPDATE_BY NUMBER(10)
UPDATE_DATE DATE
BRANCH NOT NULL NUMBER(10)
SQL> INSERT INTO ITEMS (ID,BARCODE,TYP,NAME,BRANCH) VALUES (1001,'P1001','P',');
ERROR:
ORA-01756: quoted string not properly terminated
SQL> INSERT INTO ITEMS (ID,BARCODE,TYP,NAME,BRANCH) VALUES (1001,'P1001','P',);
INSERT INTO ITEMS (ID,BARCODE,TYP,NAME,BRANCH) VALUES (1001,'P1001','P',)
*
ERROR at line 1:
ORA-00936: missing expression
SQL> INSERT INTO ITEMS (ID,BARCODE,TYP,NAME,BRANCH) VALUES (1001,'P1001','P','CHIPS',1001);
1 row created.
SQL>
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(10)
BARCODE NOT NULL VARCHAR2(50)
TYP CHAR(1)
NAME NOT NULL VARCHAR2(50)
DESCRIPTIONS VARCHAR2(1000)
BRANDS NUMBER(10)
UNIT_TYPE NUMBER(10)
CATEGORIES NUMBER(10)
SUB_CATEGORIES NUMBER(10)
BUY_PRICE NUMBER(11,2)
SELL_PRICE NUMBER(11,2)
STOCK NUMBER(10)
IMAGE BLOB
IMAGE_MIMETYPE VARCHAR2(2000)
IMAGE_FILENAME VARCHAR2(2000)
IMAGE_CHARACTERSET VARCHAR2(2000)
IMAGE_LAST_UPDATE DATE
ENTRY_BY NUMBER(10)
ENTRY_DATE DATE
UPDATE_BY NUMBER(10)
UPDATE_DATE DATE
BRANCH NOT NULL NUMBER(10)
SQL> INSERT INTO ITEMS (ID,BARCODE,TYP,NAME,BRANCH) VALUES (1001,'P1001','P','CHIPS',1001);
1 row created.
SQL>
