This site requires JavaScript to be enabled

Tosca Version
IncidentLookup using list
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

How to buffer all the rows and columns from SQL query result and paste it in excel?


I have a scenario where I need to get the extracts of SQL statement from Oracle DB. I am able to connect to Oracle DB using DSN and fire the SQL using "TBox DB Expert module" now I wanted to buffer all the rows and columns from SQL statement and paste it to excel.


When I try buffer the complete result table, it is not allowing me to do.


Can someone suggest how to copy\buffer the entire result of a SQL statement?


0 0

Pugazhvanan Ganapathy

Created: 2017-10-11 04:57:51

As per my Knowledge, TBox Engine does not support this requirement. You can give it a try with classic db enigne.

1 0

Pugazhvanan Ganapathy

Created: 2019-03-20 18:20:32

Here is solution for this


Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial