PL/SQL architecture defines how the PL/SQL blocks are executed in Oracle. Oracle provides PL/SQL engine that executes the Procedural Language part of a block. When an application program or a…
CSVeda Posts
An important aspect of database systems is creation of external schemas for different users and their needs. These are also known as external views for users. One way of doing…
Subquery in SQL or nesting a query within another query is an extremely important concept in SQL. It allows the programmer to fetch rows from one table depending upon the…
User defined functions in Python are an important method to implement code reusability, modularization and better readability. Arguments make an important part of user defined functions for more flexibility. Function…
SQL UNION, UNION ALL, INTERSECT and MINUS are set operations to help you to get the required data from multiple tables. It is basically application of Set Theory formulas on…
Python offers a huge repository of inbuilt data types and compound data types like lists, strings, arrays etc. As a programmer you create User Defined Data type called Python Class.…
A Join is a powerful tool in SQL for joining multiple tables and extracting data beyond the results returned by simple SQL SELECT using one table. In addition to Inner…
Individual tables in a database are not enough. The most common need of database is to access data from multiple tables. SQL Join is the way to fulfill the need…
Handling PHP files and directories is an important component of PHP programming. If you want to make an application where you want users to upload some documents and save in…
Python is a powerful programming language with a robust library of functions and other resources for faster development. Its inbuilt functions are a great support to any Python Programmer. Sometimes…