Indentation of code in Toad

oracle toad auto-indent
Sai picture Sai · Jun 24, 2014 · Viewed 8.5k times · Source

Is there any software or a shortcut key which I can use to auto-indent code in Toad for Oracle 11.6?

Answer

rtbf picture rtbf · Jun 24, 2014

Yes, there is e.g. in SQL Developer. Shortcut for formatting code is CTRL + F7.

Related questions

ORA-12170: TNS:Connect timeout occurred

I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I kept on having this error? I …

Read More
How can I solve ORA-00911: invalid character error?

I tried to execute an SQL INSERT with Toad for oracle: INSERT INTO GRAT_ACTIVITY (UUID, IP_ADRESS, SEND_MAIL, DATE_CREA, DATE_UPD, CREATOR, CENTER, ETAT, REQUEST) VALUES('555-vgd9-pllkd-5513', '172.12.23.130', 'N', SYSDATE, SYSDATE, '1554', …

Read More
SQL query for extracting year from a date

I am trying to create a query that gets only the year from selected dates. I.e. select ASOFDATE from PSASOFDATE; returns 11/15/2012, but I want only 2012. How can I get only the year? I know the YEAR function can be …

Read More