Data dodania Pytanie
2017-10-09 21:10 Oracle: select from title ok,select from view..0 rows »
On my oracle db. I have this table desc titolo IDTITOLO NOT NULL NUMBER(11) TITO...
(1) odpowiedzi
2017-10-09 19:10 Oracle - Audit Trail Generator? »
I am looking for a generic procedure that will generate audit trails for Oracle databases. We are currently using a similar procedure on SQL Server an...
(1) odpowiedzi
2017-10-09 15:10 How to configuration DataSources on Weblogic persistence.xml »
I have a persistence.xml this -> <?xml version="1.0" encoding="UTF-8"?> <persistence version="1.0" xmlns="http://java.sun.com/xml/ns/per...
(0) odpowiedzi
2017-10-08 22:10 Using 2 explicit cursors. »
*/I am trying to use 2 explicit cursors, it shows these errors {:ERROR at line 42: ORA-06550: line 42, column 1: PLS-00306: wrong number or types o...
(1) odpowiedzi
2017-10-08 10:10 Fetch column with maximum value for a column & then maximum value of another column »
My Table: create table temp_table_name (seq number(10), start_Date date, end_date date, param varchar2(10)) My PK: alter table temp_table_name ad...
(0) odpowiedzi
2017-10-08 06:10 Use netbeans to create oracle Jet application: Project folder is already NetBeans project (maybe only in memory) »
I can not create a O-Jet application because of "Project folder is already NetBeans project (maybe only in memory)." issue. I have googled this issue ...
(2) odpowiedzi
2017-10-07 13:10 Need ALTER TYPE query to update a existing field in existing object »
I have already created a TYPE object Example1 using the following query CREATE OR replace type example1 AS OBJECT ( emp_name varchar2(32), emp_...
(1) odpowiedzi
2017-10-07 13:10 How to get rows matching a condition using a hierarchical query »
Consider the following query from Oracle documentation https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries003.htm SELECT employee_id, last...
(1) odpowiedzi
2017-10-07 08:10 How to schedule Oracle DBMS Jobs in a window »
I want to create an Oracle DBMS Job that runs every week day (not on weekends) from 09:00 to 20:00 every 10 min. I wonder if I can do that in the FREQ...
(2) odpowiedzi
2017-10-06 17:10 How to get user defined OPERATORs in oracle »
I have been racking my brain for some time but I am unable to find a way to retrieve the Operator definition in either Toad or SQL Developer. We have...
(1) odpowiedzi
2017-10-06 10:10 Oracle 11g: query performance optimization »
I have performance problem with this specific query: SELECT ID, NAME, CREATION_DATE, MODIFICATION_DATE, CREATION_USER, ...
(1) odpowiedzi
2017-10-06 00:10 Using "BEGIN" keyword improperly »
I am getting an error in the code below. I have added an arror <------ where the problem is. The error message says that a THEN is expected, but w...
(3) odpowiedzi
2017-10-05 17:10 ORA-00917 Escaping apostrophe in sql query »
Below code works fine for most of the cases. It blows up when LIB_SEGCO has any single quotes such as ABC'DEF In these cases it gives error ORA-00917...
(1) odpowiedzi
2017-10-05 09:10 JDBC PrepareStatement parameters do not work for CREATE, DROP, ALTER »
I need to use JDBC to create a new Oracle user. The user name and password of the new user are provided by the user via a GUI. The following codes wor...
(1) odpowiedzi
2017-10-05 02:10 Using count my tuples are coming out as 1's when a 0 should be present? »
I am trying to count how many times each ID appears in a specific table as follows. Members ID | NAME 1 | Bob 2 | John 3 | Sally 4 | Hannah Depa...
(1) odpowiedzi
2017-10-04 17:10 Equivalent to SQLERRM when no error? »
Does anyone knows if there is an equivalent to SQLERRM when no error occurred? I know I can count the affected rows like here, but can I automaticall...
(2) odpowiedzi
2017-10-04 12:10 Merging multiple sql update statements(Oracle) »
I'm not very good at sql and I've tried a few things. What would be the best way to combine these 5 update statements into a single statement consider...
(3) odpowiedzi
2017-10-04 11:10 Reading Oracle htp.p output into Java app »
We have built a dynamic stored proc reader due to the nature of our system. The only issue I have left is I am unable to read the htp.p output back in...
(0) odpowiedzi
2017-10-03 18:10 ansi SQL date function in Oracle »
I realize I could use a combination of to_char and to_date and what not as a work-around, but I'm trying to figure out why this doesn't work. I am usi...
(1) odpowiedzi
2017-10-03 13:10 Filter by numeric column start with a given number »
I'd like to filter my rows based on a numeric column. Problem is that the input is a pattern - for e.g. - a number starting with 2045 or something. I ...
(2) odpowiedzi
2017-10-03 05:10 Compare multiple values in a single column oracle »
I want to compare multiple values of a column with a single value of another column.I had tried a lot but it gives me "No row selected" here's my sce...
(1) odpowiedzi
2017-10-02 17:10 Grouping data by name and date ranges »
I have data in my oracle table where I have names and date rages as following: Name From To Lopes, Janine 07-Jun-17 16-...
(2) odpowiedzi
2017-10-02 11:10 PL/SQL extract SELECT statement column names from custom query »
I have a custom query and I need to know how to extract colum names from this. I've already searched for any way to do it: Regex: I've build this on...
(1) odpowiedzi
2017-10-02 11:10 Dealing with changed ENUM definitions - database »
Introduction The lead architect went and changed the ENUM definition in a spring boot project. From: public enum ProcessState{ C("COMPLETE"), ...
(3) odpowiedzi
2017-10-01 21:10 Oracle LIKE condition returning empty results »
I want to run a "Like query" in sqlplus, but the query is not returning the expected results. Here is the query. select * from field where id like 'D...
(2) odpowiedzi
2017-10-01 11:10 How to keep content of oracle view v$sql more time? »
I try to analyse the cost of sql statement according v$sql result in Oracle database. But view's content is timing cleared. How should I do to keep c...
(1) odpowiedzi
2017-10-01 05:10 SQL developer - how to change a defined variable in the loop »
My code below is a loop that inserts some data into a table. I am trying to change the variable &yyyymm so that it uses a different value each tim...
(1) odpowiedzi
2017-09-30 19:09 Getting redirected to isapi_redirect.dll url randomly with 404 »
I have a web application(Jboss) as following https://ourURL/intranet/index.xhtml If you are not authenticated we redirect the users to the Access man...
(1) odpowiedzi
2017-09-30 18:09 ORA-00936: missing expression error when I'm trying to create a new table »
An error is shown when I'm trying to create a new table: Error starting at line : 1 in command - CREATE TABLE users_test1 ( user_id ...
(1) odpowiedzi
2017-09-30 03:09 Oracle SQL query to GROUP BY and subtract? »
If I have four columns: A, B, C and D in a table how would an Oracle SQL query group by column D, then amongst each grouping select the rows where C =...
(1) odpowiedzi
2017-09-29 23:09 VB6 application oracle 12 64bit connection »
We have a number of applications written in VB6 (not .NET) that have been running for almost 20 years. These applications are running on Windows 2007 ...
(2) odpowiedzi
2017-09-29 17:09 how to know the stat date and end date of transaction in oracle »
I Have An Table : Ename Deptno JoinDate RAKESH 10 01-OCT-90 RAKESH 20 01-DEC-91 RAKESH 30 01-MAR-92 In This Query A particular Employee...
(2) odpowiedzi
2017-09-29 09:09 Is there any implicit date format conversion In Oracle? »
I retrieved date from one table in a mm/dd/yyyy hh24:mi:ss format. Now I want to store it in another table in a dd-mon-rr format. Will any implicit c...
(2) odpowiedzi
2017-09-28 12:09 selecting more than 16 digits result in wrong values »
I had this scenario now if i select more then 16 digits in plsql or sql plus i get wrong values: // the below from plsql select 12345678901213 from ...
(1) odpowiedzi
2017-09-28 11:09 Replace dashes and spaces by underscores and make column names uppercase »
In sas eg, for issues of compatibility, I need to copy a table renaming its columns to avoid spaces and dashes, and make the names uppercase. Here ar...
(3) odpowiedzi