Home » SQL & PL/SQL » SQL & PL/SQL » substring and host variable
substring and host variable [message #38758] Mon, 13 May 2002 03:01 Go to next message
kkcheok
Messages: 1
Registered: May 2002
Junior Member
can somebody describe for me what ia substring and what is host variable???
thank you!!!!
Re: substring and host variable [message #38803 is a reply to message #38758] Thu, 16 May 2002 00:30 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
substring is a function to get part of charapter in a string.
e.g substring(2,5,"abcdefghijk") -- "bcdef"

host is use to execute your host command.
e.g
sql> host dir

hope this is helping
Previous Topic: HOW TO CONVERT A VARCHAR2 TO NUMBER???
Next Topic: Using decode
Goto Forum:
  


Current Time: Fri Apr 26 10:10:58 CDT 2024