Oracle Database Forum

Hi, I have tried to convert upper to lower and lower to upper in single string it's coming but not with same. select upper(substr('maN',0,3))||lower(substr('maN',3)) from dual; Result: UPPER( ------ MANn

technical environment : (Forms Version 9.0.2.9.0), oracle JInitiator Version 1.3.1.9, WebUtil Version 1.0.2(Beta), window xp service pack 2 build 2600, Internet Explorer 8). i m looking for how form Oracle9i form builder: pass values to a html web page and execute a trigger written on a button as well in a html web page. In detail:...

UPDATE jt SET jt.Assigneduser = (SELECT u.userid FROM Users u where u.username ='Debbie Ross') FROM Jobstasks jt Users u on jt.assigneduser = u.userid Funds f on jt.fundid = f.fundid Jobs j on jt.procindex = j.procindex Tasks t on jt.taskindex = t.taskindex

how to save pdf file in oracle 11g DATABASE USING FORMS FROM CLIENT MACHINE . AND SEND THE PDF SPEFIC USER USING THEIR MAIL.

How to show pdf file contents in canvas in oracle form 6i or 10g in window application?

How to make oracle table names into case insensitive

Hi Guys, Please let me know that how to find fourth Saturday of month.

I am communicating from a SQL database to Oracle database, I am receiving a ORA - 12541 message "NO TNS LISTENER" once a day or so. The communication work 99% of the time.

I am new to Oracle. Now i am developing a java application yo collect performance counter values. So if any one tell me whats the query used to retrieve those counter values, please help me. I did it for Mysql by using " SHOW GLOBAL STATUS". like this i want a query to collect it. Thanks in advance...

Hi! I use query with CONNECT BY to select hierarchical data. After I created cycle in data tree I have error:ORA-01436: CONNECT BY loop in user data. How can I prevent cycle creating?

Hi, i need to compare two tables, field-by-field. The matching will be based on a key field, and the comparison will be for the non-key fields. If there is a mismatch, the key fields, along with the mismatch value (like-> Key, table1.field, table2.field) can this be done using SQL? Or do we need to write any programs for this? GP

I issued the following commands and get answers which are not consistent ,Can anyone explain to me how the positions are generated?Thanks SQL> select instr('Eagritt', 'e') from dual; INSTR('EAGRITT','E') -------------------- 0 SQL> select instr('Eagritt', 'a') from dual; INSTR('EAGRITT','A')

SELECT NB_INWARD.*,(SELECT MODIFIED_ON from nb_application_status_audit where NB_APPLICATION_STATUS_AUDIT.APPLICATION_ID = NB_INWARD.APPLICATION_ID and app_status_audit_code = ( SELECT max(app_status_audit_code) FROM nb_application_status_audit where NB_APPLICATION_STATUS_AUDIT.APPLICATION_ID = NB_INWARD.APPLICATION_ID ) )MODIFIED_ON_FINAL,...

hi all, The following is my select query, select substr(trim(to_char(AMOUNT, '00000000000.00')),1,11) from mytable where status_code='V'; I got the right result while I ran this query in Oracle 10g (windows Server), but while i run this same query in Oracle 11g (Linux Server) i got the result as like this ##########. I don't know why...

hi plzz tell me query last modifications in column in table oracle 10g

Hi Everyone, I have a parent table P1(pid,name,rank) and child tables C1(Cid,name,sal,PID), C2(Cid,name,sal,PID), C3(Cid,name,sal,PID). P1 and C1,C2,C3 has foreign key relation. Now I want to DROP the parent table P1 and Recreate by keeping the data in child tables and also the relation with the newly created table. Can somebody explain...

Hello, I am new to PL/SQL and having GREAT difficulty with the following: Create a stored procedure which processes one employee record (pass an employee number as a parameter to the procedure). Call your function, TOTAL_PAY, created in a previous step and insert a record into the BONUS table if the employee’s total pay is at least $2000. The...

Hi everyone, My work is completely based on sql, pl/sql. Though it is fully back-end, I am interested in learning any one of the above languages. Can any of them be used as front-end tool for oracle sql???

hi i am a .net programmer for almost 2 years. and i want to become oracle dba. where do i start? because im a beginner in hardware. what do i need to do? please.. Thanks in advance

i wanted to connect to a oracle database server through a client. The server is having two ip addresses of different domains so as client e.g 192.0.0.13 and 10.0.0.13. I have entered both the ip addresses in the host file of the client but then also the client connects to the server only when the LAN whose ip is given as first ip address in the...

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...

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...

hi to all Experties. guide me please can we display report datewise in oracle form 10G? actually i want to query date wise because in our company we are printing monthly reports and i made two text items one for start date and one for end date i want when i give date its display all records in report between that date.how it will be possible...