by Dinesh Thakur Category: Servlet with MySql Database

The Function 'CONV' will convert numbers between Number bases.

 
by Dinesh Thakur Category: Servlet with MySql Database

To make operations on the database we should know the data formats of the database. When using a ResultSet it is possible to access metadata for the data returned from the query. To obtain an object which encapsulates this metadata, use the method getMetaData () from the ResultSet class. This method returns an object of the ResultSetMetaData class and allows us to determine the number and type of columns.



 
by Dinesh Thakur Category: Servlet with MySql Database

This function will return the natural base of logarithm (e).

 
by Dinesh Thakur Category: Servlet with MySql Database

This Function will Returns the largest integer value that is not Greater than passed numeric expression.

 
by Dinesh Thakur Category: Servlet with MySql Database

The function 'Sort Ascending by Order' will does the sorting order by given command(column) in ascending Order.

 
by Dinesh Thakur Category: Servlet with MySql Database

This function 'AVG'(Average) will present the average of selected numeric column or row.

 
by Dinesh Thakur Category: Servlet with MySql Database

The 'CEIL' Function will return the smallest integer value that not in the passed expression.

 
by Dinesh Thakur Category: Servlet with MySql Database

This Function will return the string argument, left-padded with the specified string.

 
by Dinesh Thakur Category: Servlet with MySql Database

This Function Will Return the substring as specified.

 
by Dinesh Thakur Category: Servlet with MySql Database

This Function will Returns the current UTC date and time.

 
About Dinesh Thakur

Dinesh ThakurDinesh Thakur holds an B.SC (Computer Science), MCSE, MCDBA, CCNA, CCNP, A+, SCJP certifications. Dinesh authors the hugely popular blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps. For any type of query or something that you think is missing, please feel free to Contact us.



Search Content