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

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