Top Posters
Since Sunday
29
11
10
9
8
7
7
7
7
6
6
6
New Topic  
wrote...
Posts: 165
4 months ago
What is embedded SQL, and what considerations are necessary when using it in an application?
Source  Download
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 34 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 209
4 months ago
Sign in or Sign up in seconds to unlock everything.
Embedded SQL are SQL statements used, or embedded, in program code, triggers or stored procedures. Applications are typically written in program code, using a programming language. There are two problems that arise. First, the results of SQL statements must be assigned to programming language variables. DBMS products typically provide the means of doing this. Second, SQL is table or set-oriented and SQL results use tables or sets of rows, whereas application programming languages are variable or row-oriented. This is resolved by treating SQL results as pseudofiles. A cursor is then used to move through the pseudofile one.
1
Related Topics
wrote...
4 months ago
You make an excellent tutor!
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  155 People Browsing
Your Opinion
Related Images
 611
 118
 78

▶️ Video: Glucose Evaluation Procedure

For a complete list of videos, visit our video library