Home » Page 42

rownum in Oracle

Here in this post, we will talk about the ROWNUM keyword in Oracle What is ROWNUM It is a pseudo column (not a real column) that is available in a query. ROWNUM is assigned the numbers 1, 2, 3, 4, … N, where N is the number of rows for the first, second, third…n records …

rownum in Oracle Read More »

Query to check languages installed in oracle apps

We can have different languages installed in Oracle apps. Here is the Query to check languages installed in oracle apps select LANGUAGE_CODE from fnd_languages where INSTALLED_FLAG in (‘B’, ‘I’); The Installed_Flag has 3 values I- InstalledB- BaseD- Disabled Example sqlplus apps/<apps pass>select LANGUAGE_CODE from fnd_languages where INSTALLED_FLAG in (‘B’, ‘I’);LANG_____USDFR Important Points The above query …

Query to check languages installed in oracle apps Read More »

putty key format too new

We will be looking at one of the common errors faced by “putty key format too new” while using the putty tool Problem Many times, we may get the below error while connecting using putty putty key format too new This happens as the Putty version used by the user is older than the version …

putty key format too new Read More »

How to export/import Putty Sessions

We may need to export/import Putty sessions when we are moving to another laptop or system. Putty saved sessions are stored in the Windows registry. We will need to export the sessions from the registry to migrate them to another system. How to export Putty Sessions Here are the simple steps Step 1: Launch RunStep …

How to export/import Putty Sessions Read More »

Scroll to Top