Questions tagged as 'oracle'

Tagged questions
1
answer

User permissions between oracle databases

I appreciate your collaboration with the following situation. I have two different databases (ex: orcl1 and orcl2 ), the database orcl1 has several users-schemas ( esquema1 , esquema2 ), the database orcl2...
asked by 19.10.2018 / 20:51
2
answers

How to concatenate a varibale int and str in a trigger?

I'm doing a trigger in sql which concatenates a word with a number, so this is: create or replace trigger TG_curso_Auto before insert on cursos for each row declare var int; begin select count(*)+1 into var from cursos; :new.siglas :...
asked by 10.11.2018 / 04:26
1
answer

How can I know if a txt file exists from PLSQL

I have the following problem, I am creating a Trigger in Oracle so that I write information in a txt file, up to here everything is fine, I can write without dramas, the problem is when I need to add information to the file, apart from the one t...
asked by 27.05.2018 / 00:26
1
answer

How to change the width of the columns (widht) with bootstrap 4

Good morning, colleagues. I have a problem, the client wants to assign the default column width, with values that already come by default in the database. I am already obtaining the data of the values of the titles. And I already have the tab...
asked by 15.02.2018 / 16:33
1
answer

Problem with bindParam: "ORA-01745: invalid host / bind variable name"

I am trying to insert a user and his password into my Oracle database. When I insert a basic name and password, all right. But when I try to insert a user, with a password hasheada, I do not get an error, but it does not do anything to me either...
asked by 13.02.2018 / 11:08
2
answers

problem when saving records with fetch - error Undefined index

Hi, I have problems within the if (isActive ($ user)) where I want to get the values id, password, id_type, are not saving and I get this message Notice: Undefined index: id in C:\xampp\htdocs\login_oracle\funcs\funcs.php on line 291 Notice:...
asked by 13.12.2017 / 00:46
2
answers

Oracle query tabular form

start in database and I have a question, suppose I have a table called WORLD that has the following values: I want to get the following result: Could you please support me as to how this consultation would be carried out, thank...
asked by 10.02.2018 / 01:12
1
answer

How to divide fields of a table with SQL?

I have an entity or database table with records like the following: I am aware that the entity needs database normalization but at the moment I only have read permissions and I am not allowed to make modifications of this type, which wo...
asked by 03.02.2018 / 01:15
2
answers

Select the record with the highest value within a JOIN

I have a procedure with SELECT with several JOINS and, in one of them, I need to extract only one result (the most recent date) when several results can really be given. In principle, the dates will never be exact since it is stored in...
asked by 23.01.2017 / 16:37
2
answers

How to select 1 date field with 3 tags in Oracle SQL?

I'm doing query in oracle 11g and they ask me to select the last 3 dates when a client paid invoice. The query I have it like this: SELECT t1.datefield date_1, t1.datefield date_2, t1.datefield date_3 FROM ta...
asked by 28.10.2016 / 15:52