User:Himanshu.Gajjar

Himanshu Gajjar
http://www.facebook.com/HimanshuGajjar himanshu.gajjar@gmail.com

Good Artilce to Read About AJAX

1. Cool UI Templating Technique to use with ASP.NET AJAX for non-UpdatePanel scenarios(From ScottGu's Blog)

http://weblogs.asp.net/scottgu/archive/2006/10/22/Tip_2F00_Trick_3A00_-Cool-UI-Templating-Technique-to-use-with-ASP.NET-AJAX-for-non_2D00_UpdatePanel-scenarios.aspx

JavaScript Tip

1. For assigning class attribute for a control in JavaScript, use document.getElementById('controlName').className = 'Css class name'

2. To move list items in multiselect list

ORACLE Related:

CURSOR_SHARING

http://www.psoug.org/reference/cursor_sharing.html

To find out current setting

ORA-00937: not a single-group group function Error can start happening if CURSOR_SHARING is not set to EXACT on the Oracle server.

System Setting Syntax

Session Setting Syntax

V$SQL V$SQL lists statistics on shared SQL area without the GROUP BY clause and contains one row for each child of the original SQL text entered. Statistics displayed in V$SQL are normally updated at the end of query execution. However, for long running queries, they are updated every 5 seconds. This makes it easy to see the impact of long running SQL statements while they are still in progress.

Viewing Information About Database Links

DBA_DB_LINKS Lists all database links in the database.

ALL_DB_LINKS Lists all database links accessible to the connected user.

USER_DB_LINKS Lists all database links owned by the connected user.

The following views show the database link connections that are currently open in your current session:

V$DBLINK - Lists all open database links in your session, that is, all database links with the IN_TRANSACTION column set to YES.

GV$DBLINK Lists all open database links in your session along with their corresponding instances. This view is useful in an Oracle Real Application Clusters configuration.

For localization tutorials and videos,

http://weblogs.asp.net/scottgu/archive/2006/05/30/ASP.NET-2.0-Localization-_2800_Video_2C00_-Whitepaper_2C00_-and-Database-Provider-Support_2900_.aspx

also refer to these tutorials

http://www.ondotnet.com/pub/a/dotnet/2005/08/08/localizingaspnet20.html

http://www.codeproject.com/useritems/localization.asp