Used UNIX / Linux Commands (With Examples) 1. tar command examples Create a new tar archive. $ tar cvf archive_name.tar dirname/ Extract from an existing tar archive. $ tar xvf archive_name.tar View an existing tar archive. $ tar tvf archive_name.tar...
What is difference between DELETE and TRUNCATE commands? Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the...
Used UNIX / Linux Commands (With Examples) 1. tar command examples Create a new tar archive. $ tar cvf archive_name.tar dirname/ Extract from an existing tar archive. $ tar xvf archive_name.tar View an existing tar archive. $ tar tvf archive_name.tar...
Customers Table Contracts Table Syntax The syntax to create a stored procedure in SQL Server (Transact-SQL) is: CREATE { PROCEDURE | PROC } [schema_name.]procedure_name [ @parameter [type_schema_name.] datatype [ VARYING ] [ = default ] [ OUT | OUTPUT...
SQL SERVERDATA TYPES The following is a list of datatypes available in SQL Server (Transact-SQL), which includes string, numeric, and date/time datatypes. STRING DATATYPES The following are the String Datatypes in SQL Server (Transact-SQL): NUMERIC DATATYPES...
SQL SERVER FUNCTIONS ABS ASCII AVG CASE CAST CEILING CHAR CHARINDEX COALESCE CONCAT Concat with + CONVERT COUNT CURRENT_TIMESTAMP CURRENT_USER DATALENGTH DATEADD DATEDIFF DATENAME DATEPART DAY FLOOR GETDATE GETUTCDATE ISDATE ISNULL ISNUMERIC LEFT LEN...
PRAGMA RESTRICT_REFERENCES Oracle PRAGMA RESTRICT_REFERENCES uses to control the side effects of PL/SQL Subprograms. Every PL/SQL Subprograms must follow some rules in terms of transaction control and security. What is PRAGMA PRAGMA is an instruction...
LEAD function Oracle by sqlandplsql LEAD function used to find next row value within the same table. It is an example of analytical function. Syntax :- LEAD(column, context, default) over partition clause context – number of rows to go forward. Default...
LAG function Oracle by sqlandplsql LAG function used to find previous row value within the same table. It is an example of analytical function. Syntax :- LAG(column, context, default) over partition clause context – number of rows to go backward. Default...
FIRST_VALUE and LAST_VALUE analytical functions by sqlandplsql Both FIRST_VALUE and LAST_VALUE are analytical functions in Oracle. FIRST_VALUE It is used to find the first value from a ordered set of values. Syntax :- 1) FIRST_VALUE(column) over(partition...
