Query to get the product of all the values of a column :
SELECT EXP(SUM(LN(col1))) FROM tablename;
Printable View
Query to get the product of all the values of a column :
SELECT EXP(SUM(LN(col1))) FROM tablename;
use oracle wrap utility to encrypt your procedures and packages. But can't wrap triggers.
[B][COLOR="DarkOrange"]Jaya[/COLOR][/B]
can u explain it
wrap utility is used to encrypt pl/sql code.the wrap utility takes a readable, ASCII text file as input and converts it to a file containing byte code. The result is that the DBA, developers or anyone with database access cannot view the source code in any readable format.
in cmd type
wrap iname=sourcefilenamepath oname=ouputfilenamepath
Syntax for wrap utility is
wrap iname=input_file [oname=output_file]
Leave no space around the equal signs because spaces delimit individual arguments.
Output file name is optional because its name defaults to that of the input file and its extension defaults to plb (PL/SQL binary).
If you want, you may specify a different output file name and extension.
You need not specify the file extension for input file if its extention is sql.
ex:-wrap iname=c:\mydir\myfile
You need to specify extension if you are giving inputfile having differenct extention name
ex:- wrap iname=c:\mydir\myfile.prc
Wrap Utility encrypts only functions, procedures and packages.
String literals, number literals, and names of variables, tables, and columns remain in plain text within the wrapped file.
I created a procedure. After encrypting the procedure I dropped the procedure and then executed the encrypted file. It is working fine in SQL * Plus. But it is not supporting in toad.
In toad can we execute encrypted files?
hi
y not we can, can u post the returned error?
[B][COLOR="DarkOrange"]Jaya[/COLOR][/B]
My toad and SQL *Plus start in folders are different. That is the problem. Now it is solved.
hi
Tip of the day::)
to minimize the fragmentations and improve query response time related to one particular table just reorganize the table in the following way:
SQL> [B][COLOR="Blue"]alter table < table_name > move;[/COLOR][/B]
[B][COLOR="DarkSlateGray"]For best results, you can alter storage parameters of that table, before going to reorganize.[/COLOR][/B]
[COLOR="DarkOrange"][B]Jaya[/B][/COLOR]