Data dodania Pytanie
2017-12-09 20:12 ORA-00907: missing right parenthesis Developer »
What could be the problem? CREATE TABLE ASIGNACION_ANUAL( ANIO NUMBER(4), COD_VENDEDOR VARCHAR2(4), MONTO_ASIGNACION NUMBER(9) NULL_MONTO, CANT_VENTA...
(1) odpowiedzi
2017-12-09 17:12 Schedule Oracle backup »
What is the correct and best approach for backing up oracle automatically? Which one should be use for schadule backup: - Using oracle jobs OR - Using...
(1) odpowiedzi
2017-12-09 16:12 type mismatch found at 'EMPTYPE' between FETCH cursor and INTO variables »
create or replace type emp_obj as object(empno varchar2(500)); create or replace type emp_table as table of emp_obj ; Procedure create or replace...
(2) odpowiedzi
2017-12-08 23:12 ORA-00907: missing right parenthesis SQL Developer »
I need to know why I get a parenthesis error in this part of the code. CREATE TABLE CIUDAD( COD_CIUDAD NUMBER(3) CONSTRAINT CIUDAD_PK PRIMARY KEY (CO...
(2) odpowiedzi
2017-12-08 17:12 How to sum column values from two tables and preserve another column which is only in one table »
i have created tables item and item2, I know maybe it's data redundancy but i want to know how can select it, and create a view? create table item( ...
(3) odpowiedzi
2017-12-08 00:12 Oracle uses exception handler from first block in later blocks »
I'm running into a behavior where I'm trying to use case-specific exception handlers for several Oracle PL/SQL blocks in a Flyway script and Oracle, a...
(1) odpowiedzi
2017-12-07 18:12 oracle sql request column ambiguously defined »
I am working on oracle 11g and tried to execute this request select code_mod,INTITULE,code_et,nom ,avg(note) from note,exam,module,etudiant where not...
(2) odpowiedzi
2017-12-07 11:12 ORA-01843: not a valid month error in oracle while updating »
I want to update my date column with the format as dd-mm-yy. And in my database the column is of date datatype. So while Updating I am sending data as...
(3) odpowiedzi
2017-12-07 10:12 local collection types not allowed in SQL statements - Oracle »
SET SERVEROUTPUT ON; DECLARE type r05_id_type is TABLE of r01_table.R01_ID%TYPE; r01_ids r05_id_type; BEGIN SELECT r1.r01_ID as R01_ID BULK...
(1) odpowiedzi
2017-12-06 19:12 Why can't I call my function in a SQL statement? »
I create a package that executes my function in a SELECT statement right inside that same page: CREATE OR REPLACE PACKAGE p AUTHID DEFINER IS F...
(1) odpowiedzi
2017-12-06 17:12 ORA-01748: only simple column names allowed here in Oracle »
What I am trying to do ? I am trying to create two tables and at the same time i am trying to link them together using foreign and primary keys. Howe...
(2) odpowiedzi
2017-12-06 12:12 Parameter.AsString failing under Oracle/MSSQL - Parameter.Value 2-byte chars under Oracle »
After changing to FireDAC I have trouble getting this code to work on MSSQL/Oracle: with DataFormsettings do begin Close; if Params.Count=0 then ...
(1) odpowiedzi
2017-12-05 23:12 how to use connect by method dynamically »
How to achieve the following I've got a query: select sr.source_rel_id, sr.source_rel_start, sr.source_rel_end, sr.source_rel_...
(2) odpowiedzi
2017-12-05 10:12 merge data from rows to columns »
I have a source table like so: id | code | description | parent_code | level 1 111 testone null 1 2 222 testtwo nul...
(1) odpowiedzi
2017-12-05 09:12 Oracle DB to_date with year - to_date(2017,'YYYY') unexpected return »
While writing few queries I needed to return only those rows that have date column set in this year (2017) , that's not my problem I know how to writ...
(2) odpowiedzi
2017-12-04 21:12 Split rows in limited size buckets »
I have a table with thousands of records, I want to associate each row with a bucket and each bucket has a maximum of rows associated to it. I'd love...
(1) odpowiedzi
2017-12-04 19:12 SQL- how to retrieve by similar dates »
Okay, so I have a table with a user_id column and a submitted_dtm column. I want to find instances where users submitted multiple records within 1 d...
(4) odpowiedzi
2017-12-04 17:12 How to select max price using multiple query »
i have create tow table, table and data inserting value are given below : create table product ( pid number(10) primary key, pname varchar2(30) ); ...
(2) odpowiedzi
2017-12-03 19:12 SQL trigger on delete mutating table »
I have to do a project for school and I got stuck at a question. I have created the following tables: Flights(flight_id, from, to, distance, departure...
(1) odpowiedzi
2017-12-03 16:12 How to join more than two levels of join in oracle »
I have below tables 1.student(student_id,student_name) +------------+--------------+-----------+ | student_id | Student_name | class | +-------...
(1) odpowiedzi
2017-12-03 14:12 SQL allowing an entity to participate in a relationship only if it meets certain requirements »
I have a practice Super Hero SQL database with a SuperPerson table and a Disaster table. There are two relationships between SuperPerson and Disaster,...
(1) odpowiedzi
2017-12-02 20:12 count of columns having a particular flag in oracle »
I have a table with 10 columns to store flags which can only be Y or N against a name like below NAME FLAG1 FLAG2 FLAG3 FLAG4 FLAG5 … ...
(2) odpowiedzi
2017-12-02 17:12 Oracle sql Join tables based on one table containing the word in the field of another table »
I'm trying to join two tables together as follows. Table A Table B Field1 Field1 GO GO FOREGO OK GO I only want to join ...
(2) odpowiedzi
2017-12-02 12:12 SQL/Oracle: Is it possible to have a group function in a check constraint? »
My Tables are: CREATE TABLE member ( svn INTEGER, campid INTEGER, ...
(2) odpowiedzi
2017-12-01 15:12 JPA (Hibernate): "ORA-02289 Sequence does not exist", but it does »
I'm working with JPA entities. I created a new one like this: @Entity public class Entity { @Id @GeneratedValue(generator = "Entity_Sequenc...
(1) odpowiedzi
2017-12-01 12:12 Inserting timestamp with timezone in text in SQL »
I created an insert statement that inserts the current time into a field with datatype: TIMESTAMP(6) WITH TIME ZONE insert into( ... ) values( 9...
(1) odpowiedzi
2017-12-01 01:12 oracle column not allowed here »
I got this error: Error report - ORA-00984: column not allowed here ORA-06512: at line 14 00984. 00000 - "column not allowed here" here is the cod...
(1) odpowiedzi
2017-11-30 14:11 PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_oci8_12c.dll' - The specified procedure could not be found »
we face a big problem to connect oracle server in php What i done Setp 1: Install Windows 7 32bit Step 2 : install XAMPP 32 ( Includes: Apache...
(1) odpowiedzi
2017-11-30 11:11 Increment row number on group with repeated groups »
I am working on a query for PLSQL (Oracle 12), in which I need to increment the row number of a dataset for each group. My problem is similar to thi...
(1) odpowiedzi
2017-11-30 06:11 Check equals between multiple columns values in a row? »
quick question here I have a table like this COLUMN_1 COLUMN_2 COLUMN_3 COLUMN_4 COLUMN_5 SAME X1 X1 X1 X1 X1 X1 X1 ...
(4) odpowiedzi
2017-11-29 22:11 Would null value change the average? »
What will be the result of this query? (Oracle SQL) SELECT TO_CHAR(AVG(TEST_SCORE),'999,999.99') FROM SCORES; If the values of TEST_SCORE are (...
(2) odpowiedzi
2017-11-29 22:11 Query from a function »
I have this query Select distinct a.name, p1.ref as book, p2.ref as text, p3.ref as note from library a left join room p1 on a.id=p1.id left join r...
(1) odpowiedzi
2017-11-29 21:11 Converting Oracle to MySQL : Different Outputs Seen »
I have an SQL query from Oracle which I am trying to convert to MySQL. Below is part of the query from both. The database structure is different henc...
(1) odpowiedzi
2017-11-28 22:11 How to display an attribute from one table using an ID from another »
I have the following tables in an Oracle database: CREATE TABLE Team ( teamID INT NOT NULL, teamName VARCHAR(50), wins INT, losses INT, ...
(1) odpowiedzi
2017-11-28 15:11 Oracle order. First letters and after numbers »
I have a Spring Boot appl. that uses JdbcTemplate to access an Oracle DB I am working on a Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 -...
(1) odpowiedzi