I dug for about an hour last night on the subject of SQLTERMs and their definitions for Oracle SQL
& SQL Server
and a few others.
I noticed that some of the terms are generic then realized that some of the sites did not have even some of the basics. SELECT FROM WHERE ORDERBY etc.
With that, I wondered if I was looking at terms and definitions of databases vs the CODE. So is there a really good site for finding out what specific code like functions or operations do in a SQL query?
This would be very helpful to me since I have been trying to breakdown many of the parts of the query and what each term means so I can decipher and create my own...?
Not this stuff. I understand this. https://raima.com/database-terminology/
What each type of code is and does....? Like Create Table or maybe it is insert table commands.
I figured you guys would know the best stuff. So rather than hope I hit a home run? I'll get on base and you can hit the home run.