Oracle Database Forum

hi all, I have SELECT query, with WHERE condition. ex:- select * from emp e where trunc(hiredate) = trunc(sysdate); ex-2:-select * from emp e where trunc(hiredate) = to_date('2012/02/12','yyyy/mm/dd');

How to get count of consecutive record which has the same value. e.g. select * from temp; output --------- Id Grade 1 A 2 D 3 A

Write a trigger to confirm before deleting a record in employee table in oracle using pl/sql.

Hello All, I am new to oracle database , please guide me how to configure my oracle database to store Arabic Characters, please tell me all parameters that i should set to what value, step by step. Thanks in advance. Looking forward for your kindly Replay. Best Regard

Hi, newbie here so bear with me. I am querying a Ora Db 10g table that holds the current Week value and current Year value. Require a query capturing upto 14 weeks future data so therefore where the current week number plus 14 = 52 i'll need to increment the year number by 1 and set the week number to 01 before then going onto capture the...

I would like to be sure about my procedure out put t!! I write the following procedure phtml (p_airpcode in varchar2, File_Metar OUT CLOB) AS req UTL_HTTP.REQ; resp UTL_HTTP.RESP; i integer ; BEGIN

technical environment : Forms Version 9.0.2.9.0 (Production), oracle JInitiator: Version 1.3.1.9, WebUtil Version 1.0.2(Beta), window xp service pack 2 build 2600, Internet Explorer 8 I created a form called read_web_file.fmb this form has a- block called METAR_BLOCK under which a text item called metar_code with initial values...

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

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

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?

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

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.

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

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

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

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

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

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