[oracle] Forum Topics

A question..how can we store our nose and ear in data base?? plz reply.

Hi all! I'm new to Weblogic Server. I'm trying to see how sessions are persisted on Weblogic (For Load Balancing). From the official documentation I found that you have use Proxy Server like Apache or Oracle Http Server for in-memory replication(for load balancing), which will act as a proxy server …

Hello, I have been trying to write a procedure that should select the user ID and display their names. Below is the code that I have written, however, when I try to compile it, there are errors. Please someone help me as to where I'm going wrong with this code. …

Hello, I don't if it relevant to ORACLE because I cannot find MAGIC UNIPAAS. I received this formula from UNIPAAS developer, could you explain me what's the meaning of this formula? IF (AH_BL_Date+IF (Air Shipment,1,SUPP CI LEADTIME)='01/01/1901'DATE,'00/00/0000'DATE,AH_BL_Date+IF (Air_Shipment,1,SUPP CI LEADTIME))

Hi, can anyone please help me to find out a solution for the below mentioned problem?? While installing oracle 11g in linux on a remote desktop, failed dependencies occured when installing rpm packages [i want a soluion withou using yum software] [root@TomcatServer Server]# rpm -Uvh gcc-4.* warning: gcc-4.1.2-44.el5.x86_64.rpm: Header V3 …

Hello Geeks; In the eve of new year i have some fresh topics for you. I heard that web is full of real life oop design samples and comprehensive object oriented design guides. Which sites would you offer or which tutorial sequence should i follow ??? PS. Of course other …

File not found D:\app\APPLE\product\11.2.0\dbhome_1\bin\db2gc

While installing oracle 11g on linux an error occured,please give a soluion for that: The error is shown below.. [oracle@TomcatServer database]$ ./runInstaller Starting Oracle Universal Installer... ./runInstaller: line 92: 600 Segmentation fault $CMDDIR/install/.oui $*

Hi everyone, Can any one tell me today's IT industries oracle certification is worth for freshers...

What do you think about PL/SQL ? Is this a language worth learning for the feature along with SAP?

Hi, i have two tables both one is partitioned and another is having a 3GB of data. I've added a composite index on both the tables based on the where clause, in the order it appears. The output of explain plan after gather stats shows that the sql is accessing …

Hello, I have one query with timestamp. I got below error. select users.login, FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(ticket_history.create_time)-UNIX_TIMESTAMP(ticket.create_time))) from ticket_history_type inner join ticket_history on ticket_history.history_type_id=ticket_history_type.id inner join ticket on ticket.id = ticket_history.ticket_id inner join users on users.id = ticket_history.change_by where ticket.create_time BETWEEN '2014-10-01' AND '2014-10-15' AND ticket_history.name ='%%new%%Fermeture réussie%%' group by users.id *`error: function …

After Designing database--->Connection to database--->Data entered-->Data stored in database.My doubt is in which format data is viewed on the screen.(XML OR EXCEL OR PDF)

I am trying to add a coloumn from database into a listbox in VB6. The following code works. The selected item from this listbox is used to find and add records to the ListBox2. Using Oracle 11g Express Edition and Visual Basic 6. Working code: (Displays the artist column from …

Right now i am not working in any company.How to get oracle Support Identifiers?

I am interested to do practice on oracle database.Actually i had completed course on MYSQL,now i want to try on oracle.Today i have opened the oracle website to download oracle 11g(windows7 64bit),But in downloads only Oracle Database 11g Express Edition R2 is there.What to do now?For Mysql workbench is there …

Hi, I am using Oracle 10g on Fedora Linux and trying to learn a bit of pl/sql. Here is the piece of code that I today tried to run in the SQL Plus window but it back with an error message saying [B]SP2-0640 Not connected [/B]What could be the problem? …

the relation betwwen student and course entity is many to many.but it is not recommended .how can we convert it to two one to many relationships?

How to read oracle control file's data using a shell script? Shell script is in Unix.

please, what are the best resources for Oracle starters to be profficional?

Kindly note that I have the below table, I am trying to spool the count of the sum of the amtpd by grouping the duedt where it is less than or equal to 31-dec-2013, but the amtpd that has the duedt of 31-dec-2013 and that has trndt between 01-dec-2013 and …

Hi all, I started to look into event handlers, and there is something I would like to ask, sorry if this is a silly one. I can see that different Java components generate different events when the user interacts with them, but when it comes down to 1)which interface the …

Hi to all, Im going through JDBC currently, I got struck with Java.lang.ArrayIndexOutofBounds Exception:0. I'm not getting the solution to this exception. Please help me to solve this exception, thanks in advance. import java.sql.*; class Select { public static void main(String args[]) { try { Class.forName("jdbc.oracle.driver.OracleDriver"); Connection con = DriverManager.getConnection …

Hi, I want to display the department no. and the no. of employee in each department from EMP Table.(in a Single Row). Pls help me how to write the query for that. I had one query which display the result in 3 rows. select deptno, count(*) from emp group by …

Hi, Not sure what exactly is happening here as I'm used to dealing with Microsoft SQL server rather than Oracle but here goes: I have a C# project that connects to an Oracle database using the OracleCommand Object to bring back records but I've been noticing some strange behaviour. Here …

hello, i want to ask why my function cant be called here's the function create or replace function hitung_denda (idPinjam number, tggl varchar2) return number is denda number; tgl1 date; tgl date; begin select tgl_batas into tgl1 from peminjaman where id_pinjam=idPinjam; tgl:=to_date (tggl, 'MM/DD/YYYY'); if tgl>tgl1 then select (tgl-tgl_batas)*1000 into …

I am new in apex. I want to write a trigger in apex for before insert. I have to standard object (Contact, Opportunity). SELECT sum(amount), Bussiness__c from opportunity where stagename='Closed Won' and id='006i000000Kt683AAB' group by Bussiness__c I want when trigger runs this get sum(Amount) field and Bussiness__c value and then …

hello So i have problem in connecting to my oracle database on the server it threw an exception like this "The type initializer for 'Oracle.DataAccess.Client.OracleParameter' threw an exception". my supervisor told me that it might be a referencing problem in this library Oracle.DataAccess.Client.OracleParameter,but i think that the library doesnt fing …

I dont know is it usful? Its now Oracle , not SUN ,please tell me whether this book wil be helpful for exam?Thanks!