2,627 Topics
 | |
 | Hi What is my misstake? I got error whwn I run my code! DECLARE V_num number := ‘&enter_an_integer’; V_test number; Begin V_test := mod(V_num,2); If V_test = 0 then Dbms_output.put_line(’even number’) Else Dbms_output.put_line(‘odd numbers’); End if; End; The error was 06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a … |
| | can any one help to find out how to create a oracle app using oracle express edition 10g  |
| | Hi All, I have a problem in my jdialog(child) and the parent frame is jframe,it is taking two events to close the jdialog,both from the close caption available at the upperright corner of the dialog,as well as from the button add where i have used dipose() to close on single … |
 | Hello group, I've decided I want to take some classes in SQL, to better understand how to write queries. In looking online for where to turn to for this kind of training, I also see classes to prep for certification. I'm curious of what the value to my employer would …  |
| | Group, I'm extracting some month and year values from dates. I need to ensure they are NUMBERS as I'm going to multiply, add and subtract. I'm assuming I need to DECLARE these as NUMBERs. However I'm not sure how to do this correctly as I'm getting errors preventing me to … |
| | Group, I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience. My question: Can I create a variable in TOAD/SQL to prompt for a date(s)? Here is what I want to do: Question 1: Enter Beginning Date (user to enter … |
| | Hi group! I'll be up front and say I'm very new to SQL. I'm just now getting my feet under me in my new job. So I have lots of questions. I'll start simple (I hope). I've created my own tables (2) that have multiple columns of data that looks … |
| | i does not know about store the image in database. what is the datatype of picture in oracle? |
| | I installed Eclipse and it worked for few days and it nolonger openned giving error:- can someone help me (mbusi.ndlovu@gmail.com) Java was started but returned exit code=13 C:\ProgramData\Oracle\Java\javapath\javaw.exe -Dosgi.requiredJavaVersion=1.6 -Xms40m -Xmsx512m -jar C:\Program Files\eclipse-java-luna-SR2-win32-x86_64\eclipse\\plugins/org.eclipse.equinox.la uncher_1.3.0.v20140415-2008.jar -os win 32 -ws win32 -arch x86_64 -showsplash C:\Program Files\eclipse-java-luna-SR2-win32-x86\\plugins\org.eclipse.platform_4 .4.2v20150204-1700\splsh.bmp -launcher C:\Program Files\eclipse-java-luna-SR2-win32-x86_64\eclipse\eclipse.exe -name … |
| | HI, Am new to PL\SQL. I just want to fetch the 4 fields from employee table. how to do it? employee_ID, First_name, Last_name, total number of employees from employee table. i tried to fetch using count() function. but it is not giving the total number of employees. can anyone please … |
| | Hi, I would like to hear from professionals on this forum who happen to be either technical or functional consultants for a variety of vendors who deal with CRM/ERP such as SAP, Dynamics AX (MS), Oracle, Sage etc. 1. What exactly is the difference between functional and technical consulting? 2. … |
| | I currently wish to write a query to duplicate data in database while modifying one column. First of all, my database structure: table code CURCD NOT NULL VARCHAR2(3) CODE NOT NULL VARCHAR2(2) ITEM NUMBER(1) DSCPT VARCHAR2(20) The unique idx is the curcd,code,item. What I wish to achieve is duplicate data … |
| | Hello All, I have two schema called mater and transaction. In master one table called - BCC_TM_CITY In transaction one procedure called PR_GETCITIES. In this procedure table BCC_TM_CITY used like this select * from mater.BCC_TM_CITY; my problem is, recently I dropped the table and added again in master. After that, … |
| | Eh... I lost recently laptop to Windows, Microsoft made me cost about 700$, and that all in just 2 weeks. And even though I start hating it, I cannot deny the fact that many applications and certain games I rely on are runable only on Windows. Graphics card aren't really … |
 | So I am having trouble connecting to an Oracle XE 11g database in visual studio. The Ultimate aim here is to make a webpage I can run on my local machine and send sql to on my local net. From looking around it seems other people have had this problem, …  |
| | I am trying to drop some data files to free up disk space. In order to do that we first need to know how to identify the data file that has 0 extents allocated. I am stuck at the arriving at the query that will show me the datafile that … |
| | below, I have create a table using oracle sql. How can I change so that number of credits for a course is always between 0 and 6. Any idea how can i do this? CREATE TABLE COURSES (COURSE VARCHAR(6), DESCRIPTION VARCHAR(60), CREDITS INT, CONSTRAINT pk PRIMARY KEY (COURSE)); |
| | below, I have created 4 tables using oracle sql. I want to change the code so that when deleting a student will delete all enrollments for that student. any idea how can I do this? # COURSES table # CREATE TABLE COURSES (COURSE VARCHAR(6), DESCRIPTION VARCHAR(60), CREDITS INT, CONSTRAINT pk … |
| | I am trying to write a function that will update a table, 'Orders'. The rows in this table will have Item, Location, Qty, SendDate, and EndDate (SendDate and EndDate are in 'yyyymmdd' format). The difference between SendDate and Enddate will need to be taken and spread the qty out by … |
 | Hello everyone Now my problem is how to make oracle take json string in oracle procedure , so i know that only oracle 12c specifically version 102 supports json data , so i want to know how to get a json string from web application rather than using XML data … |
 | I just installed CentOS in my Oracle virtual box and now I'm having trouble getting it to connect online. I'm following the directions here -> http://xmodulo.com/how-to-configure-network-interfaces-in.html but the file ifcfg-eth0 is not showing up in /etc/sysconfig/network-scripts/ a lot of ther ifFILES are showing up but not that one. I would … |
| | A question..how can we store our nose and ear in data base?? plz reply.  |
| | I have three tables that I query. Problem is my ORACLE MIF table has 500,000 rows. And it takes more than 1 hour. How can I reduce the time? SELECT WB_FIELD_REQ.MODEL, WB_FIELD_REQ.MFG_SERIAL_NUMBER, CONFIG_SERIAL_NUMBER, SH_CONTRACTS.EQUIPMENT_ID, "", SH_CONTRACTS.SERVICE, "", SH_CONTRACTS.CONTRACT, "X", "", "X" FROM WB_FIELD_REQ INNER JOIN SH_CONTRACTS ON WB_FIELD_REQ.MFG_SERIAL_NUMBER=SH_CONTRACTS.MFG_SERIAL_NUMBER NOT IN … |
| | 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 … |
| | this is my latest class assignment, i would really appreciate some assistence with my pseudo code to help me in the right direction. my code skeleton is provided at the end of this post. Deque A double-ended queue, often abbreviated deque and pronounced deck, is an object with the following …  |
| | I'm trying to install CentOS on my Linux Mint desktop through Oracle's VirtualBox. The instalation screen says it's installing to sda1 and that's it's mount points are /boot -> 500 MB, / -> 5.02GB, & 614 MB. Is this safe or is there a chance this is going to mess … |
| | I just developed an android app having sqlite database so I just want to connect it to the oracle database server at the remote. Pls can someone guide me?  |
| | I'm currently reading about the JVM and how garbage collection works found here: http://www.oracle.com/webfolder/technetwork/tutorials/obe/java/gc01/index.html It discusses both the Mark and Sweep and the Generational garbage collection concepts. After reading through this tutorial, I'm confused on which garbage collection process the JVM actually uses. The whole time, I thought the JVM …  |
| | Greetings, I am new in Java programming language and I know that there are four platforms of the Java programming language Java Platform, Standard Edition (Java SE) Java Platform, Enterprise Edition (Java EE) Java Platform, Micro Edition (Java ME) JavaFX I already read about the four platforms through the below … |
| | I have Farpoint Spread 3.0 with VB6 and I succesfully populate the grid binding the control to an ODBC Oracle table and also the formatting works well. I need to change the data in the grid and save them automatically in the database. I activated the property DAutoSave = True … |
| | Hi guys I am new to workflow but i have a task ahead of designing a workflow management for an organisation We have Windows 2003 Server installed on one system which acts as Oracle application server I want lots of details 1) How to go about creating a workflow from … |
| | 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. … |
 | ***Please don't post "spam" or "Thank you" posts in this thread since this is meant to be used as a guide for all beginners and I am sure we would like it to be on topic. I hope you understand this.*** **» Introduction to Java «** To start off, [Java](http://en.wikipedia.org/wiki/Java_(programming_language)) … |
| | According to JLS, the [grammer](http://docs.oracle.com/javase/specs/jls/se8/html/jls-14.html#jls-14.14.1) of basic for statement is for ( [ForInit] ; [Expression] ; [ForUpdate] ) Statement It's also said on the JLS that 'The Expression must have type boolean or Boolean , or a compile-time error occurs.' So to check if the syntax is valid, the parser … |
| | 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 … |
 | Hello I am studying for the 1Z0-803 (Oracle Certified Associate, Java SE 7 Programmer) exam and I have the hardest time with following the flow of nested loops. On practice tests I do ok on more complex concepts like polymorphism but I miss over half of question with nested loops. … |
 | |
 | Hi, I have the follow select where it display like that using oracle 11g: M<->Note 1<->2 1<->3 1<->4 2<->8 2<->9 I want to display like that in a html table (M once): M<->Note 1<->2 "<->3 "<->4 2<->8 "<->9 $sql = ("SELECT DISTINCT(t1.MIN) AS M, T2.NOTA FROM T1 RIGHT JOIN T2 … |
| | 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 $* |
| | I'm doing a simple application of userregister from which I found on net but displays the error message HTTP status 404 not found by GlassFish server 4.1 in NetBeans using Oracle 10g |
| | > unable to process the application .cant store user data into the data base,shows only a blank page # servlet code # import java.sql.*; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; @WebServlet(name = "register", urlPatterns = {"/register"}) public class Register extends HttpServlet { … |
| | I was looking at these two examples and I was curious what the difference is between JCheckBox and JCheckBoxMenuItem. http://www.macs.hw.ac.uk/cs/java-swing-guidebook/?name=JMenuBar&page=3 https://docs.oracle.com/javase/tutorial/displayCode.html?code=https://docs.oracle.com/javase/tutorial/uiswing/examples/components/CheckBoxDemoProject/src/components/CheckBoxDemo.java These pictures make it look they are the same except JCheckBox is not in a menu but it is easy to add to a menu with the menu_name.add(menu_item) command. … |
| | This is not an assignment, teacher wants us to do this as a prereq for an assignment and his instructions are not clear enough for me to follow. I am using C: instead of E: I made the directory C:\sql and coppied the cmd.exe and pasted it. When I right …  |
| | 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 Again, I am in need of some help getting my GUI to display the inventory values. The code runs and compiles successfully, but it does not display anything. I am new to this and could use some help. Thanks! package inventory; import java.text.DecimalFormat; import java.util.Arrays; import javax.swing.*; import java.awt.*; …  |
| | Hi.. I'm getting error in my query.. while using it in oracle it is working.. But when using it in mysql it is not working.. i'm getting error as insert into ProjectHealthReportAudit(clientid, projectid, month, year, phasesId,ACTIVITIESSUBTYPEID, ACTIVITIESARTIFACTSID,processConformance,comments, pcinumber, pciscore, colour, createddate,createdby) values ( (select clientid from client where clientName = … |
The End.