, Guest>> || || |
/ Oracle
  SQL  [new]
_Oracle_Forms
Member

:
: 229

1.1=1.2+1.3+1.4

update ..
update

,
set
_ = .||'.'||.||'.'||.||' .'||.||' .'||.||' .'||.;
where
._ = .(+);
ORA-00971: SET ORA-00900: SQL
12 07, 08:10[4381375]      |
 Re: SQL  [new]
pravednik
Member

: Jacksonville, FL
: 16268
,

update 
  
, 
set
 _ = (Select .||'.'||.||'.'||.||' .'||.||' .'||.||' .'||. from  ,   where 
._ = .(+)) ;

--------------------------------
-, -, - .
12 07, 08:26[4381405]      |
 Re: SQL  [new]
_Oracle_Forms
Member

:
: 229
..
12 07, 08:31[4381416]      |
 Re: SQL  [new]
Elic
Member

:
: 29976
pravednik
, .
12 07, 08:34[4381425]      |
 Re: SQL  [new]
dmidek
Member

: -
: 116070
pravednik
,

update 
  
, 
set
 _ = (Select .||'.'||.||'.'||.||' .'||.||' .'||.||' .'||. from  ,   where 
._ = .(+)) ;



pravednik, !!!


update 
  
set
 _ = 
(Select .||'.'||.||'.'||.||' .'||.||' .'||.||' .'||. from   where 
._ = .)
WHERE EXISTS
(SELECT NULL FROM from   where 
._ = .) ;
12 07, 09:02[4381499]      |
 Re: SQL  [new]
pravednik
Member

: Jacksonville, FL
: 16268
dmidek, ....

--------------------------------
-, -, - .
12 07, 09:06[4381508]      |
 Re: SQL  [new]
Elic
Member

:
: 29976
dmidek
outer-join- - . :)
update   
  set ._ = 
    .||' .'||(Select . from   where . = ._)
    ||' .'||.||' .'||.||' .'||.||' .'||.;
12 07, 09:20[4381587]      |
 Re: SQL  [new]
dmidek
Member

: -
: 116070
Elic
dmidek
outer-join- - . :)
update   
  set ._ = 
    .||' .'||(Select . from   where . = ._)
    ||' .'||.||' .'||.||' .'||.||' .'||.;


!
-
12 07, 09:21[4381592]      |
 Re: SQL  [new]
_Oracle_Forms
Member

:
: 229
...
12 07, 13:35[4383563]      |
/ Oracle