0

Can we use lowercase instead of uppercase in commands

23rd Jan 2017, 12:31 AM
Aj Verma
Aj Verma - avatar
5 Antworten
+ 4
It's a good practice to write SQL Queries in uppercase.
23rd Jan 2017, 1:44 AM
David Sebastian Keshvi Illiakis
David Sebastian Keshvi Illiakis - avatar
+ 2
SQL isn't case sensetive, so yeah we can write uppercase and lowercase both whatever we want
23rd Jan 2017, 2:10 AM
Mayank
Mayank - avatar
0
got my answer from lesson its incase sensitive
23rd Jan 2017, 12:40 AM
Aj Verma
Aj Verma - avatar
0
I agree that best practice is to use uppercase for SQL Commands. It gives the code a cleaner look!
23rd Jan 2017, 3:10 AM
LATRAYVEOUS Jackson
0
Dear AJ verma First of all keep it in mind that using capital or small doesnot depends upon the sql query it matters where you are going to execute it...... 1.If you are use oracle product then you can use both letters either small or capital... Ex. I am going to show you one query let say....select query---- Select name from TBLName; As you have seen above in my table name some of characters was in small some are in capital. so if you run this query in oracle product then it will execute successfully or 2.If you are using lets say mssql then it will show you an error----- Hope you got your ans---please feel free to ask your doubt in comment. :)
23rd Jan 2017, 6:49 PM
Kumar Asheesh