1,488 Topics
 | |
| | Dear Experts, I am facing following problem with oracle 11g while programming. ORA-12505: TNS:listener does not currently know of SID given in connect descriptor System has four database is connecting through sql developer successfully but ohters are not connected. When i am again creating same database for correcting error it … |
 | I am stuck on the final part of the query, I know that this thing is easy, but I am out of ideas now, so sorry for this. I have prepared a query like this: SELECT A.projectName as PARENT, (select COUNT(*) from PSPROJECTITEM WHERE PROJECTNAME = A.PROJECTNAME) parentprojecount, B.ProjectName as … |
 | i'm new to web designing. i'm planning to create the website which will store user information in oracle database. my questing is is it possible to connect oracle 10g to web page(form)? need tips.. |
 | Hello DBAs, Can any one guide me how can i get the last modified date(insert/update/delete) of a table? Regards, B. Mantri |
| | Hi, I typed the below code in oracle 10g express edition. [CODE]SELECT emp_id, last_name, salary, dept_id FROM employees WHERE emp_id = &employee_num [/CODE] I get an error; ORA-01008: not all variables bound Can you pls help? Thanks. |
| | Hello, I need description about ORA error 26759, i tried to check decumintation for cause or action but with no luck, would anybody help me diagnosing why i saw this error on my 11g Oracle DB. Thank you in advance. |
| | Hi, I am new to oracle. I have this following query : SELECT TYP_CD, SUM( INVC_AMT), trunc(ALLOC_RUN_DT) as "Alloc_Date", MIN(ALLOC_RUN_DT) as "Minimum_Time", MAX(ALLOC_RUN_DT) as "Maximum_Time" FROM allocation_header group by TYP_CD, ALLOC_RUN_DT order by TYP_CD, "Alloc_Date" and the sample output I get is : TYP_CD INVC_AMT ALLOC_RUN_DT Minimum_Time Maximum_Time 01 20520232.31 … |
| | I'm not sure if this is the right place to ask , but is this erd valid? Or is it unacceptable? Thank you for any help. |
| | I have created a application which connection to sql server database as well as oracle database The application is working fine at my end And to connect to oracle i used following namespace using Oracle.DataAccess; using Oracle.DataAccess.Client; But when i run the application on user end It gives following exception … |
| | Am trying to add a constant column to the select query which is quering an inner query. Need your help with the query. select *,'1' as flag from ( select ROW_NUMBER() OVER (PARTITION BY e_id ORDER BY birth_date DESC) as rn,wh.birth_date,e.*, xy.m_id from employee e inner join table2 xy on …  |
| | what is the SQL command (Query) to create category and subcategory in oracle thanks for your time. |
| | Hey everyone I need some urgent help please. I don't know how but I need make a Time Dimension of an Oracle Table using c#. What needs to happen is: -I want to use Order_Table's Date Column to Create a new table Time_Dim with columns OrderID, Year, Month, Week, Day. …  |
| | Hi everyone I need help please. I need to create a Time Dimension of an Oracle Table using C#. I have no idea how to do it. Any Suggestions? Thanks in Advance |
| | Hi All, I have two machines, one Solaris and another Linux. On my Linux machine , i have Oracle10g installed and have one instance(say firstInst). I have Oracle 10g installed on Solaris also. When i try to connect to this firstInst, from Solaris , i get error like *sqlplus sys/sys … |
| | Hi, I am currently working on joining 2 tables, however those tables have different number of columns thats why I have difficulty on joining them. I tried to use FULL OUTER JOIN, close result but still not my expected output. You can kindly see my attachment to see the scenario. … |
| | How to convert oracle forms to php, is there an easier way to do that. |
 | Hello, I want to create tables in database (using SQL) and add foreign keys to each table refering to the other one. For example: CREATE TABLE ONE( ID INT NOT NULL, NAME VARCHAR(20) NOT NULL, TWOID INT NOT NULL, PRIMARY KEY (ID), FOREIGN KEY (TWOID) REFERENCES TWO (ID) ON DELETE …  |
 | Does anyone know how to connect an oracle object oriented database to c#? Using ADO.NET Entity Data Model, i see just relational tables, and i need to work with object tables. Thank you verry much! |
| | |
| | hi, I have installed oracle 11g in windows 7 32 bit, Oracle actomatically starts when windows starts, I want to start oracle manually, how to stop oracle. kindly give tips, thanks in advance. |
| | Hello everyone, I am having a hard time finding the information I need and am hoping you all can help. I am using sql developer and I have a database named us that holds 5 tables and a database named uk that holds the same 5 tables. It is a … |
| | I am tring to recreate my oracle database -> sql server 2008. I never used sql server before, so I am using sql server management studio. I could create tables and views. The views I created using sql server management studio GUI has data in it. Now, I tried to … |
| | Hey everyone, I have a query that is to return a set of rows depending on its WIPDataValue. Say for example, I have added new WIPDataValue which is 1-9. So obviously the resulting set should have 9 rows and on those 9 rows, the value of each is 1-9. This … |
| | I made c# asp.net web applciation with oracle 10g database using visual studio 2008. It works fine with local environment. After I published on my web server and received the following error: *Could not load file or assembly 'Oracle.DataAccess, Version=10.2.0.100, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot … |
| | I made c# asp.net web form application with visual studio 2008 with oracle 10g database using Oracle.DataAccess. When I start debugging or start withoutdebuggin from visual studio, it workd fine. (visual studio and oracle 10g server and client are installed in my pc). I publish the application and use ftp … |
| | my report builder is having problems calling a form. i need the procedure. am using dev suite 2 |
| | Below is the sample code working fine in 10g and not working now in 11g. CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "PSTest" AS import java.sql.SQLData; import java.sql.SQLException; import java.sql.SQLInput; import java.sql.SQLOutput; import java.util.List; public class PSTest implements SQLData{ public String sql_type = "PS_TEST_TYPE"; private String id; public String … |
| | Hi, Can we get a SQL query, to display all the dates between two given dates eg. if date1=21-mar-2007 and date2=25-mar-2007 then the query should display all the dates between those two given dates i.e 22-mar-2007, 22-mar-2007, 23-mar-2007and 24-mar-2007. Query should not contain any plsql coding. Regards. |
| | Hi Guys, I am working with oracle Forms 11g and i want to navigate from one block to another, i used to use GO_BLOCK('BLOCK_NAME') before(10g, 6i), but now its not working in 11g i did a small resarch on the internet and its saying that GO_BLOCK must Work!! Any Ideas?? |
| | I have migrated my Oracle Developer 6i Forms and Reports to Oracle Developer 11g. Everything works fine except three of my batch report applications. They generate 300 to 400 reports each, which in 6i were stored (in pdf format) in a Windows network folder. From the folder they were emailed … |
The End.