python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - plsql

update a record from a table with another table's data then return the result

As I said in the title, I need to "update a record from a table with another table's data then return the result". I want change multiple rows and I already accomplished that with this query...
test-img

murilo tegani

sql

oracle

plsql

Votes: 0

Answers: 2

Latest Answer

Works for me, after removing the 'into info' from the subquery: create table demo (id, val) as select rownum, column_value from sys.ora_mining_varchar2_nt('Red','Yellow','Orange','Blue'); select *...
test-img

William Robertson

How to select the a field of an object being a field of a table?

to test the code: https://dbfiddle.uk/?rdbms=oracle_21&fiddle=8cf685ff21a69c5e83a9861a56a71cbb I have a table. One of its fields is an object. I only want to select a field of this object. create ...
test-img

Pierre-olivier Gendraud

oracle

plsql

Votes: 0

Answers: 1

Latest Answer

Give the subquery an alias and then reference the alias: with b(c) as ( select a(2) from dual ) select b.c.a from b b Note: Yes, I gave it the same alias as the table name. It might be less confu...
test-img

MT0

Check oracle table for an expiry date and send mail

I have a table pro where I have following fields id, product name, email and expiry I am trying to send an email from oracle when expiry date match with system date. Is it possible through oracle job...
test-img

Jeremy

oracle

plsql

Votes: 0

Answers: 1

Latest Answer

You can use the query below to find a list of users. In my example, I have 120 days so modify it to fit your needs. In addition, you will need a place to store the email address for each user than JOI...
test-img

Pugzly

Oracle PL/SQL. SELECT with AND condicionated

I want to do a Query like this: v_name VARCHAR2(60); SELECT * FROM book WHERE name = v_name But if "v_name" is NULL, the program must be: SELECT * FROM book I don't wan't to set the filter ...
test-img

Samuel

oracle

select

plsql

where-clause

Votes: 0

Answers: 3

Latest Answer

One way to match null with all books when v_name is null or match only a book (assuming NAME is unique) when v_name is not null is to do it by typing fewer characters: select * from BOOK where v_na...
test-img

Jeff Holt

Posts

Questions

Blogs

Jobs