1,488 Topics
 | |
 | 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} ", …  |
| | 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 … |
| | |
| | Hi I have a question with my code. I implemented drop down list populated from my oracle DB. So my question is, I need to populate the rest of the data into my <input type="number" min="currCutting" max="currQty" /> tag that pulled from the database according to the Head_mark selected from … |
| | Hi! HOw do I able to export the table schema (w/ data) in oracle using CLI. Iam using oracle 9i, Is anyone could guide me or give me some instruction on how to do it. I am new with this and trying to explore.. I already tried to search the … |
| | i am trying to get data into oracle table from CSV file with SQL *LOADER but not getting the date which is in time zone format I.E. 2013-02-23T10:41:14.000Z in my csv file. i am using DATE as a type for Creation_Date. pls help me to resolve this problem asap. |
| | I'm not expert in php and it my first time trying to connect php with oracle database I've made mistake before as I was trying to connect to MySQL while I should've connected to oracle instead Oracle instant client is installed in the uni server and with features static IP … |
| | Hi Friends have a nice day, is there any certification exam for Hibernate and Spring like oracle certification. if so kindly guide me. thanks for your time |
 | method non static public class LoGIne{ public String user (String a){ String rr = txt_user.getText(); String pass = txt_pass.getText(); //ConDb(user,pass); return rr; } --------------------------------------------------- method static public static Connection ConDb(){ //String USER ="mh"; String d ,l,h; d =("ameer"); String PASS=d; LoGIne a = new LoGIne(); String USER = a.user(h); // … |
| | Hi Folks, I need help with my Project. I need to pull a value from the populated dropdown list using an ORACLE DB. When I pulled that value, I need to fill the quantity with the corresponding quantity value and show it to the user. And I also need to … |
| | /*I have a situation where in I have to convert the TSQL code to PLSQL procedure. For the purpose of better understanding, I have created temp tables in place of source tables. Can I get hep on this please. The code is as follows: */ ---create temp tables CREATE TABLE … |
| | Hi, If I could please get some help? I have missed the lectures on creating tables due to my daughter being sick. I am trying to follow the lecture notes but I am having issues. I get the following error Error at Command Line : 4 Column : 21 Error … |
 | Hi all, I installed wamp server as well as oracle in my computer where oracle 9i is opening but wamp server is not working . very urgent. Subrata  |
| | This is what I have: create table Employee_T (EmployeeID varchar2(10) NOT NULL, EmployeeFirstName varchar2(10) NOT NULL, EmployeeLastName varchar2(15) NOT NULL, EmployeeAddress varchar2(20), EmployeeCity varchar2(10), EmployeeState char(2), EmployeeZip number(5), EmployeeDateHired date default sysdate, EmployeeBirthDate date, EmployeeSupervisorID varchar2(10), Constraint employee_PK primary key (EmployeeID), Constraint employee_FK foreign key (EmployeeSupervisorID)REFERENCES Employee_T(EmployeeID) ); create table …  |
| | Hello,can you tell me how can i create a database and a listener using sql developer |
| | file FMLRSVCWebpp.war does not exist ,what should i do ????  |
| | I need advice to run oracle 10g forms on linux clients one of the problem is forms icons not appear |
| | Hi, I am a student who is taking a Database course. I am running Windows 7 on a laptop with 4GB RAM. I would like your advice on what software to download on my laptop so as to be able to practice concepts taught in class. Since I am a …  |
| | Blob b=rs.getBlob(12); bytes[] imagebytes=new bytes[(int)b.length()]; Image image; image=getToolkit().createImage(imagebytes); ImageIcon icon =new ImageIcon(image); jLabel22.setIcon(icon); This will not work. help me to display the image  |
 | I have problem with jinitiator. I am using Oracle ERP forms which runs on Jinitiator.When I access some other java applet application at the same time it runs in the JRE in and works fine. When I pass the same java applet application in ERP through a link , I … |
| | Hi, I am looking to store files into Blob in oracle table. Like .pdf .doc .xls .jpg etc. Please help me on this. Regards, Kavitha Kesav |
 | I'm stuck on this problem any one know the answer. **Write a query that displays the grade of all employees based on the value of the column JOB, as per the table shown below. Order the result according to the grade! ** JOB GRADE PRESIDENT A MANAGER B ANALYST C … |
| | Hello, So shortly I am receiving an SQL Error: ORA-00932: inconsistent datatypes: expected NUMBER got OE.CUST_ADDRESS_TYP 00932. 00000 - "inconsistent datatypes: expected %s got %s" when I am trying to retrieve a part of a string data. SELECT dbms_lob.SUBSTR(cus.cust_address, 0, INSTR(cus.cust_address, ',')-1) AS output FROM oe.customers cus; So basically that's … |
| | hey.. Guys can you tell me by default password for this setup oracle 11g home . bcoz of when i was installed that time didn't asked any user and password information . please anyone can help me . but i'm trying deafult user those above said article system/orale and system/system … |
| | |
 | I want to read data from database. the data is in arabic language. the character set of my database is AL32UTF8. when i try to retrive the data i get "????" please do reply how to solve this problem this is the code public static void main(String[] args) { // … |
| | (SQL , PL/SQL) enough for searching jobs in ORACLE ? i have 2.6 years exp with oracle sql, plsql . can i get better JOB ? |
 | Hi Friends, I am working as a programmer in one bangalore based software company, interested to get some freelancing website projects. Plz suggest any firm that provides projects(software development & website development) to work from anywhere or any site that i can get freelancing work to do. I can handle … |
| | i created a pl/sql program in which i want to take multiple inputs from user.. i wrote that n:=&n; in a loop ,i though it will take,but its not working... is there any way to take multiple inputs from user in oracle???? |
| | Can We write a stored proceudre that can generate session id uniquely??? is there any concept in oracle that can generate any ids unique??? can we use sequences??? pls help me... |
 | I would like to know how much does it cost for a website that handles about 100.000 active users simultaneously.. I mean what are the specific prices / costs for a VPS server and a Database ? |
| | I wrote a sample program in notepad begin dbms_output.put_line('welcome'); end; / and saved it as p1.sql i opened sql prompt and gave @p1 it didnt worked??? i tried exec p1; still not working?? how to execute a pl/sql program???pls help |
| | Hey every body , Just need a bit of help with a problem understanding something. When I install Oralce onto a computer what are the default tablespaces and their role in the whole thing. What information is held in the DATA_DICTIONARY for examining tablespaces and their status? Is my second … |
| | 1. I have heard that database is measured in blocks...My question is how the database stores the data in memory device.What it follows to store an entire record??whether each field is stored in different locations or in adjacent locations??? 2. The data is stored in a file called data file..Do … |
| | Hi, I'm getting the following error "" for the query as shown below. Any help is very much appreciated. SET SERVEROUTPUT ON; DECLARE v_CARE_COUNT NUMBER := 0; v_PHONE VARCHAr2(40) := NULL; BEGIN select count(distinct care_level) into v_CARE_COUNT from Table1 where user_id = '100'; IF(v_CARE_COUNT > 0) THEN select phone into …  |
| | hi all, I need one help.i want to give OCA exam the name and number of exam is "1Z0-047 Oracle Database SQL Expert" these is for "10g".But i don't have any material for that.please send me the material for that. only i know the exam topics which i am send … |
| | I had c# application that has registration form and another from that user use to sigin in into my application i wonder how to check if user its register or not my login form has to textbox username and passpwrd and im trying this code i gusse its wrong can … |
| | Hi Sir I Want to Know about Database connection at runtime using tnsnames.ora  |
| | Could you give me some sample code, which was succesfully used before, which contains connecting and taking multi rows result sets via ODBC from Oracle? If you don't have sample code, which books will must be read by me, to rich the best result? |
The End.