Designing Category Wise Report Using Oracle Developer 6i ( Urdu/Hindi)

In this video, we will design category wise report using Oracle Developer 6i (Urdu/Hindi).
Developing POS System Using Oracle Developer • POS ( Point of Sale ) ...
Oracle 11g Installation • Oracle 11g Installatio...
Installation of Oracle Developer 6i|Oracle Forms 6i, Oracle Report Builder 6i| • Installation of Oracle...
Creating Tables for POS System • POS System : Creating ...
Designing Login Form Part 1 • POS System: Designing ...
Designing Login Form Part 2 • POS System: Part 2 Des...
Designing Category Form • POS System : Category ...
Designing Item definition Form • POS System : Creating ...
Designing Party definition Form • POS System : Designing...
Designing Purchase Form Part -1 • POS System : Designing...
Designing Purchase Form Part -2 • POS System : Designing...
Designing Purchase Return Form • Designing Purchase Ret...
Designing Quotation Form • Designing Quotation Fo...
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.
www.itseriestu...
/ itseriestutor
#itseries#OracleDeveloper#POS

[@rangpurdigitalit]

Thank's for this video, Please continue..........

[@muhammadshanif7011]

Please upload more videos
Your videos are very helpful for us

[@themughalsolutions608]

Greate Effort

[@Islamourlife1]

Finally 🎉

[@energetictimebooster7263]

Excuse me! Sir, Is this your last video on RUclips?

[@fatimaAli-re8ly]

assalam o alikum sir ap please vu students k lia video helping bana dea kren or please sir c++ ko ik video men bana den complete