Data dodania Pytanie
2017-03-16 14:03 DDL Trigger which grants permission to new created users »
I got a question, is there a possibilty, that a DDL Trigger can grant roles right after the user is created. For example: CREATE OR REPLACE TRIGGER ...
(1) odpowiedzi
2017-03-16 09:03 Completing the missing rows when outer joining to a table of counts »
I have a problem with an OUTER JOIN not providing enough empty rows. The business context is users starting (and hopefully finishing) online tests. E...
(2) odpowiedzi
2017-03-16 03:03 How will I remove nulls from each columns »
How will I remove nulls from each columns This is the example Column 1 Column 2 column 3 column 4 a 1 null null b ...
(1) odpowiedzi
2017-03-15 17:03 Oracle timestamp with local time zone values transparent translation »
As far as I know, TIMESTAMP WITH LOCAL TIME ZONE values are transparently translated to and from the user's session time zone. But my values read from...
(2) odpowiedzi
2017-03-15 16:03 Remove invalid XML characters from XmlElement function »
I have a table (called SMARTDATA) that stores long notes by splitting them into 512-character lines: ID NOT NULL NUMBER(18) LINE NOT NULL NUM...
(0) odpowiedzi
2017-03-15 13:03 Inner Joins and retrieving the parent record if only its children record met certain criteria »
Table CP CP_Name CP_Number CP_PK ------- --------- ----- AA 111 123 BB 222 124 CC 333 125 DD ...
(3) odpowiedzi
2017-03-14 16:03 Oracle - conditional on first row of each group »
Edit - On Oracle 11 & 12. Say I have: ID | Name | Type ---------------- 1 | AAA | 1 2 | AAA | 2 3 | AAA | 3 4 | BBB | 2 5 | BBB | 3 6 ...
(2) odpowiedzi
2017-03-14 05:03 Need to write subquery to calculate income for each month »
My table is like summa_som date_operation ----- -------------- 100 11/03/2005 500 13/07/2008 900 12/11/2015 Expe...
(2) odpowiedzi
2017-03-14 01:03 Generating string of numbers in random order »
I need to generate a string of the numbers 1-3 with the numbers in random order for each row selected from a table. I have tried the following, but a...
(2) odpowiedzi
2017-03-13 14:03 utl file frename (mv) doesn't work - 29292 »
I have a a shared sftp directory mounted \xx.xx.xx.xx\SFTP_AX\ /sftp/ cifs user,uid=54321,gid=54321,suid,username=user,password=pass,workgroup=...
(0) odpowiedzi
2017-03-13 11:03 updating last 2 char in varshar »
I want to make this update update c_order set documentno = 'OV1036477' where documentno = 'OV1036503'; update c_order set documentno = 'OV1036476' w...
(3) odpowiedzi
2017-03-13 08:03 ORA-00918: column ambiguously defined when choose a list of paramlistpa »
I know this question has been asked multiple times before, but I've seen every discussion about this here but none could help me to solve my problem. ...
(0) odpowiedzi
2017-03-12 12:03 Printing Non Repeating Characters first »
I am new to PL/SQL and I am trying to write a procedure which would print the non repeating characters of an input string first and Repeating characte...
(5) odpowiedzi
2017-03-12 10:03 How to store periodicity in Oracle? »
Which column type should be used to store a periodicity in Oracle? Daily: time, e. g. "14:00" Weekly: day of week, time, e. g. "Mon 14:00" Monthly:...
(0) odpowiedzi
2017-03-12 01:03 Oracle SQL - how to select and combine data from multiple rows »
The scenario is that for a particular date range, I need to return all rows where a field value has changed (FROM and TO date). The changed field valu...
(2) odpowiedzi
2017-03-11 17:03 difference between null vs white space? »
suppose if i create a table with primary key I can't insert null and duplicate values. But i can insert white spaces. eg: insert into table_name valu...
(3) odpowiedzi
2017-03-11 12:03 How do i add a constraint in Oracle SQL to limit a value? »
How can i set a column in oracle to not accept numbers above 10000 and below 0? ...
(1) odpowiedzi
2017-03-11 06:03 How to parse below xml in oracle sql »
<root> <transactiondata> <Info> <![CDATA[1234ABCD]]> <Details> <Data Name="Names"> <FirstNam...
(1) odpowiedzi
2017-03-10 19:03 Convert Varchar2(24-JAN-2016) to number (YYYYMMDD »
I want to convert varchar2(24-JAN-16) to number(20160124) in Oracle and Datastage. Can you help me? Thanks in advance. ...
(1) odpowiedzi
2017-03-10 14:03 how to write a search query in SQL »
I want to write a search query. I have the following scenario. There are 3 criteria (ID, NAME , CITY) for searching the result. example: IF the use...
(4) odpowiedzi
2017-03-10 09:03 Error: Validation Failed Oracle Storage Cloud Service container name must be in the format »
I am getting the following error when creating a oracle database backup service. Oracle Storage Cloud Service container name must be in the format ht...
(1) odpowiedzi
2017-03-09 20:03 How to simplify nested select in where clause? »
I have 4 tables EMPLOYEE, COMPANY, WORKS and MANAGES. The tables are defined as follows- CREATE TABLE EMPLOYEE ( EMPLOYEE_NAME VARCHAR2(50) NOT NULL ...
(4) odpowiedzi
2017-03-09 19:03 Query to remove all non-digit but only keep last period/dot »
Struggle to design a regular expression to filter field value from varchar2 to number, so that it can remove all non-digit and only left the last peri...
(2) odpowiedzi
2017-03-09 12:03 Getting same instance with filter and filter_by using different ID strings »
query 1 style_id = u'373401' self.session.query(ChromeYearMakeModelStyle).\ filter_by(chromestyle_id=style_id).one() ChromeYearMakeModelStyle(3...
(1) odpowiedzi
2017-03-08 14:03 Speeding up update with custom function in WHERE clause »
I have a function, that checks if input ISBN code is valid or not, according to the wiki page (https://en.wikipedia.org/wiki/Check_digit): create or ...
(5) odpowiedzi
2017-03-08 12:03 Nested Case for hard coding result of a case statement »
I have a dataset similar to this; col1 col2 col3 1 YES NO 2 NO YES I am trying to apply case statement, case when col1 = 1 then col2 ...
(1) odpowiedzi
2017-03-08 10:03 Select query with join in ORACLE »
I have four tables as table map old_ac fin_ac 07063501 3435853 12522201 1737631 14195701 2515535 table gam fin_ac cif aci...
(2) odpowiedzi
2017-03-07 18:03 Dynamic column alias in PLSQL »
Is there a way to dynamically create an alias in pl/sql? I have a table ABC Field1 Field2 Field3 Field4 Joe Doe $45.00 XXX Jane ...
(1) odpowiedzi
2017-03-07 10:03 Change Oracle User Password Expiry Date »
I have got oracle User Password Expiry date using, Select Expiry_date from USER_USERS; I want to throw a warning message when Password is about to e...
(1) odpowiedzi
2017-03-07 08:03 Query for schedule date comparison »
I have a table like this: account number(repeat) | schedule_due_date ---------------------- | ----------------- 111 | '01-FEB-2017...
(2) odpowiedzi
2017-03-06 16:03 SQL - find exact group of records in large table »
I have following data: ID --- GRP_ID --- REC_VAL 1 --- 1 --- A 2 --- 2 --- A 3 --- 2 --- B 4 --- 3 --- A 5 --- 3 ...
(1) odpowiedzi
2017-03-06 14:03 How to extract XML Value in Oracle Database »
I have a table in an Oracle 12c Database that contains a XML Type Column and i need to extract a value from this Column. Here an example of this Colum...
(1) odpowiedzi
2017-03-06 12:03 What will be the ORA code if the Stored Procedure executes nothing? »
I have a Stored Procedures which I am calling from Java code. There is an IF block and that IF condition is false the procedure executes nothing. So w...
(2) odpowiedzi
2017-03-05 21:03 Best method to select values present in one table but missing in another one? ORACLE »
My solution: Table name : HW1_PERSON, hw1_sfaff SELECT I.ID,person.person_id FROM HW1_PERSON LEFT JOIN HW1_STAFF ON I.ID=person.person_id WHERE ...
(2) odpowiedzi
2017-03-05 17:03 Concat function is not working - invalid number of arguments »
I have a table with two columns(Name, Occupation). I want to output the value in a format something like this. Jane(A) Jenny(D) Julia(A) Hear Fir...
(2) odpowiedzi