Solve Your Every Day Technical Problem

Solution: If you are having problems with Street View in Firefox or Internet Explorer, it could be because you are using a Windows 8-style browser. Street View requires Flash Player, and Flash is not currently supported on the Windows UI version of certain browsers. This issue is only specific to Windows 8. To resolve the issue on Internet Explorer 10 for Windows 8: Toggle to the desktop version from the Windows UI: Press the Windows logo key on the bottom left of your keyboard, or Touch or click the desktop tile.  If you don't already have Flash,  download and install  it now.  Open Internet Explorer 10 as a Windows 8 app. To resolve the issue on Firefox: Toggle to the desktop version from the Windows UI: Press the Windows logo key on the bottom left of your keyboard, or Touch or click the desktop tile.  If you don't already have Flash,  download and install  it now.  Open Firefox as a Windows 8 app.  [Source: Google Street View Support ]

Solution: Its helps you to resolves issues that you can face while playing rich media content on embedded Adobe Flash player on Windows 8. Windows 8 provides Internet Explorer in two modes:    *** Modern mode: The version with a new appearance    *** Desktop mode: The version that's more similar to the previous version of internet Explorer Do the following if you find issues with playing rich media: Check if the content can be played in the Desktop mode If content can't be played in the Desktop mode: Disable ActiveX Filtering Enable Flash Player Install the latest version of Flash Player If content can be played in the Desktop mode: Enable updates to the Compatibility View (CV) list To the top Check if the content can be played in the Desktop mode If the content doesn't play in the Modern mode, see if it plays in the Desktop mode by following the steps below: Note : Flash Player is embedded in both versions. The Compatibility View (

Solution: A duplicate row (also called a record) in a list is one where all values in the row are an exact match of all the values in another row. To delete duplicate rows, you filter a list for unique rows, delete the original list, and then replace it with the filtered list. The original list must have column headers. Because you are permanently deleting data, it's a good idea to copy the original list to another worksheet or workbook before using the following procedure. Select all the rows, including the column headers, in the list you want to filter. Tip Click the top left cell of the range, and then drag to the bottom right cell. On the Data menu, point to Filter , and then click Advanced Filter . In the Advanced Filter dialog box, click Filter the list, in place . Select the Unique records only check box, and then click OK . The filtered list is displayed and the duplicate rows are hidden. On the Edit menu, click Office Clipbo

Error 1 Unable to downgrade. Try changing the USB port (the back one of chassis is better) and restart computer. The installed version of iTunes may also be too old. Update iTunes. Error -1 Error occurs when one uses the "last ditch" method for preventing baseband updates on the iPhone 4. The baseband does not get updated using this method. Use FixRecovery to kick it out of recovery mode. Error 2 Sn0wbreeze 1.6 Custom Firmware has a ASR patch problem. Use sn0wbreeze 1.7 or PwnageTool. Device isn't bootable. Error 6 Not enter the downgrading mode, change USB port (the back one of chassis is better) and restart computer. Error 9 Due to asr being patched, the SHA signature is automatically changed and after being resigned the kernel will refuse to use it. Therefore proper kernel patches are required. If necessary kernel patches are not applied, it will fail to load asr and error 9 would occur during restore. Rebooting your PC may resolve this issue. Aslo it can be connection

Solution: ailbreaking your iPhone, iPod Touch or iPod using custom IPSW made by PwnageTool or Sn0wbreeze requires a full firmware restore using iTunes. During the restore process, if you encounter Error 21, it means that you are trying to restore custom IPSW using the recovery mode . To fix this issue, you must put your iDevice into DFU mode . DFU  or  Device Firmware Upgrade  mode allows all iDevices to be restored from any state. The actual difference between recovery and DFU mode is that when you put your iDevice into DFU mode, it do not loads iBoot automatically. When you put your iPhone in recovery mode, it loads iBoot which makes sure that the firmware you are trying to restore is greater or equal to the current firmware. To fix iTunes error 21, you must put your iDevice into DFU mode using the following instructions: Connect your iDevice to your PC or Mac via USB cable and launch iTunes. Hold down the  Home + Power  button for 10 seconds. After 10 seconds,

Solution: In 11g, named notations are also available when functions are called.  There are three ways we can call a procedure or a function: •    Position notation •    Named notation •    Mixed notation Up untill oracle 10g,  functions were called using only positional notations.  In 11g, we can also call functions using named notations or mixed notation. Let us create the following function for our testing purpose. CREATE OR REPLACE FUNCTION TEST_FUNC ( P_COL1 IN NUMBER, P_COL2 IN NUMBER, P_COL3 IN DATE ) RETURN NUMBER AS v_final_value NUMBER; BEGIN SELECT (CASE WHEN P_COL3 < sysdate THEN  P_COL1 + P_COL2 WHEN P_COL3 >= sysdate THEN P_COL1 – P_COL2 ELSE 0 END) INTO v_final_Value FROM DUAL; return v_final_value; END; / Once created, we will invoke the function with three different notations mentioned above. Positional notation : It is very easy to use but it becomes difficult to debug the code when positional values are swiped or placed