Oralce PL/SQL : Creating calendar table

SQL> create table calendar(c_date date);

Table created.

SQL> insert into calendar
  2  select to_date(to_char(19900101), 'yyyymmdd') + lvl d
  3  from ( select level -1 lvl
  4  from dual
  5  connect by level <= 20000);

20000 rows created.

Where are configuration files stored in Oracle 12c?

Where are configuration files stored?

Forms

File	Path
formsweb.cfg	/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_12.2.1/config
default.env	/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_12.2.1/config
Templates	/config/fmwconfig/components/FORMS/instances/forms1/server
registry.dat	/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_12.2.1/config/oracle/forms/registry
ftrace.cfg	/config/fmwconfig/components/FORMS/instances/forms1/server
webutil.cfg	/config/fmwconfig/components/FORMS/instances/forms1/server

Reports:

File	Path
rwserver.conf	/config/fmwconfig/servers/WLS_REPORTS/applications/reports_12.2.1/configuration
rwnetwork.conf	/config/fmwconfig/servers/WLS_REPORTS/applications/reports_12.2.1/configuration
rwservlet.properties	/config/fmwconfig/servers/WLS_REPORTS/applications/reports_12.2.1/configuration

iconic button in oracle forms 10g

Set 10g forms icon easy way

1.
paste icon to C:\Oracle\DevSuiteHome_1\forms\java folder     ---only gif ions

2.
C:\Oracle\DevSuiteHome_1\forms\server\formsweb.cfg
change  imageBase=DocumentBase to imageBase=codebase

3.
go to forms set

button icon yes
button name  null
button icon print.gif

4. restart oc4j

5. run your forms view icon

same table column update rownum in oracle order by date column

Enter user-name: hr/hr@orcl

create table same_tbl_rownum(id varchar2(10),dt date, smv varchar2(10), sl number(10));

insert into same_tbl_rownum values('10','10-mar-18','bangla1','');
insert into same_tbl_rownum values('12','11-mar-18','bangla2','');
insert into same_tbl_rownum values('15','12-mar-18','bangla3','');
insert into same_tbl_rownum values('16','16-mar-18','bangla4','');
insert into same_tbl_rownum values('17','11-mar-19','bangla5','');
insert into same_tbl_rownum values('01','20-mar-20','bangla5','');

commit;

select * from same_tbl_rownum;

ID         DT        SMV                SL
---------- --------- ---------- ----------
10         10-MAR-18 bangla1
12         11-MAR-18 bangla2
15         12-MAR-18 bangla3
16         16-MAR-18 bangla4
17         11-MAR-19 bangla5
01         20-MAR-20 bangla5

6 rows selected.



    UPDATE same_tbl_rownum
        SET sl= (select rn
                                 from (
                                    select rowid,
                                          row_number() over (order by dt) AS RN
                                   from same_tbl_rownum
                               ) x
                               where x.rowid = same_tbl_rownum.rowid)
   /

select * from same_tbl_rownum ;

ID         DT        SMV                SL
---------- --------- ---------- ----------
10         10-MAR-18 bangla1             1
12         11-MAR-18 bangla2             2
15         12-MAR-18 bangla3             3
16         16-MAR-18 bangla4             4
17         11-MAR-19 bangla5             5
01         20-MAR-20 bangla5             6

6 rows selected.