Ask Anantha

Caution: Raised your eyebrows with this notice? You should be. Why? Because, this is not a sure-shot method for converting your old forms to new version. If you are having more number of forms, you should try this method with a hand-full of forms first. Make sure that this works, and then proceed to your full set of forms for conversion. The conversion is a complex task, dealt with as a simple task in this article. I believe in breaking up of the complex task into multiple simple chunks which can be managed easily. So beware of estimating the conversion. Always keep a BIG buffer time for your conversion activities as it is NOT AN EASY TASK. In this article we will go through methods to convert an earlier version of Oracle Forms to Oracle Forms 10g Version. Here we are going to discuss a method through batch file provided by Oracle. In the <ORACLE_HOME>\BIN folder there is a batch file named frmplsqlconv.bat . In this batch file it is calling a Java class to search and repl...

Making Oracle Case insensitive Well, this article is the fruit of thoughts on which how you can make Oracle's output case insensitive. Of course, the simplest way is to use the UPPER() function to change the case of either data stored or data being checked. For Example: SELECT *  FROM emp WHERE UPPER(ename) = ' RAVI '; Function Based Index  But by following this method, there is one problem. If the column ename is having an index, it will no longer be used. But starting from Oracle 8i, there is a concept called function-based index. Before getting to use function-based indexes, the following criteria must be met with: You must have the system privilege query rewrite to create function based indexes on tables in your own schema. You must have the system privilege global query rewrite to create function based indexes on tables in other schema's. For the optimizer to use function based indexes, the following session or system ...

In this article we will discuss what people end up doing erroneously. As data type Oracle stores DATE in a separate format then Character. But when passing values between two programs, the format may cease to be a Date anymore. For example there are two independent systems, one which is a Oracle system (which we are going to see) and another foreign system which uses some other technology. In this case let us also assume that the foreign system is our front-end to the user and Oracle system is the back-end part of the system. Say the front-end system is passing some date value which has been input from user to the database. The value will be interpreted as a Character by the Oracle system. To convert the Character value to a Oracle-specific date data type, we will be using the function to_date(). The function to_date() accepts a Character value and will convert it into a Date (as understood by Oracle). We also needs to tell to the function what is the format in which the date value is ...

Contents General Connections Creating and Modifying Objects PL/SQL Preferences Reports Schema Diff Linux Only Issues Oracle 8.1.7 (Not Certified) 1. General Settings from previous release not migrated Extensions for SQL Developer 1.0 no longer work 1.1. You can't invoke SQL*Plus for users with TNSNAMES Connections. Query Builder Where Clause for a self referencing table is incorrect. Tables are not listed alphabetically. You can't always drag a table onto the white space. Workaround: Close and reopen the Query Builder. Two consecutive queries give an Ora error. Workaround: Add ';' to the first, before adding second query. Icons to be updated for production release. PL/SQL icons require more definition There is an error when you add External Tools. This is not causing any SQL Developer errors. You can ignore it. 2. Connections Cannot connect to remote database as OPS$ account. Import Connection: Does not permit replacing existing connections. ...