• Subquery returned more than 1 value.

    I've got a SP that has the following line of code: SET @totalLateRecords = (SELECT COUNT(*) FROM tableName WHERE tableName.fieldName <= 61)) I get the error "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery...

    Bbonsall0 pointsBadges:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • ODBC connections

    We have a database that is specifically designed for our industry. We want to be able to export the information into a mailing list. This is the email that I received from IT. "You cannot export to an access database, but you can connect to the KIDS database with Access or with Excel query to...

    Jade057110 pointsBadges:
  • VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

    Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

    Hunkgym5 pointsBadges:
  • Problems with underscore column names quering

    Hi I am having problems working with the PL/SQL, the thing is that I installed the oracle db 10g software wich i downloaded from the Oracle Site, now i am testing some queries, I have a table called GRP_GROUPS wich has some fields like ID, and GRP_Name, when i try to do a select like this: SELECT...

    Opereira0 pointsBadges:
  • Simple but not so

    I have 2 table 1) Product_Inf and 2) Product_attribute_details I have prod_key, dye_class, prod_range in both the table. Their is no relation exist between both the table than how can i find the records available in Product_Inf but not in Product_attribute_details?

    Ilink880 pointsBadges:
  • create table (record capacity, or Size)

    When using CRTPF we also use SIZE. Example: CRTPF FILE(MYLIB/NEWFILE) SIZE(10000 1000 9) I searched for the same possibility via SQL but can?t find it. Is there a way with a SQL statement 'CREATE TABLE' to do the same?

    Cenens0 pointsBadges:
  • Which is Better ? Filter condition in JOIN clause (OR) in WHERE clause ?

    We have an option to filter a result set of a select Query using a filter condition either in the WHERE clause (or) JOIN clause. Let us consider an example: ex1: SELECT * FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.COLUMN1 = TABLE2.COLUMN2 AND TABLE1.COLUMN3 = 'N' AND TABLE2.COLUMN4 <> 'N' The...

    Shanmu19840 pointsBadges:
  • Trigger or something like that for Select sentence

    I need a trigger or something which will be launch when i open a table with a "select" sentence...i know that triggers per se only work with "update, insert or delete" (ddl or dml) but i want to know if i can do something that works like a trigger but only when i do a "select" command...i know also...

    JorgeVergara0 pointsBadges:
  • please solve this query

    Create Emp table containing an Empno column with the following sample data:- EMP ------- EMPNO ----------- 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ------------ 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 Don?t assume...

    Sairam170 pointsBadges:
  • Problem finding a column name.

    The following SQL is giving me the message: Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'ProductCode'. How can I correct this code. The column name does exist in the table. I also want to group by Product Code and not by Container Name. Thank you. SELECT a.ProductCode AS "Product...

    Captnskirk0 pointsBadges:
  • Visual Basic

    What is the difference between VBA and Visual Basic.Net...I want to learn how to write scripts to automate certain tasks.

    Idapsdst0 pointsBadges:
  • 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:

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