Author: codertutor_3o6d0o

Oracle PL/SQL As Keyword Example SELECT sal * 2 AS "Salary" FROM emp; CREATE TABLE cust_1276 AS SELECT * FROM customers WHERE customer_id = 1276; CREATE TYPE email AS OBJECT (email_adress VARCHAR2(80)); CREATE TYPE email_list AS TABLE OF email; CREATE TYPE...

Oracle PL/SQL Alter Table Alter Table Example: ALTER TABLE offers RENAME TO news_offers; ALTER TABLE offers ADD details varchar2(1000); ALTER TABLE offers MODIFY details varchar2(800); ALTER TABLE offers DROP COLUMN details; ALTER TABLE offers RENAME COLUMN amount to new_amount; alter table...

Numbers The interpreter of Python acts like a simple calculator. You can make operation like add, subtract(minus), multiply, divide. Examples Add >>> 3 + 5 8 >>> 125.5 + 2.5 128.0 >>> 134.7 + 3 137.7 Multiply >>> 3 * 5...

Strings Strings can be enclosed in single quotes (‘..’) or double quotes (“..”). The print() function is used to show the output of strings. Examples Single quotes >>> 'Single quotes test' 'Single quotes test' Double quotes >>> "Double quotes test" 'Double...

Lists The Python list, is a sequence of values, separated by commas between square brackets. Lists can have values of different data types. Example Extract all values from a list with python >>> my_list = [1, 5, 7, 21, 33] >>>...