Data dodania Pytanie
2018-02-08 01:02 How to pass null value in bind variable »
This is a sample query that shows I'm trying to get the book called 'sql for everyone' with a begin_date '2018-02-02' where authName is null. This qu...
(2) odpowiedzi
2018-02-07 14:02 Oracle PL/SQL Anonymous Block to retrieve Data from Two Tables (NOVA Environment) »
Moving up in the world I'm beginning to take my first steps at PL/SQL, and I must admit I'm totally lost. Unfortunately, many of the references that I...
(1) odpowiedzi
2018-02-01 11:02 how to get the field name and value from a record dynamically »
I have a procedure which receive as input parameter a record with 170 columns (it is based on the structure of a table). In the procedure I want to c...
(2) odpowiedzi
2018-01-27 05:01 How to retrieve PL/SQL record type in SQL? »
A shared package exists which defines a student record type and a function which returns a student: CREATE OR REPLACE PACKAGE shared.student_utils IS...
(1) odpowiedzi
2018-01-26 11:01 APEX - passing substitution string in PL/SQL »
I'm having some difficulty passing session substitution strings in APEX 5. I have a process in my APEX application which will change the password of ...
(1) odpowiedzi
2018-01-19 19:01 Oracle APEX 4.2 Custom search in classic report »
I am using Oracle APEX 4.2. I want to implement a search function in my classic report. I have a working code that retrieve data and the search functi...
(2) odpowiedzi
2018-01-19 07:01 exact fetch returns more than requested number of rows in a triger execution »
I am creating a trigger for auto_generating prod_id from prod_summery the given table is PROD_ID CHAR(8 BYTE) No 1 PRODUCT_TITLE VARCHAR...
(2) odpowiedzi
2018-01-13 05:01 Dynamically convert row into columns based on the content in the cell in SQL Server & Oracle »
Using procedure i am trying to achieve below use case. Can someone please guide me. Here is the data which is present in a table Source Table : I...
(3) odpowiedzi
2018-01-12 19:01 Retrieve Oracle database name without querying »
I have two Oracle 11gR2 databases (one for testing purposes and the other is production). By using conditional compilation I need to create a functio...
(2) odpowiedzi
2018-01-10 21:01 How to return entire rows when using RETURNING INTO clause and BULK COLLECT »
I'm trying to do an update where I want to return all the updated rows. Is this possible? All I could find is returning specific columns in separate t...
(1) odpowiedzi
2018-01-06 18:01 Table is mutating. Trigger may not see it (Even on different tables) »
I have two tables: Group and Schedule. The Group table consists of columns: Group_Name, No_of_member. The Schedule table consists of column: Group_Na...
(1) odpowiedzi
2017-12-28 02:12 Why can't we drop a referenced Type unlike other schema objects »
When a Type which is having dependents is tried to drop or replace, oracle throws below error. Unlike for the other schema objects (like procedures) w...
(1) odpowiedzi
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-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-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-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-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-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 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 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-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
2017-12-11 14:12 how to insert Hierarchical data from xml to oracle tables »
I have a situation were I have to read hierarchical data from the xmltype and insert it into different tables. Flowing is the xml sample. <AH0>...
(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 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 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-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-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-26 05:11 Using COUNT(*) and INTO oracle sql »
I have select statement like this: with input as (select id,date,quantity from abc a,xyz z .......) select count(*) ...
(1) odpowiedzi
2017-11-25 01:11 PL/SQL ORACLE: Trigger updates on delete »
I am trying to make a trigger that increases the booked value and decreases the available value whenever new record is inserted inside the table ticke...
(1) odpowiedzi
2017-11-22 00:11 Select top N columns based on standardized values »
Got a bit of googly question. Is it possible to select say 10 columns based on the values in each column if all the values are standardized. So for ...
(2) odpowiedzi
2017-11-21 08:11 Oracle Database PLSQL Subtype of certain characters »
I want to make a subtype in PLSQL which can only hold this values: '♠', '♥', '♦', '♣' Is this possible? In my code I have subtype suit_t is ch...
(1) odpowiedzi
2017-11-17 16:11 How do I set LINESIZE and PAGESIZE with a substitution variable? »
I am trying to use a PL/SQL script in SQL*Plus to set the linesize and pagesize based on a developer input on whether a report should print in landsca...
(2) odpowiedzi
2017-11-17 01:11 Reorder to some items and changing primary key »
I've a table MENU_ITEMS with a column SEQ to define the position at which each item should be displayed in a menu. Simplified for the sake of this qu...
(2) odpowiedzi