search

PranabKumarSahoo / sql-dev-tools

A tool for SQL Developers, which empowering SQL developers with versatile functionalities and make their day-to-life tasks easy.
https://sql-dev-tool.web.app/
MIT License
14 stars 19 forks source link

Create new section as "String Manipulation" inside -> convert word from lower to uppercase and Upper to lower case #27

Open sagarbee opened 10 months ago

sagarbee commented 10 months ago

If you want to convert the values in the ename column of a table to uppercase in Oracle SQL, you can use the UPPER function. The UPPER function converts all characters in a string to uppercase. Here's an example query:

UPDATE your_table_name SET ename = UPPER(ename);

also if we put number as input then it shoul show error

similar for Uppercase to lowercase

PranabKumarSahoo commented 10 months ago

Hello @sagarbee, Thank you for creating an issue on this! ⭐

Yah that a cool feature to add! So, I'm officially assigning this task to you under SWOC. So feel free to start working on it. Please keep me updated on your progress through images/videos in the comment section before raising the PR.

PS: Always mention the issue number in your PR in the following format: Resolve issue #

If you have any questions or need clarification, don't hesitate to ask in the comments or on Discord [Find #sql-dev-tools channel].

#Good luck! ✌️

PranabKumarSahoo commented 9 months ago

Hey @sagarbee, What's your working progress on this.

PS: This is to inform you that, some issues are taking longer than expected to implement. If you find that any issue is taking too much time, please ensure to clone the recent version of the repository before making changes. This is important as others may have added new features that could affect your work.

Thank you for understanding. ✌️