1,488 Topics
 | |
| | I have an sql code that is retreiving a row with more than one line, Is there a way to make it combine those two lines into one line. select revertrsn from LN08PENm where aano in(754,870,1136,1138,1139,1140) the data coming in the row that I am retreiving is like this: As … |
| | Hello guys, Do anyone know how to write recursive SQL statement for hierarhic output places from next table: id-----place----------idParentPlace 1......World..........Null 2......Europe.........1 3......Mediterranean..2 4......North Europe...2 5......Italy..........3 6......Greece.........3 7......Island.........4 8......Norway.........4 I was looking for alot of tutorials but didn't find anything useful. Any help is the most welcome! Regards, TP  |
| | Dear Experts,I want to know how i can sync tables in sql server 2005 and oracle 11g tables. Table structure will be same in both server (sql server and oracle). I would like to prefer some tools available either in oracle or sql server.Thankspardeep  |
| | Hi all, I'm unable to get the below update SQL to run in Oracle, it's giving me th below error ORA-00933: SQL command not properly ended. Any help appreciated. UPDATE PDR.PH_Family_Match_by_Chassis a SET a.Launched = 'Y' INNER JOIN PDR.domCHASSIS ON a.chassis_id = PDR.domCHASSIS.chassis_id INNER JOIN PDR.domCHASSIS_MODULE ON PDR.domCHASSIS.chassis_id = PDR.domCHASSIS_MODULE.chassis_id …  |
| | I have a vb.net application with oracle express editon as back end. When I run the exe of application on another machine it gives error "ERROR[IM002][Microsoft][ODBC driver manager]data source name not found and no default driver specified". How to solve this issue.  |
| | Hi guys ! I am newbie, I have downloaded oracle 11g release 2 but i don't know where to start and how to connect C# program to database. I want to write simple program of username and password in which I it stored in database. And also maps the username … |
| | hi i want sql query to insert encrypted passwrd ?? foreample if user password : 123456 what is the sql query to insert it incrypted |
| | hello, I am going to create a project which is having multiuser configration, So i decided to take vb.net as frontend and oracle as backend. So the database will be on server and all client willhave software installed. Questions are : 1. Do i need to install oracle in all … |
| | how to get values from other table to update table |
| | How can we update one table with the values of other table in oracle. i have entity table with entityid and entityname and template table with templateid and templatesk sofar entityid is getting values from templatesk but now it should get from templateid .how can we do this.. update statement …  |
| | Hello everyone, I have a PHP form that connects to an oracle DB and should send data to the database when the form is submitted, but I can't figure out why it's not loading any of the data into the database, everything seems to be correct (though this is my … |
| | hi friends, i am using oracle 10xe edition, when i use "select * from tab" in between other table name i found "BIN$VAmBblokS5GK+8YXdhI5EA==$0" give me tips to delete this. thanks for your time. |
| | Please help! i can't connect codeigniter to Oracle I am trying to connect Codeigniter to Oracle 11g, here are my settings Settings in database.php: $active_group = 'default'; $active_record = TRUE; $db['default']['hostname'] = "//localhost/"; $db['default']['username'] = 'xxxxxxx'; $db['default']['password'] = 'xxxxxxx'; $db['default']['database'] = 'orcl'; $db['default']['dbdriver'] = 'oci8'; $db['default']['dbprefix'] = ''; $db['default']['pconnect'] = … |
| | hello. i got a project to do using oracle pl/sql and i want to add a interface (preferably, web) so there aren't just some plain sql scripts. some text boxes, buttons, etc. so it looks nice :D. any suggestions? thank you. |
| | Hello, I am using the tutorial from Oracle's site on how to connect to a database in PHP using code similar to the one shown below. <?php // Create connection to Oracle $conn = oci_connect("phphol", "welcome", "//localhost/orcl"); $query = 'select * from departments'; $stid = oci_parse($conn, $query); $r = oci_execute($stid); … |
| | |
 | An in-the-wild exploit targeting a vulnerability with Java 7 has led to security experts the world over warning users to disable the Java plug-in for their browser clients at the very least, and preferably uninstall Java altogether. The CVE-2012-4681 vulnerability, comprising two flaws, along with a couple of other 'related …  |
| | needed help how can i connect to my oracle database using shell script and how can i assign particular value in table to a variable defined in shellscript and i use sqlplus but i get error |
| | Hi, I have a string like this: ABC_STRING_DEF_GHI_JKL. Where the "STRING" part is constant. I am trying to get its corresponding regex pattern. Something like %_STRING_%_%_% So far I managed to get to this point: SELECT 1 FROM DUAL WHERE REGEXP_LIKE('abc_STRING_def_ghi_jkl', '(^(\w[^_])+)_STRING_([^_]+)_([^_]+)_([^_]+)$'); It's not really working, so if you have … |
| | Hello, I am hoping to get some help on a view which needs to be pivoted, I am not sure though. View is in following format: Case CASE_ORDER MANAGER CURRENT_MONTH_CASES FISCAL_YEAR_CASES ------------------------------------------------------------------------------- case_1 1 John 15 84 case_1 1 Jeff 10 80 case_2 2 John 20 90 case_2 2 Jeff …  |
| | Hello, everyone I'm new into databases. I have an Oracle insert sequence that I need to convert to SQL server if anyone could help me to get this to work. I'm not sure if nextval is compatible with SQL Server. Here is the code: // original insert into invoice select … |
| | I am new to sybase. I came to know that i can take contents of a sybase table into a text file using an option called BCP Can anybody here explain how to use BCP in sysbase |
| | Hello, I have created an application to a fill a datatable with an OleDb connection which gets data from oracle. This works just fine in Windows 7 and correctly retrieves the data. However whenever I run the application in Windows 8 it gives me the following error: *Error while trying … |
| | CREATE OR replace FUNCTION fn_findraise (dept_in IN VARCHAR2, salary_in IN FLOAT) RETURN NUMBER IS salaryraise NUMBER; BEGIN IF dept_in = 'MIS' THEN salaryraise := salary_in * .10; ELSIF dept_in = 'SALES' THEN salaryraise := salary_in * .15; ELSIF dept_in = 'HR' THEN salaryraise := salary_in * .20; END IF; RETURN … |
| | hey I have table that has date column and I want to select just all the sales that hapen in the first three month between 1/1/2012 to 30/3/2012 How I am able to do this select query ?? |
| | I did not really understand the benifit of the alias clause... this was in the w3shools tatourial with alias SELECT po.OrderID, p.LastName, p.FirstName FROM Persons AS p, Product_Orders AS po WHERE p.LastName='Hansen' AND p.FirstName='Ola' with out alias SELECT Product_Orders.OrderID, Persons.LastName, Persons.FirstName FROM Persons, Product_Orders WHERE Persons.LastName='Hansen' AND Persons.FirstName='Ola' why we … |
| | I have a trigger(that prohibits the attribution of more than 10000 dollars to a worker that is not manager nor president) that i want to modify. CREATE OR REPLACE TRIGGER restrict_salary BEFORE UPDATE ON EMP FOR EACH ROW WHEN (new.sal > 10000) DECLARE job ename.job%type; BEGIN select job into job …  |
| | Hello, I have the following table, for readability I broke down the after every manager for every case number. The last column is the cumulative sum of the second last column. Value for month should ideally run from 1-3 (Like you see for both the cases for Chicago). But from … |
| | Hi everyone! I am pretty much new to Oracle it has only been 3 months or so I guess and I have a bit of a problem now. I'm running a query which will display the downtime of a machine. It will display the Start/End Time and its difference. The … |
| | hi guys can anyone explain to me what the codes in line 5 and 6 do? How does the WHERE works in those lines? Any explanation would be truly appreciated. Thanks in advance. SELECT LAST_NAME ||', '|| FIRST_NAME AS "NAME" FROM EMPLOYEES E, (SELECT JOB_ID, MAX(SALARY) SALARY FROM EMPLOYEES GROUP …  |
The End.