Run SQL and browser the specific data

[#1]

Hi

I want to do some basic SQL, like data that is between this and that condition whatever, and then I will have this new table where I can browser the specific data.

So I guess I can only do the SQL within the script editor and then ?

[arulsettu]

hi -Mikael-

  you can write the sql query in script editor. and then if want do more you can write the script in sheet objects also...

[#3]

Thx, but the point is that I want to browser the table, that is to review the specific data see how many rows etc.

[#4]

Only native tools to look at data within QV are

- the table viewer window (ctrl T)

to see structures:

- create a system table (in an extra sheet).

But if you are a little familar with the user interface it should not be a problem of generating list- and tableboxes

HtH

Roland

[#5]

Thx, I know these, but that is not what I am looking for. I just want to test a SQL, with a temp table to look through it. Also the table viewer only gives me the structure with field names? I can then do tableboxes etc. yes, but I did hope for another solution.

System table?     

[#6]

Yeah,

this is not pretty much, and I was quite sure you know it.

System Table is a predefined object, check it via new sheet object --> System Table (last entry).

But this won't satify your need either.

RR

[#7]

BTW:

In your situation I would use a SQL-Client like SQL-Developer or TOAD.