Forum Stats

  • 3,826,761 Users
  • 2,260,705 Discussions
  • 7,897,072 Comments

Discussions

Oracle report 12c 12.2.1.0.4

Sarah QA
Sarah QA Member Posts: 4,906 Silver Trophy

Dear all,

I want to create table something like the following

create table uni_project(

project_date date,

project_name varchar2(20),

project_notes varchar2(20),

project_credit number(10),

project_debit number(10),

project_balance number(10),

project_total number(10),

project_created_by varchar2(10));

Q.1. How to use Date in web_show_doc() to display record by date?

Q2. what will be the code for Project_created_by col in oracle form?

Q.3 what will be the formula for Credit col to be added to balance col and if its debit should be minus from balance col and total would be correct after using formula.

Please help me out. thanks a lot

Sarah