Need help on avoiding the SQL code redundancy below is the SQL statement in which column dept10 and dept20 have same code but with little bit of difference. Can someone help on how to avoid it, since due to that statement is taking too long to run. N
We have a project built on .NET 4.0 framework in Visual Studio 2010. Database is on Oracle 10g server. We are trying to migrate the project to Visual Studio 2015. In the meantime as we encountered Oracle 10g client is not suitable for windows 7 and w
I have a new Spring Boot(1.2.1.RELEASE) web/Jpa application that I want to connect to a JNDI data source (a Oracle database defined in standalone Tomcat's context.xml). However when I attempt this, I always get the following exception; Unable to regi
I'm intermediate PHP ,MySQL developer,currently, I'm building a warehouse application using MySQL with InnoDB engine and using PHP,I notice it's too annoying and slow to handle many languages at the same time(PHP,MySQL,HTML,CSS),then after googling I
I want to recompile php so i can configure with oracle database. I have read the article and the post here under section: Installing OCI8 as a Statically Compiled Extension and here respectively . I want to change Configure Command to set the path to
OK guys, first of all, I have checked many websites about this error and, unfortunately, none of them helped me. I have the simple following query: select * from ( select to_date(cal.year || cal.month || cal.day, 'yyyymmdd') as datew, cal.daytype as
I have a question: it's possible to create an count in count in sql: my code is: SELECT COUNT( DISTINCT p.id_participant ) as number FROM participation p INNER JOIN message m ON m.id_participation=p.id AND p.id_event = 4 I want to add in first count
I'm having trouble installing the oracle instant client, it won't work even though i followed the directions here http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html Here is my PATH variable http://prntscr.com/3yzql4
I need to write an oracle sql script based on some condition. Like User has to type 'y' or 'n' if he types 'y' then i need to accept gen prompt 'Enter y if you want to generate spool' default 'n' spool c:\a.spl SELECT CUST_ID INTO NO FROM ACC_MASTER
I'm designing and XML and oracle database based on following specification. The question looks confusing but it is very simple. I am trying to design UML diagram for following: A multinational network of hotels owns the hotels in the countries all ov
This question already has an answer here: SQL Query to concatenate column values from multiple rows in Oracle 8 answers I have table prod and have three column id,name and maturity as shown below. id name maturity ------------------------------- 224
Due to a bug in one of our applications, a certain character was duplicated 2^n times in many CLOB fields, where n is anywhere between 1 and 24. For the sake of simplicity, lets say the character would be X. It is safe to assume that any adjacent occ
Is it possible to use TABLE function in Dynamic SQL? I get Invalid identifier error when I use table function with Table of Records as Input in EXECUTE IMMEDIATE. I can't get the following SQLs to work. EXECUTE IMMEDIATE 'SELECT COUNT(1) from TABLE('
I have an oracle database(10 g edition). I want to take the export backup of the database upto some particular date. The backup should contain all the upto that specific date. Is there any way to perform the operation?
This is my updated code. <cfquery datasource="#dsn#" name="list"> SELECT film_Director FROM main_Films WHERE film_Active = '1' GROUP BY film_Director </cfquery> <cfset OnEachPage=15> <cfparam name="StartRow" default="1"> <c
I have a table with a few hundred partitions and I am generally interested on the latest 35. Accordingly I am trying to create views which would access these dynamically. i.e. always use the latest in case ones are created. The query: select PARTITIO
While experimenting on oracle 10g R2 following code does not work or I don't know how to do it. I am anticipating rows from this function to be returned from STUDENTS table when I pass id . CREATE OR REPLACE FUNCTION OCT.GET_Student(ID_IN NUMBER) RET
I am using a FileChooser for selectiong image from the system.Now I want to store the image into db.For this I have created a new folder image in the project,and my idea is load the folder with the opened images renamed like img1,img2...and store thi
I am new to Oracle. Can anyone suggest me how can I achieve the following scenario. I have a table named table1 with ItemID, ItemName. And another table Inventory with ItemInventoryID, ItemDescription I like to add a temporary column, "ItemStatus" to
I'm planning to do SQL expert examination. I have doubts that answer D is correct: Evaluate the following command: CREATE TABLE employees ( employee_id NUMBER(2) PRIMARY KEY , last_name VARCHAR2(25) NOT NULL , department_id NUMBER(2)NOT NULL , job_id