Thursday, May 8, 2014

Toggle case in SQL DEVELOPER

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

No comments:

Post a Comment