Tag: programming languages

SELECT

EXECUTE

ALTER TABLE

CREATE TABLE

DELETE

string and date

character and numeric

integer and conversion

calendar and date

date and conversion

translation and date

A MERGE statement is used to merge the data of one table with data from another.

A MERGE statement can be used to update existing rows in a table.

A MERGE statement replaces the data of one table with that of another.

A MERGE statement can be used to insert new rows into a table.

The UNIQUE constraint does not permit a null value for the column.

The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

The NOT NULL constraint ensures that null values are not permitted for the column.

A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

A subquery should retrieve only one row.

A subquery can retrieve zero or more rows.

Subqueries CANNOT be nested by more than two levels.

A subquery can be used only in SQL query statements.

A subquery CANNOT be used in an SQL query statement that uses group functions.

When a subquery is used with an inequality comparison operator in the outer SQL statement,

USER_CONSTRAINTS

USER_OBJECTS

ALL_CONSTRAINTS

USER_CONS_COLUMNS

USER_COLUMNS

GRANT select ON dept TO ALL_USERS;

GRANT select ON dept TO ALL;

GRANT QUERY ON dept TO ALL_USERS

GRANT select ON dept TO PUBLIC;

GRANT QUERY ON dept TO PUBLIC;

UNIQUE

NOT NULL

CHECK

PRIMARY KEY

FOREIGN KEY

The tables being joined have NOT NULL columns.

The tables being joined have only matched data.

The columns being joined have NULL values.

The tables being joined have only unmatched data.

The tables being joined have both matched and unmatched data.

Only when the tables have a primary key/foreign key relationship.

What do you call it when a chip manufacturer loses money? -- A cash miss.

What do you call someone who has to use a dull web application? --Bored to tiers.

What does a hungry vegetarian say? --"I´m so hungry, I could eat a tree."

Always wear protective goggles when operating a weed-eater, working with a power tool, or teasing your wife.