Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SQL Articles
Page 12 of 12
Print pyramid of tutorialspoint in PL/SQL
PL/SQL stands for “Procedural Language extension to SQL” . It is the mixture of SQL and Procedural features provided by programming language. It was developed by Oracle Corporation in the late 1980s as procedural extension language for SQL and the Oracle relational database.PL/SQL programs consists of blocks that can be nested and a block structure look likes this −DECLARE -- it contains declaration statements BEGIN -- It contains executable statements EXCEPTIONS -- It contains exception handling statements END;ExampleIn PL/SQL single-line comments begin with double hyphen(--) and Multi-line comments begin with a slash-asterisk ( /* ) and end ...
Read MoreHow to execute DELETE SQL in a JSP?
The tag executes an SQL statement that does not return data; for example, SQL INSERT, UPDATE, or DELETE statements.AttributeThe tag has the following attributes −AttributeDescriptionRequiredDefaultsqlSQL command to execute (should not return a ResultSet)NoBodydataSourceDatabase connection to use (overrides the default)NoDefault databasevarName of the variable to store the count of affected rowsNoNonescopeScope of the variable to store the count of affected rowsNoPageExampleTo start with basic concept, let us create a simple table Employees table in the TEST database and create few records in that table as follows −Step 1Open a Command Prompt and change to the installation directory as follows ...
Read MoreSQL Script vs Graphical Calcualtion views in SAP HANA
In SAP HANA Modeling, Graphical Information Views are faster as compared to SQLScript in almost every scenario and also Graphical Information Views are easier for others to understand, remodel and change.There are scenarios where you need SQLScript, but it shouldn’t be viewed as a general-purpose solution to modeling problems.Note:It is never recommended that you code a Calculation View with SQL Script and use it inside another Calculation View with CE Functions as it results in a very bad performance.
Read MoreExecuting a SQL query in SAP HANA Studio
To run the query, click on green arrow button on top right corner or press F8.
Read More