Oracle Database Forum

in insert statement default is used (default '01011901') even though show parameter NLS_DATE_FORMAT NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ nls_date_format string DDMMYYYY i have to used alter session set...

select max(sal) from emp where sal not in (select max(sal) from emp)

empid emplrcd effdt effsq 101 #1 2/1/99 0 101 #1 3/1/13 1 101 #1 23/3/13 1 101 #1 22/6/13 2 102 #2 20/6/91 1 I need to retrieve row 4, and I have written a partial code, please help me with the other half. select a* from Ps_Job a where a.empid = '101' and...

Hi I need to know the execution step of listner.ora and tnsnames.ora . because I need to solve errors that comes when configuring lisnter and tnsnames . so I thought that if I get code then I can go through that and I can understand well and I can solve any problem that comes under net configuration

Dear all, I a trying to select columns from two tables using a jointure with the condition that the request date in the first table should be in the same day as the collection date in the second table. Here is my sql script to explain more my issue: select A.*, B.REQUEST_DATE, DATEDIFF(hh,to_char(B.REQUEST_DATE,'DD-MON-YY'),...

i have one table. table. application_id comments ------------------------------ 1234123412 pancard 1234123412 driving license 1234123412 birth certificate. 0909090909 adharcard 0909090909 ration card

Hi all, i have two database enteries: 9shashi and 10shashi. both are of varchar type. how should i get maximum integer from these two values i.e,10. If i use the query select max(id) from tablename; i am getting 9shashi. But i want to retrieve 10shashi out of there. Please help me. For help, i am using oracle 10g database express edition...

I have a table with rows in it as below Column1 Column2 4 50 4 60 6 30 6 90 6 70 7 200 7 100

Hi everybody How can I get this query: For each month (use dateofappointment) of 2010, show a count of appointments. Also show the count of diagnosed diseases, and a count of patients seen during the month. I'm trying this query but it doesn't work , because I got same number for each count SELECT COUNT(APPOINTMENT.APPOINTMENTID),...

hi when i try to execute i am getting error ORA-00933: SQL command not properly ended plz help me if i remove order by also same error select * from (select job,Sal,dno from emp1) pivot(sum(Sal) for dno in(10,11,12,13,14)) order by 1;

hi, is it possible to read value returned by the exe in oracle stored procedure. basically i have an exe that returns string value, get the string value returned by the exe and insert into a table. thanks, sandeep

Hello..anyone can help me in finding the link for TOAD oracle 11g..As i am unable to find it up for free.

Hi, I have a Stored Proc created as: CREATE OR REPLACE PROCEDURE COMP_RECORDS IS l_query VARCHAR2 (10000) := ''; CURSOR TBL1 IS SELECT TABLE_NAME, COLUMN_NAME FROM COLS_TO_COMP WHERE TABLE_NAME='SECMASTER_HISTORY';

Hey Friends. CAN ANYBODY TELL ME THAT IS THERE ANY QUERY TO PARTITION THE DATABSE IN ORACLE 11G

Hi, I have to transfer data from IntersystemsCache to Sybase IQ database. I am trying to use Insert .. Location command from SybaseIQ. But I need to know the server-class for Intersystems Cache. Tried some links on internet, but didn't find it.

I have searched a lot for OCA study materials. But i am not sure which site is the most useful. I will appreciate it a lot if you can give me some advice.

How do in install oracle 8i in Windows XP sp-2 or Windows7 OS. In Xp it is installed and working properly but the oracle service is not started after restarting the machine. In windows 7 it is not installed. Shows the error message 'stops working Jrew.exe'

i want a query to get ist timezone .

Hi all i want to delete 10 days old archivelog automaticly from my oracle database how to do it please hlep me. thank you in advance.

Hi friends, I develop one jasper report . when i am compilng that report it gives error. error details: ----------- com.jaspersoft.ireport.designer.errorhandler.ProblemItem@16f7d42 The operator >= is undefined for the argument type(s) BigDecimal, int net.sf.jasperreports.engine.design.JRDesignExpression@1054100 ( $F{AMOUNT1} >= 5000...

I have a small table that describes a group of employees it has their id number, their department code, and what line of business they belong too, etc. The Oracle tables have scheduling data. Vacation time, break time, etc. I do not have permission to upload my description table into Oracle. Instead of uploading this table I could use...

when i write a query and execute the query it gives error. My Query SELECT NI.POLICY_HOLDER_SALUTATION ||''||PD.DRAWER_NAME AS DRAWER_NAME, PD.ADDRESS_LINE_1 || NVL2(PD.ADDRESS_LINE_1,',','') || PD.ADDRESS_LINE_2 || NVL2(PD.ADDRESS_LINE_2,',','') || PD.ADDRESS_LINE_3 || NVL2(PD.ADDRESS_LINE_3,',','') || PD.CITY || NVL2(PD.CITY,',','') ||...

Hi, i have table with nclob column. i want insert a row into table with large text. when i am trying to run insert statement getting error text too large >40000 charactes. i am using SQL Developper. i need to make this as a script and run on different servers. Thanks, Sandeep

i have table called po it holds columns pono,supplierid,itemname,docdate,itemdisc,rate,discount,totalamount on different docdate with different supplierid and different rate same item is there in po table when i give itemname in run time it has to give least rate of that item with docid and supplierid in last 6 months from as on date.

I have table name time_data in that it holds (docid,docdate,usertype,fromdate,todate,userid ) columns date format is 'dd/mm/yyyy' now i want to retrieve the data by giving the run time parameters month and year ...'JUN' and '2013' ..... for suppose if i give month jan and year 2013 in that jan month it what date i have entered ..has to come...