Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Who is this called
vishnu_at_magicinterface.com wrote:
>Perhaps he's just asking for the generic term for this sort of logic.
>
>Perhaps the name you are looking for is "Dynamic SQL" or "Native
>Dynamic SQL (NDS)? If you were to examine the Oracle documentation
>for information on this kind of thing, that's where you would look?
>
>I don't think you'd find anything under "Fred" or "Barney" ;)
>
>Quilpole.
>
>On Tue, 10 Jan 2006 10:03:31 -0500, "Mark C. Stock" <mcstockX_at_Xenquery
>.com> wrote:
>
>>
>><Kurt-Erich.Finger_at_hte-company.de> wrote in message
>>news:1136904591.079117.234510_at_g49g2000cwa.googlegroups.com...
>>> Hello Mark,
>>>
>>> The example is just an example, good or bad doesn't matter.
>>>
>>> ....a statement like this would be called from any SQL interface, such
>>> as
>>> SQL*Plus or iSQL*Plus, etc,., and the resulting rows would be
>>> cut-and-pasted
>>> back into the tool to exeute the grants
>>>
>>> I know how to use it.
>>>
>>> My only question was, what ist the name of statements like this.
>>>
>>> regards
>>> ke
>>>
>>
>>Fred? Barney?
>>
>>It's classified as a SQL DML statement (although some consider DML to only
>>include INSERT, UPDATE, DELETE).
>>
>>In what context do you mean 'name'? In what context do you need to use the
>>'name' of this type of statement?
>>
>>++ mcs
>>
>>
It is not Dynamic Sql ( That is Sql included in Pl/Sql code..
If anything, it is usually called 'Using Sql to write Sql'.. Received on Tue Jan 10 2006 - 12:41:19 CST