'import' is not recognized as an internal or external command

This error might come up when you are trying to deploy an OAF pages and using the import command to import page files.
This error is coming up because in your environment variables you have not setup the path variable.
Location of import utility: C:\<JDeveloper-Installed-location>\jdevbin\oaext\bin
You can either include this in you path variable or just execute this in CMD:
cd C:\<JDeveloper-Installed-location>\jdevbin\oaext\bin
and then execute your import command.

Note: Using first method you will never have to worry about this problem again, but if you use second method, you need to do it every time you are importing a page.

ORA-01791: not a SELECTed expression - Oracle Error

This Error message might show up when you are trying to use DISTINCT with ORDER BY clause. Let us try and understand when this error message comes and what is causing it. Take the following simple SQL for example:

  SELECT    DISTINCT a, b
    FROM      mytable
ORDER BY c

When we try to run the above SQL we will get the error message: "ORA-01791: not a SELECTed expression".
The reason for this is simple, once you have applied DISTINCT to the result set the only columns that are available are the ones written (calculated) in the SELECT query.
So if you try to run the below query then it will run without any issues:

   SELECT   DISTINCT a, b, c
    FROM      mytable
ORDER BY c

If this guide was helpful to you, do not forget to leave a Thanks message.

Remove bloatware from BlueStacks latest version

This guide will help you to stop Bluestacks from auto downloading Bloat Apps and will improve the overall experience in Bluestacks as if you were using your phone or Tablet.

Okay so let's start:

Step 1: Uninstall your current copy of Bluestacks.

Step 2: Restart your PC

Step 3: Download APK for Nova Launcher, Google Play Store and ES Explorer (or any other File Manager).

Step 4: Download and Install BlueStacks from FileHippo.

Step 5: As soon as Bluestacks starts for the first time double click on Nova Launcher APK in Windows to install it on Bluestacks.

Step 6: Press Home Button and Select Nova Launcher as your default launcher.

Step 7: Force stop GamePop Home from 'Settings'(NOT 'Bluestacks Settings')> Apps> Running tab. 

Step 8: Disable the following apps in 'Settings' (NOT 'Bluestacks Settings'): BS-Services, MyBluestacks, Notepad, Picasa Uploader and Search.

Step 9: Double click on Google Play Store and ES Explorer to install them.

Step 10: Close the Bluestacks completely (from Notification Panel as well). STart it up again. This time Nova Launcher should start by default.

Step 11: Click on the Google Play Store icon and sign in to your Google Account. 

Step 12: Google Play Store and Google Services should automatically update itself in 5-10 minutes depending on your connection speed.

I do not recommend using any of the Bluestacks apps, not even there default Browser, so install Chrome and set it as default if possible. Also never try to open 'Bluestacks Settings' and 'GamePop Home'.

Install your game from Google Play Store and have fun.

If this guide was helpful to you, do not forget to leave a Thanks message.

Related Guide: Copy files from Blusetacks - BstSharedFolder path for Windows

"Caught unhandled exception. Check log for details" Bluestacks Error while uninstalling

If you are facing this error then DO NOT try to force uninstall Bluestacks using Revo or iOrbit uninstaller.
Step 1: Restart your PC
Step 2: Close Bluestacks from Notification Panel by Right Click and select Close.
Step 3: Open Task Manager, go to Processes tab and if you see any of the Bluestacks processes like 'HD-Agent' or 'HD-Frontend', then right click that process and click 'End Process Tree'.
Step 4: Uninstall 'Bluestacks App Player' first and 'Bluestacks Notification Panel' next. If it still doesn't works then try uninstalling Notification panel first and App Player next.
Step 5: Delete any Bluestacks named folder from: C:\ProgramData\
Step 5: Run CCleaner to clean up any residual files or Registry entries.

Do not forget to say thanks if this works for you.

OnePlus One issue: Unable to switch to Google Now Launcher

Are you getting this message after installing Google Now Launcher: "Trebuchet is currently your default launcher. To try the Google Now Launcher, go to Settings, touch Clear Defaults and press the Home button"?
Or the Clear Defaults option is greyed out for Trebuchet?
Or have you installed Google Now Launcher and it just doesn't shows up in the Home Settings?

Steps to fix this:

1. Install Google Search first, then open it and configure it.
2. Install Google Now Launcher.
3. Restart your phone.
4. Press the home button, voila you get to choose your launcher now.

Copy files from Blusetacks - BstSharedFolder path for Windows

Step 1: Install a FIle Manager in Bluestacks like ES Explorer.
Step 2: Copy files that you want to send to Windows in BlueStacks in this path: sdcard > bstFolder > BstSharedFolder
Step 3: In your Windows Explorer go to this path: C:\ProgramData\BlueStacks\UserData\SharedFolder

NOTE: You can do it the other way as well to send a file from Windows to Bluestacks.

Difference between dba_source and all_source

In short the difference between dba_source and all_source is:

ALL_SOURCE describes the text source (all the code) of the stored objectsaccessible to the current user. Whereas DBA_SOURCE is not limited for a particular user, it describes the text source of all stored objects in the database.

Wait that's not all there is!

Both dba_source and all_source have 5 columns: OWNER, NAME,TYPE, LINE and TEXT. Other then these two there is one more view called USER_SOURCE which describes the text source of the stored objects owned by the current user.

Just tell me how to use it!

Most common way to use these:

1	SELECT * FROM dba_source where TEXT like '%package.procedure/function_name%'

view rawfirst_post hosted with ❤ by GitHub

Source: Oracle Docs for DBA_SOURCE, ALL_SOURCE