anandanbazhagan.blogspot.com
Make IT Happen: Export to Excel From Oracle Forms
http://anandanbazhagan.blogspot.com/2010/07/export-to-excel-from-oracle-forms.html
Find out what I'm doing, Follow Me :). Thursday, July 1, 2010. Export to Excel From Oracle Forms. Inbcols PLS INTEGER := 0;. Inbrows PLS INTEGER := 0;. Inbsheets PLS INTEGER := 0;. Col cnt PLS INTEGER;. Rec tab DBMS SQL.desc tab;. Col num NUMBER;. Source cursor INTEGER;. Application client ole2.obj type;. Workbooks client ole2.obj type;. Workbook client ole2.obj type;. Worksheets client ole2.obj type;. Worksheet client ole2.obj type;. Cell client ole2.obj type;. Hfontobj2 client ole2.obj type;. Inbrows :...
venkiru.blogspot.com
Knowledge is Power: September 2011
http://venkiru.blogspot.com/2011_09_01_archive.html
Monday, September 19, 2011. EL Expression Used to Set an inlineStyle Attribute. Af:outputText value=#{row.assignedDate eq. InlineStyle=#{row.assignedDate eq null? Color:rgb(255,0,0);':' }/. Friday, September 16, 2011. Af table: data-row:selected:inactive af column: data-cell, af table: data-row:selected:inactive af column: banded-data-cell, af table: data-row:selected:focused af column: data-cell {. Background-color: rgb(156,172,201);. Background-color: rgb(102,255,51);. Background-color: rgb(102,255,51);.
anandanbazhagan.blogspot.com
Make IT Happen: using REGEXP_LIKE and REGEXP_INSTR
http://anandanbazhagan.blogspot.com/2010/07/using-regexplike-and-regexpinstr.html
Find out what I'm doing, Follow Me :). Thursday, July 1, 2010. Using REGEXP LIKE and REGEXP INSTR. A-zA-Z0-9 .] @[a-zA-Z0-9] .[a-zA-Z]{2,4}$'. Subscribe to: Post Comments (Atom). Create a JOB Scheduler:. Example For BulkCollect and For all. Import from Excel to Database. Export to Excel From Oracle Forms. Example for DBMS SQL. Using REGEXP LIKE and REGEXP INSTR. Query to find the Last DML Operation:. HOW TO FIND THE LAST EXECUTION TIME OF THE PROCEDU. Run Report from Sql. Balaji's Blog: Learning Oracle.
anandanbazhagan.blogspot.com
Make IT Happen: Query to find the Last DML Operation:
http://anandanbazhagan.blogspot.com/2010/07/query-to-find-last-dml-operation.html
Find out what I'm doing, Follow Me :). Thursday, July 1, 2010. Query to find the Last DML Operation:. 1)exec dbms stats.flush database monitoring info;. SELECT * FROM sys.DBA TAB MODIFICATIONS WHERE TABLE NAME like 'TABLE 4'. Scn to timestamp(ora rowscn). Subscribe to: Post Comments (Atom). Create a JOB Scheduler:. Example For BulkCollect and For all. Import from Excel to Database. Export to Excel From Oracle Forms. Example for DBMS SQL. Using REGEXP LIKE and REGEXP INSTR. Run Report from Sql.
venkiru.blogspot.com
Knowledge is Power: May 2012
http://venkiru.blogspot.com/2012_05_01_archive.html
Thursday, May 24, 2012. Send SMS using AT command with the help of Java. Import java.io.*;. Import java.util.*;. Import javax.comm.*;. Public class GSMConnect implements SerialPortEventListener,. Private String comPort = COM3; / This COM Port must be connect with GSM Modem or your mobile phone. Private String messageString = ;. Private CommPortIdentifier portId = null;. Private Enumeration portList;. Private InputStream inputStream = null;. Private OutputStream outputStream = null;. ThiscomPort = comm;.
venkiru.blogspot.com
Knowledge is Power: July 2010
http://venkiru.blogspot.com/2010_07_01_archive.html
Monday, July 12, 2010. Change to Default Setting for FORMS RESTRICT ENTER QUERY Environment Variable. The environment setting FORMS RESTRICT ENTER QUERY has a default value of TRUE. This setting disallows users from using QUERY-WHERE functionality until it is set to FALSE in the default.env file. Saturday, July 10, 2010. SET serveroutput ON;. I NUMBER := 6;. J NUMBER := 0;. DBMS OUTPUT.put line (LPAD (LPAD (' ', i, '*'), i j, ' ') ;. EXIT WHEN i = 6;. SET serveroutput ON;. I NUMBER := 6;. J NUMBER := 0;.
anandanbazhagan.blogspot.com
Make IT Happen: July 2010
http://anandanbazhagan.blogspot.com/2010_07_01_archive.html
Find out what I'm doing, Follow Me :). Saturday, July 10, 2010. Job scheduling from Oracle 10g with dbms scheduler. In Oracle 10g the DBMS JOB package is replaced by the DBMS SCHEDULER package. The DBMS JOB package is now depricated and in Oracle 10g it's only provided for backward compatibility. From Oracle 10g the DBMS JOB package should not be used any more, because is could not exist in a future version of Oracle. ALTER SYSTEM SET RESOURCE LIMIT = TRUE;. Dbms scheduler.create job(. You can schedule t...
anandanbazhagan.blogspot.com
Make IT Happen: HOW TO FIND THE LAST EXECUTION TIME OF THE PROCEDURE?
http://anandanbazhagan.blogspot.com/2010/07/how-to-find-last-execution-time-of.html
Find out what I'm doing, Follow Me :). Thursday, July 1, 2010. HOW TO FIND THE LAST EXECUTION TIME OF THE PROCEDURE? Auditing is disabled by default. CONNECT sys/password AS SYSDBA;. ALTER SYSTEM SET audit trail=db SCOPE=SPFILE;. MIS BY ACCESS;. AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY. MIS BY ACCESS;. AUDIT EXECUTE PROCEDURE BY. MIS BY ACCESS;. Subscribe to: Post Comments (Atom). Create a JOB Scheduler:. Example For BulkCollect and For all. Import from Excel to Database.
anandanbazhagan.blogspot.com
Make IT Happen: Oracle JOB scheduling
http://anandanbazhagan.blogspot.com/2010/07/oracle-job-scheduling.html
Find out what I'm doing, Follow Me :). Saturday, July 10, 2010. Job scheduling from Oracle 10g with dbms scheduler. In Oracle 10g the DBMS JOB package is replaced by the DBMS SCHEDULER package. The DBMS JOB package is now depricated and in Oracle 10g it's only provided for backward compatibility. From Oracle 10g the DBMS JOB package should not be used any more, because is could not exist in a future version of Oracle. ALTER SYSTEM SET RESOURCE LIMIT = TRUE;. Dbms scheduler.create job(. You can schedule t...
anandanbazhagan.blogspot.com
Make IT Happen: Materialized View
http://anandanbazhagan.blogspot.com/2010/07/materialized-view.html
Find out what I'm doing, Follow Me :). Thursday, July 1, 2010. A materialized view is a database object that contains the results of a query. They are local copies of data located remotely, or are used to create summary tables based on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots. CREATE MATERIALIZED VIEW mv name. REFRESH [ FAST COMPLETE FORCE ]. START WITH DATE] [NEXT DATE]. WITH (PRIMARY KEY ROW ID)]. Refresh Method - FAST Clause.