Toad users find SQL developers shortcuts bit difficult. I searched a lot and then finally find out the shortcut for CASE TOGGLE in SQL Developer as well
Ctrl+'(Single Quote) --> Toggle the case (Upper/Lower/Initcap)
Sample Query: select emp_id , emp_name from employees
1) On Ctrl+'(Single Quote) query change all keywords to upper case
SELECT emp_id , emp_name FROM employees
2) On again doing Ctrl+'(Single Quote) full query changes to upper case except keywords
select EMP_ID , EMP_NAME from EMPLOYEES
3) On again doing Ctrl+'(Single Quote) full query changes to upper case except keywords
Select Emp_Id , Emp_Name From Employees
4) On again doing Ctrl+'(Single Quote) full query changes to upper case
SELECT EMP_ID , EMP_NAME FROM EMPLOYEES
5) On again doing Ctrl+'(Single Quote) full query changes to lower case
select emp_id , emp_name from employees
Ctrl+'(Single Quote) --> Toggle the case (Upper/Lower/Initcap)
Sample Query: select emp_id , emp_name from employees
1) On Ctrl+'(Single Quote) query change all keywords to upper case
SELECT emp_id , emp_name FROM employees
2) On again doing Ctrl+'(Single Quote) full query changes to upper case except keywords
select EMP_ID , EMP_NAME from EMPLOYEES
3) On again doing Ctrl+'(Single Quote) full query changes to upper case except keywords
Select Emp_Id , Emp_Name From Employees
4) On again doing Ctrl+'(Single Quote) full query changes to upper case
SELECT EMP_ID , EMP_NAME FROM EMPLOYEES
5) On again doing Ctrl+'(Single Quote) full query changes to lower case
select emp_id , emp_name from employees
No comments:
Post a Comment