Menu

Cursor in PLSQL

 The cursor is a private work area for an SQL statement, when the SQL statement is executed in PL/SQL block, the Oracle engine assigns a private work area for that statement. The cursor stores the statement and result after execution.

There are two types of Cursor implicit cursor and explicit cursor.

Example of Implicit Cursor

DECLARE

    var datatype

BEGIN

    select * from table; // Your SQL statement

END;


Example of Explicit Cursor

DECLARE

             CURSOR cursor_name is

                select * from table;    // Your SQL statement 

BEGIN

    OPEN cursor_name; 

        FETCH cursor_name  // Your SQL statement

            CLOSE cursor_name; 

END;


Reference

 Cursor overview | Oracle Doc

AEM Dispatcher RewriteRule Flags

While working with the AEM dispatcher there are too many configurations and rules we have to handle to deliver the right content and hide the secure data of the system. 


The behavior of RewriteRule can be modified by RewriteRule flags. There are ample flags available that help us to modify the behavior of the rewrite rule, those flags get added in the form of an Array object at the end of the rewrite rule line. Below is the syntax with an example.

Syntax of AEM Dispatcher RewriteRule

RewriteRule pattern target [Flag1,Flag2,Flag3]

e.g.

    


References

1. Apache RewriteRule Flags

2. Apache Module mod_rewrite

Plato | A Greek Philosopher

Plato is the well-known Greek Philosopher and student of Socrates. Socrates considered that unexamined life is not worth living and argues that virtue is knowledge. Plato has influenced by Socrates in pursuit of knowledge against sophists. He influenced the western philosophy than any philosopher. Plato’s interests were broad, including the study of knowledge, mathematics, ultimate reality, ethics, and politics. He thought that ultimate reality of things was given by their ‘forms.’ For Plato, the real world is unchanging, eternal, and beyond our senses. We can understand reality though intellectual study. The aim of philosophy is to get away from the world of sense and desire to the higher realm of existence of the Forms. The form of an object is its essence, and is what makes it what it is. Examples of forms include beauty, justice, numbers, and shapes. We can know about ultimate reality (the world of forms) through the use of our intellect.

Our senses do not tell us much about ultimate reality. For Plato, mathematics is the paradigm of knowledge, since it is done through intellectual reasoning independent of the apparent world around us, and tells us eternal unchanging truths. In The Republic Plato says that the soul has three parts, corresponding to reason, emotion, and desire. He also thinks that the soul (or at least part of it) is immortal, and can be reincarnated. Plato thinks that only those who understand the nature of goodness are fit to rule in society. Most people do not understand goodness. The rulers should try to maximize the happiness of society, by imposing strict censorship of ideas and of artistic expression. He saw no connection between happiness and individual liberty. He wants to show that there is absolute truth, and absolute right and wrong, and that human beings are not the measure of all things.