GeekArticles 
ProgrammingODP.NET - Working with Bind Variables together with OracleParameter
Author: feeds.feedburner.com |
Published: 10th Apr 2008 |
Visited: 103 times |
Add CommentFiled in: ProgrammingODP.NET - Working with Bind Variables together with OracleParameter
With the help of OracleParameter, you can include bind variables within any SQL statement. These bind variables are nothing but run-time query parameters. The values in the SQL statement are bound at run time when we use bind...
Visit http://www.exforsys.com to read complete article
Read Article Sponsored Links
Related Articles
• Bind Web Services in ESB-Web Services Gateway Bind Web Services in ESB-Web Services Gateway
Since SOI is all about integrating multiple SOA-based systems, web services play a critical role in the integration space. This chapter is all about the importance of web services in integration. We will use the samples to illustrate how to bind web serv ...
• Bind Web Services in ESB-Web Services Gateway Bind Web Services in ESB-Web Services Gateway
Since SOI is all about integrating multiple SOA-based systems, web services play a critical role in the integration space. This chapter is all about the importance of web services in integration. We will use the samples to illustrate how to bind web serv ...
• Shared Variables in ASP.NET Variable types are often misused in ASP.NET applications. This article discusses the various types of shared variables in Delphi ASP.NET applicat ...
• Working with XML Data Using LINQ, a TreeView, and a ListView :: Editing Data
ASP.NET includes a variety of tools for displaying and editing XML documents. A previous article, Working
with XML Data Using LINQ, a TreeView, and a ListView :: Displaying Data, showed how with a TreeView control, a ListView control, an XmlDataSource control,
a LinqDataSource control, and about 50 ...
• Tuning sql with bind variables Hi Tom,
Here is a sample sql from a package used for searching clients. The query is very fast when we remove the "OR" condition "ln_cl_id is null" from the WHERE condition. There are many columns with similiar OR condition, which I have remove ...
• ODP.NET - Working with DataTableReader ODP.NET - Working with DataTableReader
DataTableReader is complementary to a DataTable object, and is mainly used as a type of Data Reader in the disconnected mode. The following is the modified code:
Visit http://www.exforsys.com to read complete article
...
• ODP.NET - Handling Nulls when Working with OracleDataReader ODP.NET - Handling Nulls when Working with OracleDataReader
When we work with OracleDataReader (or for that matter, even with data rows in a data table), we may come across nulls. The following is the efficient way to deal in with such scenarios:
Visit http://www.exforsys.com to read complete arti ...
• ODP.NET - Working with OracleDataAdapter with OracleCommand ODP.NET - Working with OracleDataAdapter together with OracleCommand
In the previous examples, we worked with OracleDataAdapter by directly specifying SQL statements. You can also pass OracleCommand to OracleDataAdapter. This is very useful if you deal with stored procedures (covered in Chapter 5). ...
