Member Avatar for hillol
hillol 0 Newbie Poster

hi,

can anyone help me how to redirect sql query result to a file in shell scripting using sqlplus.

Is the below code snippet corrct:

sqlplus -s username/password <<- !
select * from testhil1;
quit
! > rony3.txt

  • 1 Contributor
  • 0 Replies
  • 96 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.