Skip to main content

How to Upgrade Your RAM and SSD on Ubuntu: A Complete Guide 2025 - 2026 midway

Post a Comment

What are Cursors?

What are Cursors?
A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it. This temporary work area is used to store the data retrieved from the database, and manipulate this data. A cursor can hold more than one row, but can process only one row at a time. The set of rows the cursor holds is called the active set.
There are two types of cursors in PL/SQL:
Implicit cursors:
These are created by default when DML statements like, INSERT, UPDATE, and DELETE statements are executed. They are also created when a SELECT statement that returns just one row is executed.
Explicit cursors:

They must be created when you are executing a SELECT statement that returns more than one row. Even though the cursor stores multiple records, only one record can be processed at a time, which is called as current row. When you fetch a row the current row position moves to next row. 

Comments

Post a Comment

Popular posts from this blog

Shopify fully custom contact section block on home page

Tech Easy Solutions Shopify fully custom contact section block on home page <section class="contact-information" >       <!--<div class="left-shape">         <img src="images/left-shape.png" class="img-fluid">       </div>-->       <div class="container c-container">         <div class="row">           <div class="col-lg-6 col-md-6 col-sm-12 col-12">             <div class=" contact-us">                         {% form 'contact' %}                       {% if form.posted_successfully? %}                        <center> <p class="note form-success">                   ...
Post a Comment
Read more

Fixing PHP 8.2 zip Extension Error on Ubuntu 25 for Laravel 10,11,12 Shopify Apps

Tech Easy Solutions           Solution : How to Fix PHP 8.2 zip Extension Error on Ubuntu 25 Since Ubuntu 25’s PPAs don’t yet support this extension directly, there are three approaches to fix this: server  / local Ubuntu   Compile the Zip Extension from Source (Recommended) Install development packages: $ sudo apt-get install php8.2-dev libzip-dev build-essential unzip Install the zip extension via PECL:  $ sudo pecl install zip Enable the extension:  $ echo "extension=zip.so" | sudo tee /etc/php/8.2/cli/conf.d/20-zip.ini $ echo "extension=zip.so" | sudo tee /etc/php/8.2/fpm/conf.d/20-zip.ini Restart PHP services : $ sudo systemctl restart php8.2-fpm Verify $ :  php -m | grep zip ____________________________________________________ Result :  Error tracer : Why This Error Happens When running a Laravel 12 Shopify project on Ubuntu 25, you might see an error like: php8 .2 - zip : Depends: libzip4t64 (>= 1....
Post a Comment
Read more

Fatal error: Allowed memory size of 67108864 bytes exhausted wordpress

Fatal error: Allowed memory size of 67108864 bytes exhausted wordpress open your file manager then goto wordpress directory wp-include -> then   default-constants.php change a memory size values 64 to 256 or your need modifications see below light blue color  in default-constants.php   <?php /**  * Defines constants and global variables that can be overridden, generally in wp-config.php.  *  * @package WordPress  */ /**  * Defines initial WordPress constants  *  * @see wp_debug_mode()  *  * @since 3.0.0  *  * @global int $blog_id  */ function wp_initial_constants() {  global $blog_id;  /**#@+   * Constants for expressing human-readable data sizes in their respective number of bytes.   *   * @since 4.4.0   */  define( 'KB_IN_BYTES', 1024 );  define( 'MB_IN_BYTES', 1024 * KB_IN_BYTES );  define( 'GB_IN_BYTES', 1024 * MB_IN_BYTES ); ...
1 comment
Read more