Tag: databases
Questions Related to databases
-
SELECT row_name INTO variable_name FROM table_name [WHERE condition];
-
SELECT column_name INTO variable_name FROM table_name [WHERE condition];
-
SELECT column_name INTO variable_name FROM table_name [WHEN condition];
-
SELECT table_name INTO variable_name FROM table_name [WHERE condition];
-
table_name record_type_name;
-
column_name record_type_name;
-
record_type_name record_name;
-
record_name record_type_name;
-
EXECUTE [or EXEC] database.function_name;
-
employee_name := employer_details_func;
-
SELECT employer_details_func FROM dual;
-
dbms_output.put_line(employer_details_func);