Oracle Analytic functions compute an aggregate value based on a group of rows called window which determines the range of rows used to perform the calculations for the current row. Following are most used Analytic functions.– RANK, DENSE_RANK and ROW_NUMBER– LAG and LEAD– FIRST_VALUE and LAST_VALUE I would be discussing about RANK, DENSE_RANK and ROW_NUMBER …
RANK, DENSE_RANK and ROW_NUMBER functions in Oracle Read More »
Lead function in oracle LEAD Function in Oracle is a Analytic function which has the ability to compute an expression on the next rows (rows which are going to come after the current row) and return the value to the current row. The general syntax of LEAD is shown below: LEAD (<expr>, <offset>, <default>) OVER …
Today in this post, I would talk about Handling HTML forms with PHP. A simple example would be registration form. Lets create a html form with php We can save this file as myregistration.html and When you will open it you will get below html form. When you fill the data and click the submit …
PHP has lot of in-built Functions for use. PHP also provides opportunity to create use defined function also as available with other programming languages. We will discussing here the various type of User defined PHP Functions What is a function? A function is a piece of code which takes one more input in the form …
We often come across the error ORA-28002 the password will expire in day-to-day activities. This can happen with developers and DBA both. ORA-28002: the password will expire within 7 daysCause: The user’s account is about to about to expire and the password needsto be changed.Action: Change the password or contact the database administrator. Reasons This …
How to resolve ORA-28002: the password will expire Read More »
Here are detailed working on useful PHP string functions strlen() The PHP strlen() function returns the length of a string.The example below returns the length of the string “john”Example <?php echo strlen(“John”); ?> Output 4 Chr() Converts an ASCII value to its equivalent character Example The ASCII value 46 is the & symbol <?php $str …
Useful PHP string functions Read More »
