moving away from toad questions

[costa_basil]

Hi:

I want to move away from using toad, however I have some questions:

- I want to use a dark background, I've been able to set a black background, but I can't change the color for identifiers from dark blue to something else. How can I do that?

- Can I export the data from a query to an excel spreadsheet (xls file)? Yes - this works I found it myself - the Copy to excel... option from the popup menu

- can pl/sql developer create a synchronize script between two schemas?

- does pl/sql dev support cursor columns. This query runs
SELECT CURSOR(SELECT SYSDATE FROM SYS.dual) FROM SYS.dual

but when I try to view the cursor I get an invalid cursor error

- can I view the results from a function that returns a cursor or from a procedure that returns output cursors?

That's it for now.

Thanks

 

[Bo Pedersen]

> - I want to use a dark background, I've been able to set a black background, but I can't change the color for identifiers from dark blue to something else. How can I do that?

That should be in Tools -> Preferences -> Editor -> Syntax Highlighting

> - can pl/sql developer create a synchronize script between two schemas?

Yes, Tools -> Compare User Objects. Select a target session and Compare.

> - does pl/sql dev support cursor columns.

Seems to be a bug in the current version. I get the same error in 7.1.1.1339 but it works as expected in 7.0.3.1123.

> - can I view the results from a function that returns a cursor or from a procedure that returns output cursors?

Yes, use the test window and use a bind variable of type cursor. If you right-click on the procedure/function name and select test you should get a test window with correct bind variables automatically. And this works in current version.

Bo Pedersen

 

[costa_basil]

> That should be in Tools -> Preferences -> Editor -> Syntax Highlighting

There is no option for identifiers, only keywords, comments, strings, numbers, symbols and custom.

The identifier colors is dark blue.

Where do I change it?

Thanks

 

[Gustavo]

Tools --> Preferences --> User Interface --> Fonts --> Editor --> Select button

 

[costa_basil]

Thanks, and sorry, I didn't notice it, it was under my eyes all the time. I am usually accustomed to see all syntax highlighting settings in the same spot including the background.

 

[Gustavo]

Yeah, someone has already asked all font settings to be grouped. This is in the list of Enhancement Requests.