Data dodania Pytanie
2017-12-25 11:12 Declaring a cursor after begin in oracle forms 10g »
I am writing the following code block : select companyid into compid from person where signedin = 1; cursor getpending is select serviceid from servn...
(3) odpowiedzi
2017-12-24 17:12 ORA-02291 parent key not found, first »
My first programming program is an Oracle Database graduate certificate program, and the textbook is not Oracle friendly in some places (it is a gener...
(1) odpowiedzi
2017-12-24 12:12 Do DB trigger conditions improve performance? »
I know that a DB trigger condition can only be a SQL expression and that it cannot include a subquery. However, inside the trigger code it is possible...
(1) odpowiedzi
2017-12-24 11:12 hiding multiple tabs is oracle forms 10g »
I have a canvas that contains multiple tabs, and I am writing a trigger that hides some of these tabs when a certain condition is met. Here is my pl ...
(1) odpowiedzi
2017-12-23 09:12 insert / retrieve Arabic data on Oracle 12c »
I am facing an issue getting Arabic content from Oracle Database 12c, I've followed most answered questions but nothing is working with me. my Arabic...
(3) odpowiedzi
2017-12-23 07:12 SQL Group By + Aggregate functions with joins »
I have two tables: 1. EMPLOYEE_DATA and its columns as EMP_ID MANAGER_ID 9999 2222 8888 2222 7777 2222 Another table is : 2. EMPLOY...
(6) odpowiedzi
2017-12-23 04:12 How do I display a nested table in Oracle - PL/SQL? »
I have an assignment where I'm supposed to create a user-defined function that will return all employees after 1968. My code is as follows: First I c...
(4) odpowiedzi
2017-12-22 14:12 Convert Oracle tables into JSON »
I'm using Oracle 12.1 Standard Edition Two and I have the following three tables: **UserDetailsTable** User_ID User_Name User_Age User_Gender User...
(1) odpowiedzi
2017-12-22 13:12 How to declare null column in SQL oracle in Select statement »
I'm trying to create a NULL column in the SELECT statement but it doesn't work: SELECT mytable. *, NULL as ColumnName FROM mytable; The error code ...
(1) odpowiedzi
2017-12-22 08:12 Datatype changed after IMPORT of schema »
please advice on EXPDP and IMPDP utilities, Oracle 12c DB administration. We exported schema TEST (DB 11.2.0.4) using EXPDB utility and imported dum...
(0) odpowiedzi
2017-12-21 18:12 Get the first 3 elements for each value of an attribute SQL »
I'm using the mondial database that can be queried here http://www.semwebtech.org/sqlfrontend/ I am trying to get the 3 religion that are most prat...
(1) odpowiedzi
2017-12-21 18:12 How to delay a command substitution in a shell script? »
I have a bash script that in a nutshell generates a file via other command (works fine) and then later in the script I do a wc command on the file gen...
(1) odpowiedzi
2017-12-21 08:12 Oracle 12c Insert without indexing but search with index »
I have a big database with a huge table consisting 80+ fields and 250million of rows. It also has 35 indexes! This is a big system and cant be shutdo...
(0) odpowiedzi
2017-12-20 12:12 Oracle, Regexp, string separated via semicolons »
I have this Query: SELECT ROWNUM AS num_row, REGEXP_SUBSTR(REPLACE('param1;param2;param3;;param5;;param7;;;param10;param11;param12;param13;par...
(1) odpowiedzi
2017-12-20 11:12 Speed up updates on Oracle DB which a lot of records »
I have to update table which has around 93 mln records, at the beginning DB updated 10 k records per 5 seconds, now after around 60 mln updated record...
(1) odpowiedzi
2017-12-20 10:12 Calculate difference date time for each record per month »
Let's suppose I have the following table. How can I can separately calculate the delay for each month. Req start_dt end_dt 1 1/2/2017 3/5/20...
(2) odpowiedzi
2017-12-19 18:12 Can I use Oracle Pipelined Function like a select in QueryDSL? »
For a specific reason of a requirement, instead of using a VIEW, I use an Oracle pipelined function to get data in a table. It works perfectly using ...
(0) odpowiedzi
2017-12-19 17:12 How to load large .sql script against oracle database using JDBC »
I have a sql script for oracle database: set define off; CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "XYZ" AS import javax.crypto.SecretKey...
(0) odpowiedzi
2017-12-19 05:12 ORA-14763: Unable to resolve FOR VALUES clause to a partition number »
I have partitioned my table on daily basis. TABLE NAME MY_TABLE COLUMN NAME IN_TIME TIMESTAMP I want to fetch the rows for the last 2 days partitio...
(2) odpowiedzi
2017-12-18 18:12 How to find non-numeric columns containing only numeric data? »
I like to find all columns in my Oracle database schema that only contain numeric data but having a non-numeric type. (So basically column-candidates ...
(3) odpowiedzi
2017-12-18 16:12 PL/SQL - SQL dynamic row and column parsing »
I took a look into the forums and couldn't really find something that I needed. What I have is two tables one table with (Parse_Table) File_ID|Start...
(2) odpowiedzi
2017-12-18 13:12 Check before delete or just delete row? »
I have table table_name with PK(id1 VARCHAR2(10), id2 NUMBER, id3 NUMBER) This table only grow ~ 1 million records each year. The problem is that in...
(2) odpowiedzi
2017-12-17 20:12 Recursive Oracle query to calculate two values that depends on each other »
I have this table with materials stock data: Date(MM/DD) |received_qty| returned_qty | used_qty 01/01 | 5000 | 0 | 3500 01/02...
(1) odpowiedzi
2017-12-17 10:12 Understanding MultiSet in Oracle & advantages,importance of it »
I have seen a lot of answer's using Multiset & AS SYS.ODCIVARCHAR2LIST etc.. and I am not able to understand the logic behind/ how it works out. P...
(2) odpowiedzi
2017-12-17 07:12 Retrieve data from Oracle Database at specific datetime then post them to firebase in php »
Describe the project idea: I am working on system that is running on Oracle database 8i version. where I would like to execute a query that is runnin...
(1) odpowiedzi
2017-12-16 22:12 Find cycles in directed graph using MODEL clause »
I have a table with two columns U and V, where row with values ('a', 'b') means that there is an edge from vertex 'a' to 'b'. I can easily find cycle...
(1) odpowiedzi
2017-12-16 20:12 Oracle endeca partial update changes not reflecting in endeca ref app »
I am trying to implement oracle endeca partial update . My changes are visible in the forge output file which is placed in the dgraph_input/updates di...
(1) odpowiedzi
2017-12-16 15:12 PL/SQL procedure that will go through inventory one by one looking for item and updates accordingly »
I have an inventory table like below: warehouse_no|item_no|item_quantity ------------|-------|------------- 1 | 1000 | 300 ------...
(4) odpowiedzi
2017-12-14 21:12 If statement in Oracle sql »
I want a column that just displays good or bad based on the condition: select (if (salary>10000) then 'good' else 'bad')as "Grade" from employees;...
(5) odpowiedzi
2017-12-14 16:12 how can i find which attribute value only contain one type of value? »
My question may not be clear, but basically I have a table with zip codes, and I need to find the zip codes where all my records indicate there are on...
(4) odpowiedzi
2017-12-14 08:12 Moving huge number of data in chunks »
I am working on a script where a huge number of data should be queried based on some conditions and moved to some archive tables respectively. I have ...
(2) odpowiedzi
2017-12-13 15:12 Difference Between SQL Expressions and Conditions »
From what I understand, conditions are statements that evaluate to true, false, or unknown. I don't understand how this differs from a SQL expression,...
(2) odpowiedzi
2017-12-13 14:12 PL/SQL Procedure, raise no_data_found during insert »
So here is the code as given to me in my oracle class: CREATE OR REPLACE PROCEDURE add_job_hist (p_emp_id IN employees.employee_id%TYPE,...
(1) odpowiedzi
2017-12-13 13:12 SQL : Find the position of a character in a string value »
I have a column with below sample values MyColumn ---------- NNNNNYYNNNNNYYNNNNNYYNNNNNYYNNN NNYYNNNNNYYNNNNNYYNNNNNYYNNN YYNNNNNYYNNNNNYYNNNNNYYNNNN...
(1) odpowiedzi
2017-12-11 20:12 Oracle count(*) returns different value for aggregate functions »
Can anyone explain why the same query returns a different count depending on if an aggregate function is used? --Returns 1 select count(*) from ( ...
(1) odpowiedzi