• Using LIKE with Variable Value not Literal Value….INSTR not optional

    I'm trying to build a search type select statement constrained by a users input.....variable(x) which forces the use of like in the selection processing: x := (whatever user enters); I have tried with no luck: Select * from personnel where lastname like '%x%'; Select * from personnel where lastname...

    BAdams20 pointsBadges:
  • Running a script at specified runtime

    I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks

    Columbus0 pointsBadges:
  • Trying to Load and Display Contents of a Bfile

    I created a table with a key_value and Bfile column. Create a directory alias. Insert a row using the BFILENAME procedure. I said 1 row added. Tried to execute the PL/SQL code below. I get an "nonexistent directory or file error on Open". What is wrong and how can I determine I insert a record...

    Oscarcat0 pointsBadges:
  • SQL Alias visibility

    We have found that creating an SQL alias works for accessing file members in embedded and interactive SQL. But if we create an ALIAS in our live libraries with the intention of keeping it for frequent use, how do we know it exists other than WRKOBJ? It doesn't show up in DSPDBR. And is there really...

    LeslieL40 pointsBadges:
  • Select single row

    Hi, I have a sql server table which has fields like this productNO, Description, loc_quantity. one product can have multiple locations . Location has multiple columns for different location codes. Like Location_qty_11, Location_qty_40 like that. The table gets populated from other tables which puts...

    Gullu15 pointsBadges:
  • INSERT WITH SELECT (CAN’T SEEM TO FIND EXPLANATION)

    Can someone please explain the INSERT syntax that is in the Oracle Database 10g SQL class. I can't seem to find anyone who knows. An example of the statement that I don't understand is: INSERT INTO (SELECT last_name, salary FROM EMPLOYEES WHERE department_id = 50) VALUES (... What is the SELECT...

    Midolci0 pointsBadges:
  • Convert cahr field to datetime

    I am trying to select data for last six months . The date field has a character data type. And it has the format like CYYMM(century,year,month) example: march2006 is '10603'. How can I select from that table the data for last six months. Please help.. Thanks in advance!

    Gullu15 pointsBadges:
  • Network Resource Allocation cum Planning cum Technical Problem

    This is the real commercial problem face by my company. Well, the reason I ask this problem is I salute and respect all of you as I believe all of you are as good as network solution company out there, or even better!! Lets me rephrase the entire problem again. Company expand so fast that the IT...

    Hunkgym5 pointsBadges:
  • compile C++ program with embedded SQL

    I am trying to insert and update into a oracle table from my C++ program. When I compile the program, it does not insert or update anything. Apparently I had to use the DECLARE TABLE to declare the table, because my program cannot find the table. I compile with another user as the schema where the...

    Ws8oBPSQ15 pointsBadges:
  • function not found – 2 questions

    I wrote a function to change a date in character *USA format to *ISO character format. There is a lot of data to insert and all the dates are in *USA format rather than ISO format. The function is created but running the statement, I am told the function does not exist. Why isn't the function...

    TimRaz0 pointsBadges:
  • Parsing string from a single column to multiple columns (address data)

    I have TEMP_TBL which I am using as a staging area to clean up data before inserting it into EMPLOYEE table. One of my big issues is with the column ADDRESS which contains all address components. I need to parse out the address components into the following columns: STREET1, STREET2, CITY, STATE,...

    Tinatsunami0 pointsBadges:
  • Sage/MIP Server Printing Problems

    hi! i have a problem of course. my financial department uses Sage Software/MIP from our windows 2003 server. suddenly, all the accountants are not able to print any checks from MIP. or print anything from MIP for that matter. although the printers will print from MS Word or do a print test page....

    Thecheyguy0 pointsBadges:
  • Configuring isql *plus

    Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik

    Oraworld0 pointsBadges:
  • server components do not install !

    hi i tried to install ms sql server 2005 enterprise edition on win xp media center,but it doesn't install server components,and when installed,it doesn't find any server on my computer , and mycomputernameSQLEXPRESS do not work . but my friends installed the same version of ms sql server,on the...

    Sadegh0 pointsBadges:
  • inserts through a database link

    Hello every body. Here I go again... Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to...

    carlosdl69,920 pointsBadges:
  • Difference between length and vsize functions

    Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik

    Oraworld0 pointsBadges:
  • Using optimizer hints in Forms

    Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look like...

    carlosdl69,920 pointsBadges:
  • ISeries ODBC Error SQL0104 using DB2 UDB (Replicating Notes data to AS/400)

    Does anyone know why I get these ODBC errors or what these errors mean while trying to replicate some fields in Notes to a db on the AS/400 Rel 5.2? Starting Replication: REP_POTEST101 03/23/2006 08:00:34 AM Replicating Documents from <LNK_PURCHREQ.NSF: test POReq> to...

    huskymom0 pointsBadges:
  • Start-up Needed for DB design for workflow for BPO company

    Can any one give some usefull and urgent tips about database design example where i get for designing BPO company work flow parts...

    Malaikanirr0 pointsBadges:
  • PL/SQL REF CURSOR

    Hi, In the ORACLE DATABASE 10G: DEVELOP PL/SQL PROGRAM UNITS Student Guide, Volume 1, (in case anyone has the book), the following code example is on page 6-12: CREATE FUNCTION annual_sal(emp_id NUMBER) RETURN NUMBER IS plsql varchar2(200) := 'DECLARE '|| ' emprec employees%ROWTYPE; '|| 'BEGIN '||...

    Midolci0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following