POS System: Designing Login Form Using Oracle Developer 6i (Urdu/Hindi)

In this video, we will learn how to design login form of POS System using Oracle Developer 6i.
List of Videos for POS System
Tables for POS System
Create table USERS
(
userid NUMBER not null,
username VARCHAR2(30) not null,
password VARCHAR2(30) not null,

)

alter table USERS
add constraint USERS_PK primary key (USERID)

alter table USERS
add constraint UQ_NAME unique (USERNAME)
----------------------------------------------------------

create table MAIN_ITEM
(
mitem_id VARCHAR2(10) not null,
mitem_desc VARCHAR2(75),

)

alter table MAIN_ITEM
add primary key (MITEM_ID )

alter table MAIN_ITEM
add constraint UQ_DESC_MAIN_ITEM unique (mitem_desc)

----------------------------------------------------------------------------------

create table ITEM
(
mitem_id VARCHAR2(10),
item_code VARCHAR2(30),
item_desc VARCHAR2(100),
uom VARCHAR2(10),
rate NUMBER(10,2),
st_amount NUMBER(10,2),
min_level NUMBER,
max_level NUMBER,

item_id NUMBER not null
)

alter table ITEM
add constraint PK_ITEM_ID primary key (item_id)

alter table ITEM
add constraint UK_ITEM_CODE unique (ITEM_CODE)

alter table ITEM
add constraint MITEM_ID_FK foreign key (MITEM_ID)
references MAIN_ITEM (MITEM_ID)
-----------------------------------------------------------------------------------------

create table PARTY
(
party_id NUMBER(10,2) not null,
party_name VARCHAR2(75),
address VARCHAR2(300),
phone VARCHAR2(20),
party_type VARCHAR2(1),


)

alter table PARTY
add primary key (PARTY_ID)
--------------------------------------------------------------------------------------------
create table QUOTATION_M
(
trn_id NUMBER not null,
dated DATE,
party_name VARCHAR2(100),
expiry VARCHAR2(10),
payment_term VARCHAR2(10),
address VARCHAR2(100),
contact VARCHAR2(50)
)

alter table QUOTATION_M
add primary key (TRN_ID)

create table QUOTATION_D
(
trn_id NUMBER,
sr NUMBER,
item_code NUMBER,
item_name VARCHAR2(100),
qty NUMBER,
uom VARCHAR2(10),
vat NUMBER,
amount NUMBER,
rate VARCHAR2(10)
)
alter table QUOTATION_D
add constraint TRN_ID_FK foreign key (TRN_ID)
references QUOTATION_M(TRN_ID);

-----------------------------------------------------------------------------------------------
create table TRN_MASTER
(
trans_id NUMBER(10) not null,
doc_no NUMBER(10),
doc_date DATE,
party_id NUMBER(10),
tamount NUMBER
)

alter table TRN_MASTER
add primary key (TRANS_ID)

create table TRN_DETAIL
(
trans_id NUMBER(10),
doc_no NUMBER(10),
doc_date DATE,
item_code VARCHAR2(20),
uom VARCHAR2(10),
qty NUMBER(10,2),
item_sale_rate NUMBER(10,2),
item_pur_rate NUMBER(10,2),
amount NUMBER(10),
net_amount NUMBER(10),
dis_amount NUMBER(10,4),
exp_date DATE,
vat NUMBER

alter table TRN_DETAIL
add constraint TRANS_ID_FK foreign key (TRANS_ID)
references TRN_MASTER (TRANS_ID);
Step by step explanation.
Easy to follow and understand.
#itseries#OracleDeveloper#POS

[ansariqbal]

During creation of users table, u added ent_date, ent_user etc. but in form these column are not present in the table. have u deleted these columns?