Sql common columns

sql common columns — NB: Applicable for Oracle and PL/SQL only select * from all_tab_cols A where A.COLUMN_NAME in ( select B.column_name from all_tab_cols B where B.table_name = ‘YourFirstTable’ ) and A.table_name != ‘YourFirstTable’ and A.TABLE_NAME = ‘YourSecondTable’;

Sql common columns Read More

Sql comments

sql comments Single line comments start with –- Any text after these 2 characters to the end of the line will be ignored. Multiline comments start with /* and end with */. They stretch across multiple lines until the closing characters have been found. — My Select query /* This is my select query. It […]

Sql comments Read More

Sql comment

comment in sql /* Comment */ SQL comment /* Multi-Line Comment */ — Single-Line comment sql comment /* Multi-Line comment goes here */ — Single-Line comment goes here sql comment /* Multi-Line comment goes here */ — Single-Line comment goes here sql comment /* Multi-Line comment goes here */ — Single-Line comment goes here sql […]

Sql comment Read More