How does one SELECT, INSERT, UPDATE and DELETE data from OraTCL?
Submitted by admin on Sun, 2005-11-06 02:43.
Look at this example:
set connect scott/tiger@orcl
set lda [oralogon $connect]
set cur [oraopen $lda]
set sql {select tname from tab}
orasql $cur $sql
set row [orafetch $cur]
while {$oramsg(rc) == 0} {
puts $row
set row [orafetch $cur]
}
oraclose $cur
oralogoff $lda
»
- Login to post comments

