1,488 Topics
 | |
| | I am trying to work on a project for school from home. The school computer has Oracle and I am trying to access it from home using Java/JSP. Currently I have Java SE with NetBeans installed on my home machine (Windows XP SP II), but not Tomcat or Oracle. The … |
| | Hi This may be one for the gurus, or it could be big standard. Don't know. I'm looking for some help in designing a database. The problem I have is related to data aging on Oracle instances. I can't find any help on it. The problem I have is that …  |
| | Hi guys, I am new at oracle and I just installed the Oracle 10g express. After login to the oracle by SQL Developer I noticed there are lots of tables in table folder which some of them come with $ and some not! can you please let me know what … |
| | Hi Guys I am new at oracle(SQLPlus ,as well) I am trying to run a sql file which contains more than 500 alter statement which is suppose to alter all of my tables.After running the @alterTab.sql in sqlplus the result display at cmd command but I can's navigate to previous … |
| | Hi everyone, I'm new to this oracle database, and i have a question. first I'm sorry if my question is misplaced. My company recently implemented a new ERP system, but unfortunately the ERP system doesn't have a financial module on it. so we planned to buy an oracle financial. and … |
| | Need to create a function Hands‐On Assignment 6‐4 with modifications: Identifying the day of the week for the order date The day of the week that baskets are created is quite often analyzed to determine consumer shopping patterns. Create a function named DAY_ORD_SF that accepts an order date and returns … |
| | This is old college assignment am doing to sharpen my sql skills, its cat test centre and this funtion is checking if the mechanic is available on certain date which is input from user in the anonymous block. the problem i m having durning testing is that the function result … |
| | Can anyone tell me what is the difference between case and decode. and which one is more beneficial |
| | I have two dataset One contain the input parameter and other doesnt And integrating two dataset into 1 report But Giving error [B]object'xxxx.rem' has been disconnected or doesnot exist on at the server[/B] |
| | Hi Guys, I am trying to make a connection with Oracle 11g which is installed on a server 2008 BUT have problems with the ConnectionString. Could you please let me know how I set a correct connection String while I have parameters like these: Database name: GISData Server Name : … |
| | I am using Oracle for the first time.I installed Oracle SQL*PLUS ver 8.As I had to learn this for an exam. But I am facing the following error after I enter it with the system default scott/tiger ... "ORA-12203: TNS:unable to connect to destination" Sorry ,if this question is already … |
| | Hi I there a way to make a trigger completely independent from the calling table so that even if the trigger is made invalid, inserts can still be done to the table that calls the trigger? I created the following trigger: [CODE] CREATE OR REPLACE TRIGGER LOCAL.SYNC_TRIGGER AFTER INSERT ON … |
| | Hi Guys, I am trying to make a connection with Oracle 11g which is installed on a server 2008 BUT have problems with the ConnectionString. Could you please let me know how I set a correct connection String while I have parameters like these: Database name: GISData Server Name : …  |
| | Like the DESCRIBE statement used to view columns in a given table, What SQL statement can i use to view the tables in a database. (Oracle 10g) |
| | how to update the different text in vb to the same field in oracle my code is below [CODE]If ar.BOF = False Then ar.MoveFirst ar.AddNew ar.Fields(0) = registernumber1.Text ar.Fields(1) = name1.Text ar.Fields(2) = status1.Text ar.Fields(3) = Form9.batch.Text ar.Fields(4) = Form9.year.Text ar.Fields(5) = Form9.department.Text ar.Fields(6) = Form9.semester.Text ar.Fields(7) = Form9.section.Text ar.Fields(8) … |
| | Hello everyone, I have installed oracle 9i and iam unable to open sqlplus with scott and tiger. I tried many other usernames and passwords like system/manager, sys/sys as sysdba, sys/change_on_install but iam unable to login sqlplus. With scott/tiger, it is giving TNS protocal adapter error and with sys/sys as sysdba, … |
| | Hi guys I newly started learning oracle.I'm working on my assignment and I'm stuck in this step because of a silly error and I'm sure of my syntax. It looks fine to me but I get this error: ORA-00907: missing right parenthesis This is the command: CREATE TABLE WORKER ( … |
| | How to upload file with oracle database 10gR2?? i can't find how to upload.. i've tried to create a procedure in oracle and execute in netbeans but the file save in directory and then from directory save to database. it means the file save in 2 location, in directory and … |
| | Not sure if this is the right forum for SQL statement problems. I've searched all over but don't know how to output formatted SQL queries. Like Selecting the first letter of the first name and then last name with proper spacing. |
 | hai, My requirement is given below. In my application one LOV is there to show Insured names.In that if we query for the name like ahemd's% then it is showing wrong(junk) data..................So,my question is how to add single quote to already existing single quote.........................I tried in many ways but I … |
| | Create a trigger for insert/update/delete to the table shruti. if insert/update/delete happens then trigger needs be executed. |
| | hi all, can someone please help out.i am using php to insert data into an oracle 11g database.i have a table bus which has a foreign key franchisee name,i want when i am filling in the form,at the text box containing the franchisee name instead of inputting anything i have … |
| | Hi all, I am looking for a Software that Creates SAS datasets from Oracle. Can anyone please help me out in finding this. I am looking for a software not the solution. That software can be free or by buy option no problem. Thanks mAg |
 | Hi All, I am working in Oracle10g and I have been trying to run the following query, and am getting an error: [B]Query:[/B] [CODE=sql] SET VERIFY OFF VARIABLE emp_salary NUMBER ACCEPT empno PROMPT 'Please enter a valid employee number: ' SET AUTOPRINT ON DECLARE empno NUMBER(6):= &empno; BEGIN SELECT salary … |
| | [B]hello everyone ,,,,, i have an assignment that is difficult on me ,,,, its about ((Normalization)) could anyone help me in doing the assignment ,,,plz plz:icon_sad: "please check the attachment" [/B] |
| | i hav just installed oracle 8i on my laptop but i am not able to open the sql plus what is the user name & password?? i hav tried scott &tiger but not working please reply soon |
| | HELLO, in my database, i have the following table: video_hire([U]vide_hire_id,[/U], hire_date, video_code, Cust_membship_no, returning_date, hire_cost) video_code is (fk) ref: to VIDEO_LIST, cust_membship_no is(fk) ref: Customers IM TRYING TO code a PROCEDURE or FUNCTION TO to calculate the ammount of hire from one customer, and print the total, as well the … |
| | Hi to all I have inserted .bmp files to Oracle DB with Delphi7. There is "save to file" option in Toad when on double click blob field. Now I want to save blob data to disk on Delphi7. How do we do it? Thanks in advance. |
| | i installed Oracle 9i.when i go Start->Program->Oracle-oraHome90- i did not get Isql * plus.Kindly let me know the idea.Any help would be highly appreciated.Kindly find the attachment also. |
| | Hello I've got a problem, I have a Oracle db in a Windows 2003 server, the server has already installed the framework 2.0, and in the same server I published a web site in asp.net 2005, and this site should connect to the oracle db, but when you open any … |
The End.