1 Reply Latest reply: Jul 8, 2013 7:55 AM by Rrademak-Oracle RSS

    How to create LOV's


      How to create LOV's in SubInventory,Driver_name,Vehicle_number,invoice_number,invoice_value,location,station_name by using


      Create table CC_table               (Fuel_type         varchar2(100),    

                                                   Vehicle_Number1               VARCHAR2(20),

                                                    Vehicle_Number2               VARCHAR2(20),                  

                                                   Driver_Name                   varchar2(20),

                                                   Approved_By                   varchar2(100),

                                                    Invoice_Number                Varchar2(50),

                                                   Location                      varchar2(20),

                                                   Route_Name                      VARCHAR2(20),

                                                   Pump_No                       Varchar2 (20),

                                                   Meter_Reading                 number,

                                                  Fuel                          varchar2(30),

                                                 Subinventory                  varchar2(20),

                                                 Quantity_Issued               number,

                                                 Invoice_Value                 number,

                                                 Station_Name                  varchar2(50),

                                                  Remarks                       varchar2(100),

                                                  creation_date                 date,

                                                  created_by                    number,

                                                   last_update_date              date,

                                                   last_updated_by               number);