select
case when dept_no=10 then lower(ename)
when dept_no in (20,30) then upper(ename)
else ename
end as ename
from emp;
rski
Last Activity: Mar 15 '19, 03:06 PM
Joined: Dec 17 '06
Location: Poland, Gdansk
-
put password into ''Leave a comment:
-
What is that variable &CLEARED_FLA G ... what value you put here?Leave a comment:
-
what is the error message you have got?Leave a comment:
-
I have use postgres since ages :) bus as far as I remember postgres do not support contraints on views (maybe the last 9.x version does, not sure). Can't you define proper constrain on a table that is used in view definition?Leave a comment:
-
You can
1) disable foreign keys in C1, C2 and C3, see here http://www.techonthenet.com/oracle/f...ys/disable.php
2) recreate P1 table
3) enable C1, C2, and C3 foreign keysLeave a comment:
-
Could you put here the script code? What OS do you use (Linux/Unix, what Linux?)Leave a comment:
-
you put
at the beggining of the script. make sure that /bin/bash file exists, it may be under different location in your system.Code:#!/bin/bash
Leave a comment:
-
Your code works fine for me. Which shell do you use, under bash it works ok.Leave a comment:
-
There is no such column for DMLs, for DDL you have last_ddl_time.
To have last time for DML you will need to create a column which will be updated/inserted when proper SQL query is executed, but you have to do populate that column by yourself.Leave a comment:
-
Is client able to ping both server addresses?Leave a comment:
-
Not sure which oracle version you are using but you can
1) use hierarchical query (with connect by prior)
2) use wm_concat function like that
-define view
-and query this view in the following wayCode:create view list_of_values as select application_id , to_char(wm_concat(comments)) from test group by application_id
...Code:select * from list_of_values where application_id=1234123412
Leave a comment:
-
rski replied to Is the server running on host “127.0.0.1” and accepting TCP/IP connections on port 54in PostgreSQLDid you start server?Leave a comment:
-
See here
http://psoug.org/reference/regexp.html...Leave a comment:
-
This is because for strings, max is taken in a lexicographical order.
You have to remove non-number characters and use to_number
Code:select max(to_number(regexp_replace(column_name,'[[:alpha:]]', ''))) from test;
Leave a comment:
-
you have to surround DATA part with " " not ' ', like that
...Code:my $subject='Android Results'; use MIME::Lite; my $msg = MIME::Lite->new ( Subject => $subject , From => 'xxxx@gmail.com' , To => 'yyyy@gmail.com' , Type => 'text/html'Leave a comment:
-
As Rabbit said, use
Code:COUNT(DISTINCT <column name))
Leave a comment:
-
Or
- create shared C library which will run your exe
- create java based function
see here for options
http://www.dba-oracle.com/t_execute_...and_oracle.htm
http://www.oracle.com/technetwork/da...1-1-129519.pdf...Leave a comment:
-
Both displays single character.
putch comes from conio.h and I what wiki says (http://en.wikipedia.org/wiki/Conio.h) it is not supported on Linux.
putchar comes from stdio.h and you can use it with no problems on Linux.Leave a comment:
-
Is it written
You have to compile code into shared libraryCode:Once we have written the I/O functions and compiled them into a shared library
Leave a comment:
No activity results to display
Leave a comment: