I have an application in which user will put the query in text box and will get the output in gridview and i need to keep track that which user has run which query.
for that i will be taking query from textbox and store in one variable
I need to create table with two columns
1)username
2)query
But query can be bigger and i am not getting which datatype to use
I know in mysqlserver i use text as datatype.
But i googled it lot for the same in oracle
But didnt succeeded.

use varchar2.

I know i can use the nvarchar
But i have to insert entire query in one row
Cant determine length of the query

Use CLOB.

what your are using oracle forms or java?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.