2,627 Topics
 | |
 | Hello, My name is Steven and I am studying for the OCA-JP-SE7 (1Z0-803) exam and I am using Enthuware Test Studio for practice questions. I came across a question that has to do with the arraycopy method and am having some trouble understanding exactly what is happening. Here is the … |
 | Hey everyone, I;ve implemented SSL to my server using [this guide](https://blogs.oracle.com/lmalventosa/entry/using_the_ssl_tls_based) now when I connect the server it takes some time to initialize now, I assume its setting up stuff, and then when the client connects takes awhile as well (few seconds), I'd assume it works but I want to … |
| | Hi, I've recently just discovered that there is something called ByteCode in Java, and I was wondering what it is used for. I am trying to make a simple Typing Test Word Typer Bot, basically it reads the words on the browser for a typing test called 10FastFingers, then it …  |
 | 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 … |
| | We have date "30-DEC-99" in oracle database but when our code reads that date is reading like "datetime.datetime(1899, 12, 30, 0, 0)", why the year 99 is reading like 1899 rather 1999? how do I fix this issue? please suggest.  |
| | Right now i am not working in any company.How to get oracle Support Identifiers? |
 | Hello everyone, So here's an interesting question for you all. I need to know how to retrieve all the Column Names or Primary Keys from one of the specificed database types: SQL Server, Oracle, AS400, IBMDB2. Now this has to be as a query, or more specifically I have to … |
| | 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? …  |
| | i want to download JDK but i don't know jdk for windows xp 32 bit.. [Click Here](http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html) windows x86 or windows x64 where is it can i download for windows xp 32 bit?? i have try, but i can't download.. maybe their server down.. or something happen.. please.. give me … |
| | 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?  |
| | Hi i need help with the code ive done in java, iv got a project im doing and i get this when i run my program. --------------------Configuration: <Default>-------------------- Usage: java [-options] class [args...] or java [-options] -jar jarfile [args...] (to execute a jar file) where options include: -d32 use a … |
| | How to create a JDBC for Oracle and MySQL?  |
| | Im interested to learn Linux actually i am having Windows 7 64 bit laptop.I am not interested in dual boot,Some of my friends suggested me to download Oracle virtual box.Tell me the process to the Oracle virtual box with linux.Which linux version is preferable for beginners??  |
| | |
| | I'm somewhat new to deploying ClickOnce manifests, first off. I know the basics of how to publish to an app server, which then lets every use the newest version (after setting to check for updates before running the application). We have multiple VB.Net applications stored on our app server, that … |
| | How to read oracle control file's data using a shell script? Shell script is in Unix. |
 | I have a Jframe that contains a JPanel which has a label that I use as a background image and a second JPanel that I want to add my controls into. I am attempting to add and position labels dynamically. I can add the labels but they all appear at … |
| | Hi, Need help on exporting data to csv from oracle database when i export ... the field which has null values (in database) appear as 'null' word in the csv output. Is there a way to avoid it? thanks |
| | 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 Hi I have a requirement like this. We are using xsl top formatt the oracle returned query results in to proper tables . attached is the sample html file generated . I want this html to behave like following . if the column NOTES_ON_CRITICAL_THRESHOLDS contains DDD, we want the … |
| | Hi all, I was just trying to write a simple prog in which i'm trying to add multiple components to a JPanel and inturn i'm adding that to a JScrollpane. Now the problem i'm facing is when i run the prog i can see the contents of the panel(not all) … |
| | 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 … |
 | I am using My SQL Database. I have two databases of My SQL which are used in a appplication simultaneaously as backend and log databases. So i need to stop services of log database only to view some results relating to my application. Is there any way to stop the … |
| | 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! |
| | I want perl scripts of matching the exact word between text file(.txt) and database(oracle/mysql)... suppose... Data in try.txt file, xyz abc and Data in oracle database is, qid column1 column2 1 xyz cde 2 ifg mno Here matching word is "xyz". If matching found, it will automatically delete the row …  |
 | Hi All, I'm trying to connect to a mysql database using the MySQL Connector from Oracle. I'm hitting my first issue of linking the libraries and was hoping that someone could nudge me in the right direction. What I have done so far: Downloaded mysql-connector-c-6.1.3-osx10.7-x86_64.dmg from http://dev.mysql.com/downloads/connector/c/ In XCode, in … |
 | Hi Folks, I am having problem with my web design. I am making a query that involves two table but it doesnt do anything when i click submit. do i make mistake in the query ? my code is like this, <?php if ($_POST['action'] == 'show'){ $requestCompSql = "SELECT REQUEST_COMPONENT_CUTTING.PROJECT_NAME, …  |
 | Hello. I'm developping a project about the decision tree in Java. My project idea is about animals, but it's gonna be a big database and i don't have too much time to complete. So my question is: Can anyone help me to found a complete database about animals or about … |
| | Hi Team, I am new to shell script, i have knowledge of basic unix command but that doesn't seem working for my current task. Please help me with following problem: I have a xml file for e.g. <ShippingInstructions> <name>Sarah Bell</name> <address>400 Oracle Parkway Redwood Shores CA 94065 USA</address> <telephone>650 506 … |
| | I am using Oracle enterprise manager 11.2.0.1.0 and very new to oracle in general. Is there a way to write custom sql queries write inside Enterprise manager. I know Tools like sqlplus and Sql Developer can but I desire to use EM since it is browser based. Thanks. |
 | Hello Everyone, I am trying to achieve pagination using jsp javascript and servlets. Here is my code below: SearchUserViews.java `package TestPackage; /** * * @author Sagar */ private String _userid; private String _firstName; private String _lastName; private String _emailAddress; public userProfile(){ _userid = ""; _firstName = ""; _lastName = ""; … |
| | Hi, I have two tables called header user, inbox. The table structures mentioned below, User: NUM_USER VCH_NAME VCH_PHONE_NO VCH_STATUS 1 XXXX 123 Y 2 YYYY 321 Y 3 ZZZZ 456 Y INBOX NUM_ID(P.K) NUM_CUST_ID NUM_SEND_CALL_ID NUM_REC_CAL_ID DTT_DATE 1 10 2 1 4/11/2014 2 10 3 2 4/11/2014 3 10 3 … |
| | We're learning pl sql in class, and I was just wondering if anyone noticed any glaringly obvious errors in my code? --Gets the phone number of a specific member set SERVEROUTPUT on DECLARE phone_number Member_T.Phone%TYPE; BEGIN SELECT Phone INTO phone_number FROM Member_T WHERE MemberCardNumber= 2436322287; DBMS_OUTPUT.put_line (phone_number); END; --Uses a … |
| | hi, i am trying to connect oracle with php, i had install wamp, download all dll files needed for oracle. but still getting error. Any body helps to connecting oracle with php  |
| | using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Ascending_and_Descending_ex_2 { class employee { public float exp; public string ename; public string designation; public float sal; public employee(float e,string n,string d,float s) { exp = e; ename = n; designation = d; sal = s; Console.Write("{0} {1} {2} {3} ", …  |
| | I have been using IntelliJ IDEA IDE for java development for about a year.However, recently I started working on the J2ME platform.However,when using the Oracle J2ME SDK as my project sdk, I can't run a MIDlet.It is working in netbeans but not IDEA.it shows me the following error: `ERROR - … |
| | Hi Guys, I need help with inserting date from HTML <input type="date"/> into oracle DB It seems that i need to make some kind of adjustment with oracle date. please help me... |
| | Hi folks, I have a question regarding auto-generate row oracle using sequence. So the deal is, I need to make a list of inventory based on its quantity. So I have a table with 3 columns, 1. Component ID 2. Quantity 3. Sub_component. So when user input a component id … |
| | |
| | Hi I am creating a database that will help monitor attendance at uni. We were given the following spec. Each course is made up of a number of modules. Students enrol in 6 modules. Each module has a timetable which includes times of classes. Class can be a lecture, tutorial … |
The End.