How do you retrieve the data from a nullable column ?
Use null indicators. Syntax … INTO :HOSTVAR:NULLIND
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is the difference between CHAR and VARCHAR data types? 06.11.08
CHAR is a fixed length data type. CHAR(n) will take n characters of storage even if you enter less than n characters to that column. For example, "Hello!" w...What is meant by metadata in context of a Datawarehouse and how it is important? 20.09.08
Meta data is the data about data; Business Analyst or data modeler usually capture information about data - the source (where and how the data is originated), n...How do you retrieve the first 5 characters of FIRSTNAME column of EMP table ? 26.07.08
SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;...What are the column name qualifiers ? 14.07.08
A column name qualifier are used as a table designator to avoid ambiguity when the column names referenced exists in more than one table used in the SQL stateme...What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint? 17.05.08
- To modify the datatype of a column the column must be empty. - To add a column with NOT NULL constrain, the table must be empty....In how many ways we can retrieve table records count? How to find the count of records in a dataset ? 14.04.08
foreach(DataTable thisTable in myDataSet.Tables){ // For each row, print the values of each column. foreach(DataRow myRow in thisTable.Rows){...What are column-name qualifiers used ? 09.04.08
Column-name qualifier are used as table designator to avoid ambiguity when the column names referenced exist in more than one table used in the SQL statement. C...How do you insert a record with a nullable column ? 17.03.08
To insert a NULL, move -1 to the null indicator, To insert a valid value, move 0 to the null indicator...How do you display an editable drop-down list? 24.12.06
Displaying a drop-down list requires a template column in the grid. Typically, the ItemTemplate contains a control such as a data-bound Label control to show th...How can you retrieve data from the ResultSet? 26.10.06
JDBC returns results in a ResultSet object, so we need to declare an instance of the class ResultSet to hold our results. The following code demonstrates declar...