Questions tagged as 'pl-sql'

Tagged questions
1
answer

Error comparing dates ORA-00932

I'm having a problem comparing 2 dates in oracle. I am using the case method to compare the dates and at the end this should return to my table a number, which in the case represents an age, however, I get p error reporting: PL / SQL: ORA-009...
asked by 21.07.2014 / 14:43
1
answer

Help! How does this select work?

Help me understand how this works please. It turns out that I'm starting the SQL studies and hackerhank has an exercise that needed this code: SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE(LOWER(CITY), '^[aeiou]') ; After a...
asked by 17.05.2018 / 16:02
1
answer

Consider the final validity until the next day at 03 AM using PLSQL

Personal, I need to do the following validation: When a record enters my database, I need to validate the effective date of this record. If the validity is between the current date then the record is valid. Ex: Effective 12/03/2015 to 03/...
asked by 13.03.2015 / 13:40
0
answers

Oracle, how does the no_proxy_domains parameter of UTL_HTTP.set_proxy work?

UTL_HTTP , we have the set_proxy method in it a no_proxy_domains parameter , how this works. In short, I want to request a URL without requiring authentication.     
asked by 07.03.2017 / 19:40
2
answers

Oracle reference the type of a column equal to the type of another column

I'm trying to create a table to return in a function. For this, I'm trying to create a object type like this: create or replace type relatorio as object ( planta TABLE_NAME.COLUMN%TYPE, resp_0 TABLE_NAME.COLUMN%TYPE ); But you...
asked by 17.03.2017 / 19:51
2
answers

SQL: Doubt in Relationship between Tables

I'm creating an academic system that consists of a virtual restaurant menu type, so I've created three tables in the database: Menu Items Table: CREATE TABLE ITEMS( ID INT PRIMARY KEY NOT NULL, NOME VARCHAR(20) NOT NULL, DESCRIC...
asked by 05.09.2017 / 13:48
4
answers

Find the best-selling item together with a certain item [duplicate]

To explain, I prefer an example: I want to find out which item is best sold along with salted chicken. For this, I tried the following approach and failed miserably due to lack of technical knowledge: -Find all coupons (sales) that...
asked by 04.08.2017 / 07:06
4
answers

How to do an update with inner join in Oracle

Good afternoon, How do I update with inner join, since I need to change the field idnaoleitura = 24 to idnaoleitura = 0 where the idrota in (35,45,48,53,60,68,70,79), remembering the idrota is in another table. The calculating_table_count...
asked by 15.07.2014 / 18:07
2
answers

My dbms output is not displayed

I'm testing a simple output of DBMS in SQLDeveloper. I created the connection, I executed set serveroutput on to enable the DBMS outputs, but when I run my anonymous code block, in Saída do Script it displays the mess...
asked by 27.11.2017 / 17:56
2
answers

Select all references to the given table (foreign key)

I need a way to select all the foreign key of a particular pk . In other words, I want to get a particular primary key and select all the foreign keys that "point" to it. Preferably I want to get the name of the column that has the k...
asked by 08.10.2015 / 15:51