Success within U

JSLint – The Java Script Validator

noreply@blogger.com (hsp) — Sat, 24 Jan 2015 01:59:00 +0000

It is a Code Quality tool which makes our java script to be well formed.
JSLint takes a JavaScript source and scans it. If it finds a problem, it returns a message describing the problem and an approximate location within the source. The problem is not necessarily a syntax error, although it often is. JSLint looks at some style conventions as well as structural problems. It does not prove that your program is correct. It just provides another set of eyes to help spot problems.
What it does,
• Missing semicolons at the end of a line.
• Missing curly braces in if, for, while, etc.
• Code that is never run because of a return, throw, continue, or break.
• Case statements in a switch that do not have a break statement. And more…
Using this tool, you can check all your JavaScript source code for common mistakes without actually running the script or opening the web page.
JSLint provides an online tool in which we can validate the scripts without installing any tool.
http://www.jslint.com/
Reference document

JSLint plug-in for Visual StudioJSLint.VS is Add-In for Visual Studio that provides errors in JavaScript during compiling enabling you to spend less time in browser catching bugs and typos.
For more details about the JSLint.VS, http://jslint.codeplex.com/

Show - Hide Elements using JQuery

noreply@blogger.com (hsp) — Thu, 12 Aug 2010 16:50:00 +0000

We can use the following scripts for show / hide elements.
Hide Element
Through CSS -> $(selector).css("display","none")
Through function -> $(selector).hide()

Show Element
Through CSS -> $(selector).css("display","")
Through function -> $(selector).show()

Sample

Markup
<span class = "blue">First</span><br />
<span class = "red">Second</span><br />
<span class = "blue">Third</span><br />
<span class = "blue">Fourth</span><br />
<span class = "green">Fifth</span><br />

Scripts
CSS usage
if ($(".red").is(":visible"))
{
$(".red").css("display", "none");
}
else
{
$(".red").css("display", "");
}

Prototype function
if ($(".red").is(":visible"))
{
$(".red").hide();
}
else
{
$(".red").show();
}

Happy Scripting...

JSLint – The Java Script Validator

noreply@blogger.com (hsp) — Thu, 22 Jul 2010 17:21:00 +0000

JSLint is a Code Quality tool which makes our java script to be well formed.
JSLint takes a JavaScript source and scans it. If it finds a problem, it returns a message describing the problem and an approximate location within the source. The problem is not necessarily a syntax error, although it often is. JSLint looks at some style conventions as well as structural problems. It does not prove that your program is correct. It just provides another set of eyes to help spot problems.
What it does,

• Missing semicolons at the end of a line.
• Missing curly braces in if, for, while, etc.
• Code that is never run because of a return, throw, continue, or break.
• Case statements in a switch that do not have a break statement. And more…

Using this tool, you can check all your JavaScript source code for common mistakes without actually running the script or opening the web page.

JSLint provides an online tool in which we can validate the scripts without installing any tool.

JSLint Reference document

JSLint plug-in for Visual Studio
JSLint.VS is Add-In for Visual Studio that provides errors in JavaScript during compiling enabling you to spend less time in browser catching bugs and typos.
For more details about the JSLint.VS, Click here

Happy Learning…

Useful Cheat Sheets

noreply@blogger.com (hsp) — Wed, 21 Jul 2010 08:03:00 +0000

Cheat sheet is just a pocket reference. We can have the summary about the technology like Regular Expression, SQL Server, HTML & CSS etc. in a single sheet. Get the Cheat Sheets .

Happy Learning....

.NET Framework 4 & Extensions Poster

noreply@blogger.com (hsp) — Tue, 20 Jul 2010 09:11:00 +0000

.NET Framework 4 & Extensions Poster
Click here to get the .NET Framework 4 & Extension's Namespace details.

Happy Learning...

Microsoft Exam test application

noreply@blogger.com (hsp) — Tue, 12 Jan 2010 17:26:00 +0000

Microsoft Exam test application. Try and seek knowledge..

Are You Certifiable

Column Moving in Infragistics Grid

noreply@blogger.com (hsp) — Fri, 08 Jan 2010 02:16:00 +0000

Infragistics provides an interesting feature in UltraWebGrid called Column moving. This feature can be done either on Server side or Client Side.
You can implement this column moving by including the following statement in UltrawebGrid’s Initialize Layout event.

Private Sub UltraWebGridClaimants_InitializeLayout(ByVal sender As Object, ByVal e As Infragistics.WebUI.UltraWebGrid.LayoutEventArgs) Handles UltraWebGridClaimants.InitializeLayout
With UltraWebGridClaimants.DisplayLayout
.XmlLoadOnDemandType = Infragistics.WebUI.UltraWebGrid.XmlLoadOnDemandType.Synchronous
.StationaryMargins = Infragistics.WebUI.UltraWebGrid.StationaryMargins.Header
.AllowColumnMovingDefault = Infragistics.WebUI.UltraWebGrid.AllowColumnMoving.OnClient
.Browser = Infragistics.WebUI.UltraWebGrid.BrowserLevel.Xml
End With

Also you can prevent some columns to not being movable. For this add the following script functions in your script file

// Prevent column moving for "Select" column.
function onBeforeColumnMove(grid, columnId)
{
if(columnId != undefined)
{
var column = igtbl_getColumnById(columnId);
if(column.Key == "Select")
return true;
}
}
// Prevent column moving for "Select" column.
function onColumnDrag(grid, columnId, targetColumnId)
{
if(targetColumnId != undefined)
{
var column = igtbl_getColumnById(targetColumnId);
if(column.Key == "Select")
return true;
}
}

And call these functions in appropriate events on Initialize Layout.

Happy Coding….

Call ServerSide Method from Javascript

noreply@blogger.com (hsp) — Wed, 22 Jul 2009 17:32:00 +0000

Call ServerSide Method from Javascript

Sometimes we would require to get data from server without postback the page.

For example, we need to validate the Date of Birth field in which the value should not be greater than current date. In this scenario, we need to get the server date and then check the entered value with current date.

For doing this without postback, we can move into PageMethods concept in AJAX.

* Create a Method with System.Web.Services.WebMethod Attribute in your code behind.

[System.Web.Services.WebMethod]
public static string GetDate()
{
return DateTime.Now.ToShortDateString();
}

* Add the following scripts within <body> Tag

* Add ScriptManager and make sure the EnablePageMethods should be True.

<asp:ScriptManager ID = "scr" runat = "server" EnablePageMethods = "true"></asp:ScriptManager>

* Call the callMethod from your button click.

Now you can get the server value without postback....

Things we should keep in mind for doing this:

* The server side method should be static method.
* EnablePageMethods should be true in ScriptManager.
* Scripts should be included within <body> tag, not in <head>.

Happy coding...

FREE Cheat Sheets for Developers

noreply@blogger.com (hsp) — Wed, 22 Jul 2009 17:15:00 +0000

FREE Cheat Sheets for Developers

Here is very useful link in which we can download packet reference books for ASP.Net, Java etc...

you can find Core ASP.Net Refcard
here

Its free but you have to register...

Try it!

Happy surfing...

Convert your favorite feeds (Blogs) to PDF and Portable

noreply@blogger.com (hsp) — Thu, 18 Jun 2009 11:25:00 +0000

Convert your favorite feeds (Blogs) to PDF and get via Email frequently

Tabbloid is an online tool that converts the feeds (Blogs) into PDF. Also we can add feeds as much as you want and it will deliver to your email according to the delivery options you set in tabbloid .

Blinking Message in window Status bar

noreply@blogger.com (hsp) — Fri, 12 Jun 2009 09:18:00 +0000

Blinking Message in Window Status Bar

Here is the stuff regarding the blinking message displaying in browser window status bar.

You can check the implementation example here

Happy scripting...

Get Table structure from XML in SQL Server

noreply@blogger.com (hsp) — Thu, 18 Dec 2008 10:39:00 +0000

Get Table structure from XML in SQL Server.

Here is the script to get the table view from XML Document using OPENXML.

declare @doc varchar(1000)
declare @docHandle int
set @doc = '<Employee-Details>
     <Employee>
        <Firstname>Hariharasudhan</Firstname>
        <Lastname>Chandiramurthy</Lastname>
        <DOB>11-July-1982</DOB>
     </Employee>
     <Employee>
        <Firstname>Suguna</Firstname>
        <Lastname>Ramamurthy</Lastname>
        <DOB>02-September-1979</DOB>
     </Employee>
     <Employee>
        <Firstname>Pasupathy</Firstname>
        <Lastname>Thandavan</Lastname>
        <DOB>01-August-1982</DOB>
     </Employee>
   </Employee-Details>'
exec sp_xml_preparedocument @docHandle output, @doc
select * from openxml (@docHandle, '/Employee-Details/Employee', 1)
     with (FirstName varchar(100) './Firstname/text()'
        , LastName varchar(100) './Lastname/text()'
        , Date_Of_Birth varchar(100) './DOB/text()')

Check the given Url is Valid

noreply@blogger.com (hsp) — Wed, 17 Dec 2008 09:22:00 +0000

Check the given Url is Valid

In some situation we want to check the particular url (eg:google.com) is valid or not through programatically.

Here is the code for checking the url.
urlcheck.aspx

urlcheck.aspx.cs

protected void ButtonClick(object sender, EventArgs e)
{
try
{
System.Net.HttpWebRequest objReq = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(txtUrl.Text);
System.Net.HttpWebResponse objRes = (System.Net.HttpWebResponse)objReq.GetResponse();
if (objRes.StatusCode == System.Net.HttpStatusCode.OK)
{
lblMsg.Text = "Url is Valid";
lblMsg.ForeColor = System.Drawing.Color.SeaGreen;
}
else
{
lblMsg.Text = "Url is not Valid";
lblMsg.ForeColor = System.Drawing.Color.Red;
}
objRes.Close();
}
catch (Exception ex)
{
lblMsg.Text = ex.Message.ToString();
lblMsg.ForeColor = System.Drawing.Color.Red;
}
}

Check All Option in TreeView control

noreply@blogger.com (hsp) — Tue, 16 Dec 2008 16:05:00 +0000

Javascript : Check All Option in TreeView control
ASP.Net 2.0 Provides Tree view control with more features. It gives an option to select items through checkboxes. But there is no option for select all in a single click.

We can do that using Javascript. Here the stuff....

Here is the controls scripts.

Awesome Features of VS.NET 2008

noreply@blogger.com (hsp) — Fri, 12 Dec 2008 14:47:00 +0000

Awesome Features of VS.NET 2008
VS.NET 2008 (Framework 3.5) released with wonderful features.
Look on this
VS.NET 2008 Features

Set Password Textbox value dynamically

noreply@blogger.com (hsp) — Mon, 17 Nov 2008 09:38:00 +0000

Set Password Textbox value dynamically
Usually when we need to set values for textboxes dynamically, we just assign values to the Textbox's Text property like,

TextBox1.Text = "hsp";

But the above statement will not work, if the Textbox mode is "Password".
Suppose we want to set the values of Password mode textbox, we can use the following code.

TextBox1.Attributes["value"] = "hsp";

Also, when the page is getting postback, the values in Password textboxes will be cleared. But you can retain the text in password textboxes.
Add the following code in Page_Load event of the page.

TextBox1.Attributes.Add("value", TextBox1.Text);

Find N-th highest record in SQL Server

noreply@blogger.com (hsp) — Fri, 14 Nov 2008 16:02:00 +0000

Find N-th highest record in SQL Server
The following list of queries can be used to get N-th maximum record from table in SQL Server.
Here, let we consider a simple employee table. And we need to get the employee details whose salary is the 2nd maximum of the table.

Option: 1

Select top 1 * from employee where salary not in (select max(salary) from employee ) order by salary desc

Option:2

Select top 1 * from (select top 2 * from employee order by salary desc) emp order by emp.salary

Option: 3

Select * from employee e1 where 1 = (select count(distinct(e2.salary)) from employee e2 where e2.salary > e1.salary)

Build components (dll) into Multiple Locations

noreply@blogger.com (hsp) — Fri, 07 Nov 2008 06:43:00 +0000

Build components (dll) into Multiple Locations
Usually when we build a component (dll), the result dll will be stored in path which is specified in OutputPath of that project Properties.

By default the output path is “bin\debug” of the particular project.
We can change this path to our required one.

Suppose, in some solutions, we may use the same dll more than one projects. For this, we need to copy the dll and paste in specific location. This may cause some problem if we forgot to copy and paste. So, we need some automatic process for this.

Thank fully Visual studio provides a concept called Build Events.

In that, we can include some DOS command through Macros. The Macros contains some default keys which has values like Target path etc..

Here For example I want to stored the dll into “d:\test\” folder, we need to add XCOPY command with macros.

xcopy "$(TargetPath)" "d:\test\" /d /y

XCopy Syntax

Copies files and directory trees.

XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W]
[/C] [/I] [/Q] [/F] [/L] [/G] [/H] [/R] [/T] [/U]
[/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z]
[/EXCLUDE:file1[+file2][+file3]...]

source Specifies the file(s) to copy.
destination Specifies the location and/or name of new files.
/A Copies only files with the archive attribute set,
doesn't change the attribute.
/M Copies only files with the archive attribute set,
turns off the archive attribute.
/D:m-d-y Copies files changed on or after the specified date.
If no date is given, copies only those files whose
source time is newer than the destination time.
/EXCLUDE:file1[+file2][+file3]...
Specifies a list of files containing strings. Each string
should be in a separate line in the files. When any of the
strings match any part of the absolute path of the file to be
copied, that file will be excluded from being copied. For
example, specifying a string like \obj\ or .obj will exclude
all files underneath the directory obj or all files with the
.obj extension respectively.
/P Prompts you before creating each destination file.
/S Copies directories and subdirectories except empty ones.
/E Copies directories and subdirectories, including empty ones.
Same as /S /E. May be used to modify /T.
/V Verifies each new file.
/W Prompts you to press a key before copying.
/C Continues copying even if errors occur.
/I If destination does not exist and copying more than one file,
assumes that destination must be a directory.
/Q Does not display file names while copying.
/F Displays full source and destination file names while copying.
/L Displays files that would be copied.
/G Allows the copying of encrypted files to destination that does
not support encryption.
/H Copies hidden and system files also.
/R Overwrites read-only files.
/T Creates directory structure, but does not copy files. Does not
include empty directories or subdirectories. /T /E includes
empty directories and subdirectories.
/U Copies only files that already exist in destination.
/K Copies attributes. Normal Xcopy will reset read-only attributes.
/N Copies using the generated short names.
/O Copies file ownership and ACL information.
/X Copies file audit settings (implies /O).
/Y Suppresses prompting to confirm you want to overwrite an
existing destination file.
/-Y Causes prompting to confirm you want to overwrite an
existing destination file.
/Z Copies networked files in restartable mode.

The switch /Y may be preset in the COPYCMD environment variable.

After adding the command line save the build Events.

Now Build your dll. The dll will be stored in “bin/debug” path of the project folder and also in “d:\test\” folder. (Make sure d: drive should contain test folder. Otherwise it gives an error)

Access / Consume Web Service using JavaScript

noreply@blogger.com (hsp) — Fri, 31 Oct 2008 12:45:00 +0000

Access / Consume Web Service using JavaScript
Web Service is a distributed application that provides information to client irrespective of Platform, Languages. There are number of free web services available (webservicex) in universe.
We can call the web service method through JavaScript functions. To doing this, we need to concentrate the following three points,
   1.Download Web Service behavior (HTC – HTML Component) file from Microsoft and include that file into your project.
   2.Create a Proxy Web service for accessing the original web service (Since, Browser provides security issue while calling the original web service directly.)
   3.Create a Page in which, we need to add the code for accessing web service.

For explaining the concept I am using one of the free services which are available in www.webservicex.net. The service is used to validate whether the entered email address is valid one or not.

1.Web Service Behavior
   The WebService behavior enables client-side script to invoke remote methods exposed by Web Services, or other Web servers, that support the SOAP and Web Services Description Language (WSDL) 1.1. This behavior provides developers the opportunity to use and leverage SOAP, without requiring expert knowledge of its implementation. The WebService behavior supports the use of a wide variety of data types, including intrinsic SOAP data types, arrays, objects, and XML data. The WebService behavior is implemented with an HTML Component (HTC) file as an attached behavior, so it can be used in Microsoft Internet Explorer 5 and later versions.
For more information click here
You can download the HTC file from Microsoft and include that file into your project.

2.Create a Proxy Web Service
   While using the remote web service directly, the browser prompts security issue like,

"This page is accessing information that is not under its control. This poses a security risk "

To avoid this, we need to create proxy service in our local, to access the remote web service.
For creating proxy service we need to do the following steps.
a)Get the particular web service’s WSDL as .cs file and Compile it. Using WSDL.exe command, we can get the .cs file of web service WSDL like,
Go to Visual studio command prompt,
C:\WSDL http://www.webservicex.net/ValidateEmail.asmx?WSDL
The validateemail.cs file will be created. Now we need to compile this file into dll.
C:\csc /t:library /out:WS_ValidateEmail.dll validateemail.cs
The validateemail.dll will be create. Now Copy the dll file and paste into bin folder of your project. Make the reference of this dll via Add reference.

b)Create Proxy Web Service and call the original web service via newly created dll.
Create a proxy web service by click File->New->File and select Web Service. Name the file as “ProxyWS.asmx” and add the following function into the file.

[WebMethod]
public bool IsValidEmail(string email)
{
ValidateEmail objWS = new ValidateEmail();
bool result = objWS.IsValidEmail(email);
return result;
}

3.Create Page to access Web service.
Create a page and add the following scripts.

Add the following code in <body> section,

<form id="form1" runat="server">
<div id = "divWS" style="BEHAVIOR: url(webservice.htc)">
</div>
<table>
<tr>
<td> Enter the Email Address :</td>
<td> <input type = "text" id = "txtEmail" /> </td>
</tr>
<tr>
<td colspan = "2">
<span id = "sLoad" style="visibility:hidden">Loading</span>
<input type = "button" id = "btnValidate" value = "Validate" onclick = "initWS();" />
</td>
</tr>
</table>
</form>

ORACLE : Minutes between Two dates

noreply@blogger.com (hsp) — Wed, 22 Oct 2008 08:56:00 +0000

ORACLE : Minutes between Two dates
The following function is returning the No. of minutes between two specific dates.

FUNCTION F_GET_MINUTES_DIFF
(
   dSTARTDATE    DATE,
   dENDDATE    DATE
) RETURN NUMBER
IS
   v_MINSDIFF   NUMBER(5);
BEGIN
   SELECT
    ROUND(
     (((TRUNC(dSTARTDATE) + 1) - dSTARTDATE) * 1440)
     + ((dENDDATE - TRUNC(dENDDATE)) * 1440)
     + (((TRUNC(dENDDATE) - TRUNC(dSTARTDATE))-1) * 1440),
    2) INTO v_MINSDIFF
   FROM
    DUAL;
   RETURN v_MINSDIFF;
END F_GET_MINUTES_DIFF;

Example to call the function

DECLARE
   MINSDIFF NUMBER(5);
BEGIN
   MINSDIFF := F_GET_MINUTES_DIFF(TO_DATE('21-10-2008 12:00:01 AM', 'dd-mm-yyyy hh:mi:ss pm'), SYSDATE);
   DBMS_OUTPUT.PUT_LINE(MINSDIFF);
END;

Check Prime numbers

noreply@blogger.com (hsp) — Mon, 20 Oct 2008 05:29:00 +0000

Function to Check Prime number

Here a simple function to check whether the given number is Prime or not.

private bool isPrime(int tmp)
{
   if (tmp <= 3)
    return true;
   else
   {
    for (int cnt = 2; cnt < tmp; cnt++)
    {
     if (tmp % cnt == 0)
      return false;
     }
    return true;
   }
}

Enumerations in C#.Net

noreply@blogger.com (hsp) — Fri, 17 Oct 2008 06:59:00 +0000

Enumerations in C#.Net

An enum is a value type with a set of related named constants often referred to as an enumerator list.

Here I am using the Build in Enum type named DbType, which returns all the types.

Get value of particular index

DbType value = (DbType)10;

The Result will be Int16

Get index of particular value,

int index = (int)DbType.Int16;

The Result will be 10

ORACLE : VARRAYS

noreply@blogger.com (hsp) — Wed, 15 Oct 2008 12:38:00 +0000

VARRAYS IN ORACLE
Varrays (short for variable-size arrays) hold a fixed number of elements. They use sequential numbers as subscripts. You can define equivalent SQL types, allowing varrays to be stored in database tables. They can be stored and retrieved through SQL, but with less flexibility than nested tables.

Note:
Varrays are a good choice when the number of elements is known in advance, and when the elements are usually all accessed in sequence. When stored in the database, varrays retain their ordering and subscripts.

For Example

----------- CREATING VARRAY TYPE ------------
------- 10 rows of varchar2(25) column
CREATE OR REPLACE
TYPE TYPE_VARRAY AS VARRAY(10) OF VARCHAR2(25);
---------------------------------------------

--- CREATEING TABLE WITH VARRAY COLUMN ------
CREATE TABLE TBL_WITH_VARRAY
(
ID NUMBER
, ADDEDDATE DATE
, DATA TYPE_VARRAY
)
---------------------------------------------

DESC TBL_WITH_VARRAY
SELECT * FROM USER_TYPES

SELECT * FROM TBL_WITH_VARRAY

INSERT INTO TBL_WITH_VARRAY
(
ID
, ADDEDDATE
, DATA
) VALUES
(
1
, SYSDATE
, TYPE_VARRAY('1','2','3','4','5')
);
/
INSERT INTO TBL_WITH_VARRAY
(
ID
, ADDEDDATE
, DATA
) VALUES
(
2
, SYSDATE
, TYPE_VARRAY('A','B','C','D','E','F','G','H','I','J','K')
);
---[1]: (Error): ORA-22909: exceeded maximum VARRAY limit
INSERT INTO TBL_WITH_VARRAY
(
ID
, ADDEDDATE
, DATA
) VALUES
(
2
, SYSDATE
, TYPE_VARRAY('A','B','C','D','E','F','G','H','I','J')
);

SET SERVEROUTPUT ON;

DECLARE
TMP_VARRAY TYPE_VARRAY;
BEGIN
SELECT DATA INTO TMP_VARRAY FROM TBL_WITH_VARRAY WHERE ID = 2;
DBMS_OUTPUT.PUT_LINE('NO.OF RECORDS : ' || TMP_VARRAY.COUNT);
FOR CNT IN TMP_VARRAY.FIRST..TMP_VARRAY.LAST
LOOP
DBMS_OUTPUT.PUT_LINE(TMP_VARRAY(CNT));
END LOOP;
END;
/

DECLARE
TMP_VARRAY TYPE_VARRAY;
BEGIN
SELECT DATA INTO TMP_VARRAY FROM TBL_WITH_VARRAY WHERE ID = 2;
DBMS_OUTPUT.PUT_LINE('NO.OF RECORDS : ' || TMP_VARRAY.COUNT);
FOR CNT IN REVERSE TMP_VARRAY.FIRST..TMP_VARRAY.LAST
LOOP
DBMS_OUTPUT.PUT_LINE(CNT || ' : ' || TMP_VARRAY(CNT));
END LOOP;
END;

------- CREATING OBJECT TYPE --------
CREATE OR REPLACE
TYPE TYPE_OBJ_TEST AS OBJECT
(
CODE NUMBER
, VAL VARCHAR2(25)
);
-------------------------------------

----- CREATING VARRAY OF OBJECT -----
CREATE OR REPLACE
TYPE TYPE_VARRAY_OBJ IS VARRAY(10) OF TYPE_OBJ_TEST;
-------------------------------------

----- CREATING TABLE WITH OBJECT VARRAY ----
CREATE TABLE TBL_WITH_VARRAY1
(
ID NUMBER
, ADDEDDATE DATE
, DATA TYPE_VARRAY_OBJ
)
--------------------------------------------

DESC TBL_WITH_VARRAY1
SELECT * FROM TBL_WITH_VARRAY1

INSERT INTO TBL_WITH_VARRAY1
(
ID
, ADDEDDATE
, DATA
) VALUES
(
1
, SYSDATE
, TYPE_VARRAY_OBJ (TYPE_OBJ_TEST(91,'IND'), TYPE_OBJ_TEST(65,'SG'))
);

INSERT INTO TBL_WITH_VARRAY1
(
ID
, ADDEDDATE
, DATA
) VALUES
(
2
, SYSDATE
, TYPE_VARRAY_OBJ(TYPE_OBJ_TEST(91,'IND'), TYPE_OBJ_TEST(65,'SG'),TYPE_OBJ_TEST(11,'ABC'), TYPE_OBJ_TEST(22,'DEF'))
);

SET SERVEROUTPUT ON;

DECLARE
TMP_VARRAY TYPE_VARRAY_OBJ;
TMP_OBJ TYPE_OBJ_TEST;
BEGIN
SELECT DATA INTO TMP_VARRAY FROM TBL_WITH_VARRAY1 WHERE ID = 2;
DBMS_OUTPUT.PUT_LINE('NO.OF RECORDS : ' || TMP_VARRAY.COUNT);
FOR CNT IN TMP_VARRAY.FIRST..TMP_VARRAY.LAST
LOOP
TMP_OBJ := TMP_VARRAY(CNT);
DBMS_OUTPUT.PUT_LINE(TMP_OBJ.CODE || ' - ' || TMP_OBJ.VAL);
END LOOP;
END;

For Syntax and more information

ORACLE : NESTED TABLES

noreply@blogger.com (hsp) — Wed, 15 Oct 2008 12:27:00 +0000

NESTED TABLES in ORACLE
Nested tables hold an arbitrary number of elements. They use sequential numbers as subscripts. You can define equivalent SQL types, allowing nested tables to be stored in database tables and manipulated through SQL.
Within the database, nested tables can be considered one-column database tables. Oracle stores the rows of a nested table in no particular order. But, when you retrieve the nested table into a PL/SQL variable, the rows are given consecutive subscripts starting at 1. That gives you array-like access to individual rows.
PL/SQL nested tables are like one-dimensional arrays. You can model multi-dimensional arrays by creating nested tables whose elements are also nested tables.
Nested tables differ from arrays in two important ways:
1. Arrays have a fixed upper bound, but nested tables are unbounded. So, the size of a nested table can increase dynamically
2. Arrays must be dense (have consecutive subscripts). So, you cannot delete individual elements from an array. Initially, nested tables are dense, but they can become sparse (have nonconsecutive subscripts). So, you can delete elements from a nested table using the built-in procedure DELETE. That might leave gaps in the index, but the built-in function NEXT lets you iterate over any series of subscripts.

Note:
Nested tables can be stored in a database column, so Nested tables are appropriate for important data relationships that must be stored persistently.

Example scripts

----- Creating Nested Tables type ----------------------
---- Unlimited rows of varchar2(25) column.
CREATE OR REPLACE
TYPE TYPE_NESTED_TABLES IS TABLE OF VARCHAR2(25);
/
---------------------------------------------------------

-------- Creating table with nested table types ---------
CREATE TABLE TBL_WITH_NESTEDTABLES
(
ID NUMBER
, ADDEDDATE DATE
, DATA TYPE_NESTED_TABLES
) NESTED TABLE DATA STORE AS NESTED_TABLES_TAB
/
---------------------------------------------------------

DESC TBL_WITH_NESTEDTABLES
DESC NESTED_TABLES_TAB

SELECT * FROM USER_NESTED_TABLES
SELECT * FROM USER_TAB_COLS WHERE TABLE_NAME = 'TBL_WITH_NESTEDTABLES'
SELECT * FROM USER_TYPES

INSERT INTO TBL_WITH_NESTEDTABLES
(
ID
, ADDEDDATE
, DATA
) VALUES
(
1
, SYSDATE
, TYPE_NESTED_TABLES('A','B','C')
);
/

INSERT INTO TBL_WITH_NESTEDTABLES
(
ID
, ADDEDDATE
, DATA
) VALUES
(
2
, SYSDATE
, TYPE_NESTED_TABLES('1','2','3','4','5')
);
/
INSERT INTO TBL_WITH_NESTEDTABLES
(
ID
, ADDEDDATE
, DATA
) VALUES
(
3
, SYSDATE
, TYPE_NESTED_TABLES('AA','BB','CC','DD','EE','FF')
);
/

SELECT * FROM TBL_WITH_NESTEDTABLES

SET SERVEROUTPUT ON;

DECLARE
TMP_TYPE TYPE_NESTED_TABLES;
BEGIN
SELECT DATA INTO TMP_TYPE FROM TBL_WITH_NESTEDTABLES WHERE ID = 1;
DBMS_OUTPUT.PUT_LINE('NO.OF RECORDS : ' || TMP_TYPE.COUNT);
FOR CNT IN TMP_TYPE.FIRST..TMP_TYPE.LAST
LOOP
DBMS_OUTPUT.PUT_LINE(TMP_TYPE(CNT));
END LOOP;
END;
/

DECLARE
TMP_TYPE TYPE_NESTED_TABLES := TYPE_NESTED_TABLES('TN','AP','KA','KE','UP');
BEGIN
UPDATE TBL_WITH_NESTEDTABLES SET DATA = TMP_TYPE WHERE ID = 1;
END;
/

SELECT
T1.ID
, T1.ADDEDDATE
, T2.*
FROM
TBL_WITH_NESTEDTABLES T1,
TABLE(T1.DATA) T2

For More information

Partial Update using Prototype JavaScript Framework

noreply@blogger.com (hsp) — Tue, 14 Oct 2008 09:33:00 +0000

Partial Update using Prototype JavaScript Framework
Prototype is a JavaScript Framework that aims to ease development of dynamic web applications.
Featuring a unique, easy-to-use toolkit for class-driven development and the nicest Ajax library around, Prototype is quickly becoming the code base of choice for web application developers everywhere.
For downloads and details,