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.
Md. Quium Hossain who I'm Oracle DBA & APEX Developer. All-rounder in building small, medium, and enterprise applications. Extensive knowledge in various areas of web-driven applications in Back-end (PL/SQL, SQL, Java), Front-end (Oracle APEX, Oracle Forms, Oracle Reports, HTML, JavaScript, CSS, jQuery, OracleJET, ReactJS), RESTful APIs, Third-party library integrations (Apex Office Print (AOP), Payment Gateways, SMS, Syncfusion, HighCharts) and APEX Plugins (HighChart, StarRating)
Sunday, April 29, 2018
Friday, April 20, 2018
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 |
Monday, April 16, 2018
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
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
Saturday, April 14, 2018
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.
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.
Subscribe to:
Posts (Atom)
To generate a PDF using JavaScript in Oracle APEX from a collection
To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
---------------------------- | Keyboard Shortcut | ---------------------------- · Create: Breadcrumb Region Ctrl+/, C, B · ...