Home » SQL & PL/SQL » SQL & PL/SQL » How to compile or encrypt a SQL query
How to compile or encrypt a SQL query [message #7838] Fri, 11 July 2003 08:42 Go to next message
Sss
Messages: 7
Registered: May 2001
Junior Member
Hi,

I developped some queries and they will be launched by other users, but I won't the see the source. So, is it possible to crypte or compile a SQL query ?

Regards.
Re: How to compile or encrypt a SQL query [message #7839 is a reply to message #7838] Fri, 11 July 2003 09:06 Go to previous messageGo to next message
Navtej
Messages: 19
Registered: July 2003
Junior Member
Put your query in one file . let say your file name is
test.sql

run the following command on comand prompt
wrap iname=test.sql

this command creates test.plb file and this file has
encrypted sql statements.you can run this file same as
test.sql.
Re: How to compile or encrypt a SQL query [message #7842 is a reply to message #7839] Fri, 11 July 2003 10:10 Go to previous messageGo to next message
ssss
Messages: 2
Registered: March 2002
Junior Member
wrap command is not installed on my SQL server. Maybe a DOS/Win utilitie can do this encryption ?
Re: How to compile or encrypt a SQL query [message #7843 is a reply to message #7842] Fri, 11 July 2003 10:26 Go to previous message
Navtej
Messages: 19
Registered: July 2003
Junior Member
wrap belogs to oracle. I don't know about SQL server.
Sorry.
Previous Topic: Fine Tuning
Next Topic: how query write for distint dates
Goto Forum:
  


Current Time: Thu Apr 25 18:02:59 CDT 2024