oracle10g

I am using the following query to get column totals by week for a given date range... SELECT to_char(week_start - 1, 'dd-MON-yy') week_end, run_qty, acc_qty, CASE WHEN run_qty <> 0 THEN ROUND(acc_qty/run_qty, 4) ELSE 0 END pct FROM (SELECT week_star

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

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

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