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 …  |
| | I am a little confused about how I am going to update my query in number 1, you may refer to the attachment that I have included for your refererence, the instructions is on number 2 of the printscreen.  |
| | hi guys please refer to the printscreen to see the complete instructions of what I need to do. So far I can now display how many workers are hired before a certain date let's say: workers hired before january 1 1990, the code for this is the following: select count(employee_id) … |
| | hi guys just wanted to ask how to raise the pay of a worker in sql statement. By the way this is in oracle 10g.  I uploaded the instructions for your reference, thank you for those who will help out. |
 | install problem of oracle 11g release 2 : 1) it wants oracle suppotted passward .what is it ?. 2) i give a password but do not work.What can i do ? |
| | suppose there are given tables that has particular attributes, and for example I need to find how many ordered a specific dish.. example: "How many fried chicken orders were made in 1 month?" How do I do the sql statement for this? Thanks for those who will help. :D |
| | hi guys I really need some help I don't quite understand the instructions in our homework, I uploaded it below for your reference. Please explain to me how to do the things required on the instructions, it's not clear to me at all. Thank you for those who will help. … |
| | Hi everyone, I have a problem with connecting vb.net to oracle database. At first I used VB.net 2010 express, but is does not support oracle so uninstalled it and replaced it with VB.net 2010 ultimate trial edition. Can you please give me some codes on how to properly connect vb.net … |
| | Hi everyone, I have to do an assignment where i need to design my database for now. Later will have to implement it as well. We have to use Oracle for database and I am planning to create a webportal based on MVC architurture. Now I have 2 problems in … |
| | Hi there guys I have a question. How do I list names of employees whose salary is the highest for their position (among everyone with same position. I must include the whole name so that's first_name and last_name the name of the table is: employees here are the columns that …  |
| | I am able to insert the document with attachments in it as blob into Oracle DB. I am able to download the same document with the same attachments. But When I open it(blob) with Document Builder and write some lines of text in it and convert back to Blob and … |
| | Hello, I am facing a problem with the look and feel for oracle forms. I am using the file laf_11112.jar. one Problem is that when we open a window the title bar displayes the text in squares. the language original text is in Arabic. second problem is that we can … |
 | Hi there, I'm supposed to integrate different sources of data into one database. I am given these types of sources: * .txt * .csv * .html * .xls * access file as well. what attributes should I be looking at to construct a global schema because all of them have … |
 | I got the insert and Delete Data/Row working for my DBMS. The deleteRow method finds the row that contains the same primary key from the database, passed on to the method, and deletes the row. With using the insertRow method, the data I added shows on up on the last …  |
| | Someone told me that even the basic Oracle SQL commands are useful to learn and I can find jobs with it. I will not just learn the basic commands of course, I will do my best to learn it completely but first i need to know if its still commonly … |
| | hi guys just wanted to ask you about the specialization that you would choose and here are the options for example: .Net, Oracle, or Cisco??? I chose Oracle a while ago and already passed the requirements and form in our university. But still I'm confused because right now it keeps … |
| | I am having problem during installation of 10g. "the value of envoirmental varible is more than 10243. The value cannot be set ". I found that i have to set variable in Computer –> right click –> properties –> Advanced –> Environment Variables but how to do it? i need … |
| | Hi guys, I'm a student and need to practice Oracle SQL queries since we have Advance SQL in our syllabus. I have Intel-based MacBook Pro running Mac OS X Snow Leopard 10.6.8. I just downloaded the SQLDeveloper for Mac and unzipped it. The application executed and started well. But I'm … |
| | create table A ( id number(6) , Amount number(10) ); create table B ( id number(6) , Amount number(10) ); insert into A values (1, 50); insert into A values (2, 500); insert into A values (1, 600); insert into A values (2, 900); insert into A values (1, 600); … |
| | hello I m 3rd year enginnering student in computer science field. I have to make project in DBMS using connectictivty with VB. could you plz suggest me the topics and guide me with ur valuable ideas. thanx Arpita Asthana |
 | Hi I have created many tables in database. Now when i used to create new table that's name may already exists. So, before creating new table i must know which table names are already exists in my database. And for that i want to display all the tables created in … |
The End.