answersLogoWhite

0


Best Answer

SQL functions are primarily a mechanism for extending the power of SQL to handle attributes of complex data types (like images), or to perform complex and non-standard operations. Embedded SQL is useful when imperative actions like displaying results and interacting with the user are needed. These cannot be done conveniently in an SQL only environment. Embedded SQL can be used instead of SQL functions by retrieving data and then performing the function's operations on the SQL result. However a drawback is that a lot of query-evaluation functionality may end up getting repeated in the host language code Regards, Jose Deleep. S

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Compare the use of embedded SQL with the use in SQL of functions defined in a general-purpose of Programming language Under what circumstances would you use each of these features?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What programming language allows viewers of Web page to take advantage of embedded special effects and functions is?

HTML allows users to do this.


What has the author Michael Barr written?

Michael Barr has written: 'Programming embedded systems' -- subject(s): Embedded computer systems, Programming, C (Computer program language)


Is C plus plus good for Embedded programming or not?

C and C++ programming is good for embedded programming. However, embedded implies long running, and that means the possibility of memory fragmentation. You will need to spend time working out or acquiring a method of memory management, such as the use of Smart Pointers and Garbage Collection. This is not a trivial task, but it is a necessary task.


What are the self-contained computerdevices that have their own programming and do not receive input?

Embedded computer


What is best to study Embedded Systems or Mobile technologies?

embedded systems is good....but doing embedded systems is not easy..u should have good programming skills and good background in electronics....u should also have passion to do embedded systems.....


Is a embedded clause an adverb?

An embedded clause is not an adverb. It is a type of subordinate clause that is embedded within a main clause and functions as a noun, adjective, or adverb within the sentence.


Special-purpose computer that functions as one component?

embedded computer


Which is best matlab programming or embedded C programming?

Really depends on what you're studying--matlab is good for implementing higher level concepts (AI, etc.)


How can a normal person understands a embedded programming?

Simply how capacitor blocks dc and allows ac after charging?


Do Embedded computers have their own programming They typically do not receive input from you nor do they interact with other systems?

true


In computer technology what does an embedded system do?

An embedded system can be thought of as a small component in a larger electrical framework. In a computer, for example, each individual component, such as the motherboard, functions as an embedded system within the computer.


What is Windows XP Embedded?

An embedded operating system is an operating system for embedded computer systems. These operating systems are designed to be compact, efficient, and reliable, forsaking many functions that non-embedded computer operating systems provide, and which may not be used by the specialized applications they run.