you'll need to add a where clause to limit your resultset to what you want exported
Hi, I am new in SQL developer, I need to insert query option for only one row. I found an export wizard option but it was not exporting the data of a table (specific row)
Why not just query the row(s) you want and them save them to a file from the data grid?
select /*insert*/ * from myTable where myPrimaryKey = 'abc'
. . .
select /*insert*/ * from myTable where myColumn = 'abc' and rownum = 1
I hope this helps you. You need to use the where clause to limit your dataset that meets your requirements or the result that you have expected.
that's not even SQL Developer - you're on the wrong forum
That is PL/SQL Developer that I'm using. I hope that will be useful for the person who asked question because more or less PL/SQL Developer is same as SQL Developer.
The Options might vary but it will be useful for the person to crack his question. I'm sorry if i'm wrong.