create table

[Arjun_Sarankulu]

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.

[Majestics]

use varchar2.

[Arjun_Sarankulu]

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

[debasisdas]

Use CLOB.

[Majestics]

what your are using oracle forms or java?