Member Avatar for 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.

  • 3 Contributors
  • 4 Replies
  • 129 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Majestics
Member Avatar for Majestics

use varchar2.

Member Avatar for 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

Member Avatar for debasisdas

Use CLOB.

Member Avatar for Majestics

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.