Search
 
SCRIPT & CODE EXAMPLE
 

SQL

declaring variables in pl sql

# variableName variableType := Value;
# EG :
DECLARE
	name varchar(15) := 'Name';
BEGIN
	DBMS_OUTPUT.PUT_LINE(name)
END;

Comment

PREVIOUS NEXT
Code Example
Sql :: primary key multiple 
Sql :: mysql trim spaces 
Sql :: get time component of datetime sql 
Sql :: SQL Multiple Cases 
Sql :: how to check if a column is null in sql 
Sql :: show database cmd 
Sql :: change data type postgresql 
Sql :: mysql get all tables from a specific database 
Sql :: mysql backup database command line 
Sql :: sqlite3 import csv 
Sql :: import sql dump into postgresql database 
Sql :: activate log mariadb 
Sql :: between sql 
Sql :: truncate all tables 
Sql :: alter table myisam to innodb 
Sql :: mysql to uppercase 
Sql :: rename column in table sql 
Sql :: mysql count by month 
Sql :: alternative for LIMIT sql 
Sql :: postgresql random phone number 
Sql :: mysql min value row 
Sql :: pagination in sql 
Sql :: sequence postgresql 
Sql :: call postgres function 
Sql :: c# select Mysql 
Sql :: NVL() Functions 
Sql :: plpgsql if statement 
Sql :: SQL column name Oracle 
Sql :: oracle parameter 
Sql :: sql practice 
ADD CONTENT
Topic
Content
Source link
Name
6+2 =