• WITH clause not working.

    This is the first time I'm using the WITH clause, and am getting "missing expression". I am rewriting a MUCH larger query, so much of the code below that seems extraneous is needed for the pieces that aren't in there yet. Can anyone tell me what needs to be changed to make this work? WITH test AS (...

    Source0 pointsBadges:
  • Backup

    Hi Guys How can i backup data base and the accounts settings in MS SQL Thanks in advance

    Ajolis0 pointsBadges:
  • pl/sql ref cursor question

    Hi, I'm trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1. Obtain a...

    Ajhaveri0 pointsBadges:
  • 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...

    carlosdl68,585 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...

    carlosdl68,585 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