A nostalgic visit from the past: Embedded SQL, where you can inject live SQL directly into your C code.
EMBEDDED SQL IN C
Introduction to Pro*C
The second refers to such development using Oracle. Example from the second:
for (;;) {
printf("Give student id number : ");
scanf("%d", &id);
EXEC SQL WHENEVER NOT FOUND GOTO notfound;
EXEC SQL SELECT studentname INTO :st_name
FROM student
WHERE studentid = :id;
printf("Name of student is %s.\n", st_name);
continue;
notfound:
printf("No record exists for id %d!\n", id);
}
It’s worth mentioning just to have some central place to search for it later.