Hi, Please find the simple code below for checking password.
<HTML>
<Body>
<h2>Checking the Password</h2><br><hr>
<Form name=form1>
Enter the Password:
<Input type=password name=text1>
<br>
<Input type=button name=button1 value="Check">
<br><hr>
<h2>Changing the Password</h2><br><hr>...
Vasuki Masilamani
Last Activity: Apr 11 '08, 06:41 AM
Joined: Dec 7 '06
Location:
-
Checking Password
-
To get the first saturday of a month
select next_day(last_d ay(add_months(s ysdate,-1)),'Saturday') from dual
I found that I can use some loop like rownum() etc.. to get it. But how to use the logic?
Query to get all last saturdays of a year
SELECT TO_CHAR (
NEXT_DAY (
LAST_DAY (
ADD_MONTHS (TRUNC(SYSDATE, 'Y'),ROWNUM-1))-7,
TO_CHAR (TO_DATE('29-01-1927',... -
Number of Weekends in a month
Hi,
Please help me getting the Oracle query which gives the number of Saturdays and Sundays for the current month. Thanks in advance.
Thanks,
Vasuki -
I tried and got the entire script. It is work fine now. Please find the script below.
[CODE=perl]
$f1 = 'C:\Vasuki\chm_ dirx_bud_28.csv ';
open FILE1, "$f1" or die "Could not open file chm_dirx_bud_28 .csv \n";
$f2= 'C:\Vasuki\chm_ dirx_bud_29.csv ';
open FILE2, "$f2" or die "Could not open file chm_dirx_bud_29 .csv \n";
$outfile = 'C:\Vasuki\chm_ dirx_bud.csv';...Leave a comment:
-
Compare Two csv files using perl
Hi,
Can any one help me in writing a script in Perl to compare two csv files and pick out the records which show differences?
Any responses would be appreciated.
Thanks,
Vasuki -
Query to find Number of Working days in a month.
Hi,
Could anyone please help me with a query to get the number of working days in a month.
Thanks in advance.
Vasuki. -
Hi all,
The name "OPUS" was dropped for certain reasons. Can you please suggest some other names. Please..
Any type of suggestions would be appreciated.
Thanks,
Vasuki...Leave a comment:
-
Hi All,
Finally after a deep discussion we came to a conclusion to keep as "Opus Solutions". Opus means creativity.
Thank you all for your suggestions.
Thanks,
VasukiLeave a comment:
-
New name for a Software Company
Hi,
My friend is running a Sofware company in small scale. Currently the name of the company is Sakthi Technologies. Now he wants to change the name of the company. It needs to be bit professional and mordern.
Can any one please suggest some names for this.
Thanks,
Vasuki -
Please find the below code.
$f1 = 'C:\Vasuki\Repl acePerl\chm_com mitmt.csv';
open(FILE, "$f1") || die "Could not open file chm_commitmt.cs v \n";
$f2= 'C:\Vasuki\Repl acePerl\chm_com mitmt_new.csv';
my @outLines1;
while($data = <FILE>)
{
if($data =~ '^"[^,]*","[^,]*","[^,]*","[^,]*","1"')...Leave a comment:
-
Search and Replace a column of the csv file
Hi,
I have a csv file which has "1" in the column 5. I need to replace all "1" in column 5 to "1030".
The Pattern which would search for "1" in 5th column is given below.
'^"[^,]*","[^,]*","[^,]*","[^,]*","1"'
Can anyone help me with a Search and Replace step for this in Perl Script?
... -
Need an query in Oracle equivalent to SQL
This is an SQL Query which would create a variable table and inserts sequence of numbers into the table.
declare @months table(Month int identity (1,1))
declare @i int set @i = 0
while(@i<3)
begin
insert @months default values
set @i = @i + 1
end
I need this same query in Oracle. Can anyone help me in this.
Any solution would be appreciated.
... -
Hi,
I need a query which would convert Columns into Rows without causing any damages to the original data. I am not supposed to solve this by creating temporary tables and later dropping it.
I have a table which is in the below format:
Name EmployeeID Year JanExp FebExp MarExp JanHrs FebHrs MarHrs
A 129178 2005 10 20 30 15 25 35
B 129213 2004 40 50 60 45 55 65
C 129038 2005 70 80 90...Leave a comment:
-
Similar Query in Oracle to declare a variable table.
Hi,
I have a SQL query like this.
DECLARE @months table(Month int identity (1,1))
DECLARE @i int set @i = 0
WHILE(@i<12)
BEGIN
INSERT @months default values
SET @i = @i + 1
END
Can anyone help me with the Same Query in Oracle. I am new to Oracle.
Thanks,
Vasuki -
I can understand the logic of this code. But I am facing some syntax errors in this. Can you please help me in this. Any apt solution would be helpful for me.
Thanks,
Vasuki....Leave a comment:
-
Hi,
I got a solution by creating a table and inserting data into it. But my requirement is to do without creating any tables.
Help me with a solution.
Thanks,
Vasuki....Leave a comment:
-
Vasuki Masilamani started a topic Converting Columns into Rows without affecting the data in the tablein SQL ServerConverting Columns into Rows without affecting the data in the table
Hi,
I need a query which would convert Columns into Rows without causing any damages to the original data. I am not supposed to solve this by creating temporary tables and later dropping it.
I have a table which is in the below format:
Name EmployeeID Year JanExp FebExp MarExp JanHrs FebHrs MarHrs
A 129178 2005 10 20 30 15 25 ...
No activity results to display
Leave a comment: