select cl_to, page_title
from page
join categorylinks on page_id =... |
4 years ago |
select page_title
from page
join categorylinks on page_id = cl_from
where... |
4 years ago |
select * from categorylinks where cl_to = 'Analytical_chemistry' |
4 years ago |
select * from categorylinks limit 5 |
4 years ago |
select * from page limit 2 |
4 years ago |
select * from page where rownum < 2 |
4 years ago |
select * from page where page_namespace = 48252 |
4 years ago |
select * from categorylinks where cl_from = 48252 |
4 years ago |
select * from categorylinks where cl_from = 48252 |
4 years ago |
select * from categorylinks where cl_to = 'Analytical_Chemistry' |
4 years ago |
select * from category where cat_title like '%chemistry%' |
4 years ago |
describe category |
4 years ago |
select * from all_tab_columns |
4 years ago |
select * from all_tables |
4 years ago |