0
Can we use lowercase instead of uppercase in commands
5 Respuestas
+ 4
It's a good practice to write SQL Queries in uppercase.
+ 2
SQL isn't case sensetive, so yeah we can write uppercase and lowercase both whatever we want
0
got my answer from lesson its incase sensitive
0
I agree that best practice is to use uppercase for SQL Commands. It gives the code a cleaner look!
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. :)