2,627 Topics
 | |
| | sir i have vb6.0 with crystal 10 with oracle 9i but when form is run it giving strange run-time error'424' object required. but later ver.(crystal 7) same report running file. pls.help me. kewal sharma  |
| | Hi, I am writing a MySQL script. I used a parameter file to set a user variable [CODE]set @log_file = "C:/logs/table_creation.txt";[/CODE] I used the variable in another file in the tee command as follows [CODE] set @log = concat("tee ", @log_file); prepare stmt from @log; execute stmt; [/CODE] But it … |
| | |
| | So I have these two very basic tables. CODE PROJNAME ------------ -------------- 101 ProjectX 222 ProjectY 355 ProjectZ 973 ProjectAlpha ID NAME PROJCODE HOURS ----- ------------ -------------- ------------ 55055 Smith 101 20 55055 Smith 222 10 39002 Bob 973 25 00001 Preston 355 5 10000 Logan 355 5 00777 Bond … |
| | his is my java assignment. I really need help with it. It is basicallY a Cyber Pet program where in you make the use of a GUI. Here is the file that you can download the whole question from. [url]http://www.mediafire.com/?gfw9c16tubdlf[/url] You gotta have 2 packages : One for the GUI … |
 | Hi, I have begun using Visual Studio 2010 in an attempt to create a website. The website uses a Microsoft Access Database to store information and then displays this information on a page according to the city. So for Hendersonville it redirects to myDomain.com/Hendersonville.aspx Well, In development i realized the … |
| | Thanks so much guys! That solved my problem.. I have another question.. Find the names of all restaurants together with the names of diners who visit the restaurants on 24 April 2011. IF no diner visited a restaurant on the day, include a name of restaurant with no value in … |
| | Hi Guys, I'm not good in Oracle, I need a help in Oracle Developer Suit 10g, I got stuck at the beginning of this project & expecting a help from you all. I need to create a Wedding Event Planner & to design forms for that. Before designing that I've … |
| | Hi, I need to know more about oracle database. 1)Introduction. 2)Importance. 3)Advantages and disadvantages. 4)Effects. 5)Diagrams. 6)Features. |
| | i am new and i need to call from a push button (in forms builder ) a report that i had made it using report builder thanks in advance |
| | I have to: Find the distinct names of all diners who ordered 2 or more portion of the same foods on the same day in the same restaurant. [CODE] SQL> select * from foodorders order by diner; DINER RESTAURANT ODATE FOOD ------------------------------ ------------------------------ --------- ------------------- ALICE BEST FOOD 09-APR-11 BAKED … |
| | Running Win 7 Ultimate 64 bit 9GB mem, two RAID 0 500GB drives - Dell Studio XPS Desktop. Trying to update Java (jre-6u25-windows-x64.exe). Tried everything found on this site and others. Keep getting Error 1714 which Oracle said they have no info for. Suggestions? Tried installing several older versions but …  |
| | Hi all, I was trying to write a query to List all manager's names and how many employees they are managing. all the employees and managers in the same employees table and have a id number and and manager id number. can any body help with this? |
| | Hi alls, since 2 week i'm stuck to do this thing. Actually i need to display image from oracle database into the picturebox. My oracle database got table name "STAFF_PHOTO" and the column of photo is "PICTURE". The image already converted into ByteArray. I'm already make a connection and success … |
| | Hi, I want to get the count(*) from all tables under a schema. How to can do this using a loop? I'm a noob at PL/SQL. I'm unable to find how to use the loop variable in the select statement. Here is what I've tried so far: [CODE]spool $DD/get_oid_dump.log; SET … |
| | Hi friends i have dell inspiron laptop with i3 core processor..having Oracle 10g as database. i could n't run JDBC programs in my lapy. so many ppl spoke to me that dell lapy doesn't support type1 driver.. So i tried for third party type 4 drivers(OJDBC14.JAR) it is also not … |
| | I am learning C/C++/oracle/Unix? I am thinking of developing some application on my own, but I have no Idea what else is required. If you take an example of C++.I have very basic knowledge of it(data types, oops concepts,vectors,file handling,exception handling etc) I am not an expert though. I have … |
| | Hi Guys, Can you please let me know if there is a sql command to list PK , Child and Parent of an identical table in oracle? Lets say I have a table called City , how can I get those information using SQL? Thanks |
| | An application called DBMS Copy is giving me an error every time I try to connect to an ODBC database. ERROR #1552 : ODBC, Connect Error -> [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Please help me. I already browsed the internet, there are … |
| | Hi Can you please let me know if I execute several sql query with one open connection? For example if I have a code like following: [CODE] using System; using System.Data; using Oracle.DataAccess.Client; class OracleCommandSample { static void Main() { string constr = "User Id=scott;Password=tiger;Data Source=oracle"; OracleConnection con = new … |
| | Hi every body, Can you please let me know how can I modify following SQL algorithm to Disable/Enable all constraints existing in an specific table? [CODE] alter table (table name) disable constraint (constraint name) [/CODE] For example if I have a table called "GIS_Data" how I can disable all constraints … |
| | hi all ! I am trying to submit a form using javascript but form is not being submitted. Following are the code : [CODE] <html> <head> <script language="javascript"> /***********************Email Validation **************************************/ function echeck(str) { var at="@" var dot="." var lat=str.indexOf(at) var lstr=str.length var ldot=str.indexOf(dot) if (str.indexOf(at)==-1){ alert("Invalid E-mail ID") return … |
| | Hi Guys I have to merge(insert)data from source database into target database(over 600 tables).The good thing is the both source and target tables have exactly same structure and constrains but I have to transfer only data that are not existing in target database/table.Right now I am using this code but … |
| | Hi All; I have developed a portal using Oracle Portal Application Server. I have to publish it to internet. What are steps involved in this? How the server should be managed? Regards Famous16 |
| | 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 … |
| | Hi all and thanks for reading this..... I have a question that I cannot seem to find an answer for, out there in the big ol ether they call the internet, it involves a three stage procedure on a button pressed within an Access form ... [B] stage 1 : … |
| | 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] |
| | Ok, so I want to port my code to windows mobile, and I'm looking for a tutorial. I would like compatibility with WM5, and WM6 is a must. So I'll use the embedded whatever. I've got Visual Studio 2k8 and the 3 addon required to do the job. I've also … |
| | Hi there, I am considering develop something use a Access database, which has been formed earlier by other my colleagues. However, I am trying to develop a cross-platform application, and I believe Access is MS related and is not friendly to Linux. There are many options of the database like …  |
| | 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 have problem with printing Crystalreports from Dataset as a source. I have a Dataset fullfilled with data from query and CrystalRaports doesn't show any data from dataset on the report. Do you haeve any ideas what is the problem. My Code: [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; … |
| | 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 … |
| | how can solve thi problem Please Help me, System.Data.OracleClient requires Oracle client software version 8.1.7 or greater Its not comming for Local Internet connection ,Its comming only internet please Tell me Please .. Thanks Balas  |
| | 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]To get an answers to my questions, I need to tell you about my profile. Computer Programmer Analyst old fashion (D.O.S. environment, not windows). Languages: Pascal, C, MS Cobol, Clipper, Turbo Basic (C++ but no experience programming), Oracle. The questions are: What should I study in the field of IT … |
| | 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) |
| | What are the four major sections of a Delphi Unit? What is the difference between an Object and a Class? In the context of a class what does “static” mean? Why would you use it? How would you create a thread in Delphi? What are the issues that you can …  |
| | 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. |
The End.