Dear Readers: Does any one have any recommendation on SQL question bank and answers where I could practice my SQL. I have developed some basic knowledge of SQL thanks to the MS community, but I am looking for some additional Questions or textbook re
hi this is sql question, i don't know where i should post it, so here it is. i just want to know the best usage of each. both commands delete records in a table, one deletes all, and the other can do the same plus option to delete specified records.
Hello, Oracle people ! I have an urgent SQL question : (simple for you) using SELECT statement, how to convert vertical row values to horizontal ? For example : (Given result-set) MANAGER COLUMN1 COLUMN2 COLUMN3 K. Smith ......1 K. Smith ............
Hi folks, We'd like to keep this forum for discussions about the iSQL*Plus (Note the 'i') web-enabled front-end to SQL*Plus. We're looking for feedback on this web interface; there are obviously a number of enhancements that can be made and we'd like
I have seen the following in some sql, but not sure of the difference. select abc, NULL from xyz where ..... select abc, to_char(NULL) from xyz where .... my question is there a difference between NULL and TO_CHAR(NULL) ? Thanks.BluShadow wrote: Look
Hello. I work for Clarian Health in Indianapolis and am trying to learn as much as possible about the SQL databases, both AWDB and HDS so that I can handle the reporting for our Revenue Cycle Customer Service. I am currently working my way through th
Hi, I have a sql that looks like the following: insert into INVALID_DATES_TMP (id, gid, created, t_rowid, updated) select id, gid, created, rowid, updated from TABLE1 where fix_invalid_date_pkg.is_date_invalid('TABLE1', 'CREATED', ROWID) = 'Y'; COMMI
I have a scenario: There are 2 tables (parent and child). lets say, case summary table and task level dimension table. for every case id in case summary table, there would be multiple tasks in task level dim table with a flag indicator set to 1 for a
Hi, I am working on a SQL, please help ms with the question below .... thanks (1)Increase by 10% salary of these captain pilots who have traveled more than 800,000 miles. Routes | | Flights | |Pilots | | | | | | #routeID | | #flightNO | |#pilotID | d
Hello Gurus, I am learning SQL and have a question. Thanks for your time and help. I have 2 tables TABLE_AA and TABLE_BB. Both tables have two columns ID, DATA. TABLE_AA is connected to TABLE_BB through ID field (TABLE_AA.AA_DATA = TABLE_BB.BB_DATA)