Hi I got following output
1 SELECT sum(CASE WHEN entry='in' THEN 1 ELSE 0 END ) as entryin,
2 sum(CASE WHEN entry='out' THEN 1 ELSE 0 END ) as entryout,edate
3 FROM app
4* GROUP BY edate
SQL> /
ENTRYIN | ENTRYOUT | EDATE
---------- | ---------- | ----------
1 | 0 | 02-09-2008
1 | 0 | 02-09-2008
1 | ...
arulkumara
Last Activity: Sep 4 '08, 06:50 AM
Joined: Aug 8 '07
Location:
-
spilit one column into two columns
Hi,
My table
*************** ***
edate entry
*************** ***
01-02-2008 in
01-02-2008 in
01-02-2008 out
01-02-2008 out
01-02-2008 in
01-02-2008 in
i need count of entry column for in and out values
i need following output:
*************** ***********
edate -------- COUNT(IN) -------- COUNT(OUT)
... -
how to split single row into multiple columns in mysql
Hi,
I have one problem in mysql.
how to split single row into multiple columns in mysql.
my table structure:
I need following output :Code:id salaryhigh salarymedium salarylow ********************************************** 1 1000 100 1 2 2000 200 2
...Code:id saldetails description
-
how retrive table values from two oracle databases
hi,
oracle-9i
os-unix server
I have two oracle databases in same server like test1,test2 respectively.
I would like to retrive some table datas from test1 to test2.
how to access values from one database to another.
Thanks -
no output for to_date function
Hi,
I want to diaplay hi message if system date is equl to given date.
I tried one simple script.
But it doesn't show any output
what is problem with to_date function.
script:
*************** ******
[code=oracle]
set serveroutput on
begin
if sysdate=to_date ('23-11-2007','DD-MM-YYYY') then
dbms_output.put _line('Hi');
... -
execute query for every month of beginning
Hi,
I want to insert a particular row into a table for every month of beginnging date like 1-11-2007,1-12-2007.
for that which one is best triggres or batch jobs.
please explain me. -
arulkumara replied to writing a query to get the second highest value in atable by using select statementin OracleHi
try this
select level,max(salar y) from emp1
where level=2
connect by prior salary>salary
group by level;
here salary->column name...Leave a comment:
-
arulkumara replied to writing a query to get the second highest value in atable by using select statementin OracleHi
try this
select level,max(salar y) from emp1
where level=2
connect by prior salary>salary
group by level;
here salary->column...Leave a comment:
-
how connect to java application to oracle
Hi
i want to connect java application to oracle
i'm using unix environment
plz explain all details
i'm beginner to unix environment -
ya it works properly for me also
i done one mistake in table creation...Leave a comment:
-
logoff trigger does n't works
Hi
I created one logoff trigger . but tat does n't work properly
but log on trigger works properly. wat's the problem
I'm using oracle 9i with unix environment
coding
*********
create or replace trigger logoff_trig
before logoff on schema
begin
insert into logon_trig values (user,sysdate,' logging off');
end;
/
~
... -
plz explain how to solve that problem...Leave a comment:
-
exec dbms_jobs.run(:jobno) after executing this i got one error message
my coding
variable jobno number
begin
dbms_job.submit (job =>:jobno,
what => 'pack3.addpro(1 7,''syed'',2343 2,sysdate,300); ',
next_date => SYSDATE + 30/86400,
interval => 'SYSDATE + 30/86400');
commit;
end;
/
print jobno
~
SQL> @autoadd.sql... -
hi i got one error at exporting tables in oracle plz solve the problem
/ wd/arul>exp
Export: Release 9.2.0.5.0 - Production on Thu Aug 9 01:52:39 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: finuser
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and...Leave a comment:
-
oracle doubts-arul
/wd/arul>exp
Export: Release 9.2.0.5.0 - Production on Thu Aug 9 01:52:39 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: finuser
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Enter...
No activity results to display
Leave a comment: