0
create table user_views_clob
(view_name VARCHAR2(32),
clob_text CLOB)
/
insert into user_views_clob
select view_name, to_lob(text) from user_views
/
and do the search like
select * from user_views_clob where upper(clob_text) like upper('%hello_world%');
replace hello_world with your text.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
How many types of view in oracle?
There are two types of views in Oracle based upon from how many tables data are being fetched. 1. Simple view - In this view, data is coming from only one table. 2. Complex view - In this view, data comes from more than one table. That's it. However, Complex views have some limitations. For these follow Oracle documentation.
What is the definition of view oracle database?
I want to know how the view is working in oracle?
Will view drop if table drop?
If the dropped table is a base table for a view , then dbms like oracle invalidates these dependent views but does not drop them. But you cannot use these unless you re-create the table.
To view a table in Design view?
in the Views group, click the Views arrow and click Design view
On gta4 when in the car what views can you be in?
you can be in close view, medium view (recommended), far view, hood view, and cinematic view. cinematic includes multiple aerial views, wheel views, and street views. stick with medium, far, or close though.
How do you draw top views and front views?
Front view is Equal to top view
What is the definition of the linear view?
linear views means views of line ;)
What is the plural of the word view?
Views
What are the 3 aesthetics views?
subject view-This view states that if the subject of a work looks convincing and lifelike, the work is successful.composition view-This view states that the way the artwork is organized is the most important aspect of an artwork.content view-This view states that the most important ingredient for a successful work of art is its content-the message, idea, or feeling expressed by the work of art.
What is the plural form of views?
Views is plural. The singular form of the word is view.
What are the different views of data in a database management systems?
In a database management system, data can be viewed in three main ways: Conceptual view: Represents the overall framework or structure of the entire database. External view: Shows a subset of the database and is tailored to meet individual user requirements. Physical view: Describes how data is stored on the physical storage media.
Why is the Hellenistic view better than the Hebrew view?
It's not. Different world views are not better or worse than other world views.
