Browse by Tags

• Databases
• EAE
• Java
• Linc
• migration
• OWNER
• Procedure
• SQL
• Stored

• Easy way to see the Explain Plan in Oracle

  Linc\EAE used profiles for their queries. Well the profile information is used by our migration tool to generate indexes. In Java is easy to intercept all SQL statements used by the translated application and analyze them. To analyse how a query... Posted Feb 03 2010, 06:07 PM by Mrojas with | with no comments Filed under: Java, ORACLE, migration, Linc, EAE

• Get Table Owner in Oracle

  When we migrate from LINC/EAE to Oracle, the migration tool generates an schema an tables form the original ISPECS. I came across with the problem that I had been playing around with a test database and I didn’t know who was the owner of the table. Well... Posted Feb 03 2010, 05:40 PM by Mrojas with | with no comments Filed under: ORACLE, migration, SQL, OWNER, Linc, EAE

• Get Java Version for Oracle Stored Procedures

  If you have to write stored procedures for oracle is important to notice which Java version is supported by your Oracle Database, A common technique is create a JAVA stored procedure for that: 1. Create a function with an ORACLE SQL statement like: CREATE... Posted Feb 01 2010, 11:17 AM by Mrojas with | with no comments Filed under: Java, ORACLE, Stored, Procedure

• List Jobs in Oracle

  If you have created any schedule jobs or you just need to see what jobs are available in a server you use the dba_jobs table. The following links provides more details about this view: http://www.praetoriate.com/data_dictionary/dd_dba_jobs.htm Posted May 21 2009, 11:41 AM by Mrojas with | with no comments Filed under: Databases, ORACLE