Toad World® Forums

Toad format sql statement in one row


#1

Hi,

How can I change the formatter in toad or maybe sql developer to format my sql statements automatically in one row statement.

Here one Example: This is my start which I wanna to format.

**    BEGIN
db_package.drop_table ('test');
END;
CREATE TABLE mytable
(
Column VARCHAR2 (1 CHAR)
);
...**

This is my goal formatted statement.

**BEGIN db_package.drop_table ('test');END;
CREATE TABLE mytable( Column VARCHAR2 (1 CHAR));
...**

So I want to format the statements so that I get every statement in one row.

Thank You

Hari


#2

Hello Hari,

Currently there are no formatter options to obtain this format. It looks as if you can get the desired result by simply omitting the newline characters… But what if the code is a bit bigger and you get a line of 1,000 characters?

Thanks,
Andre