1,488 Topics
 | |
 | I am writting a query in SQL Developer. I have a field in the table that holds a timezone. I need to set the query to use that timezone. Any ideas? Here's the query I have so far: [CODE]select to_char(dateoftransport, 'MM-DD-YYYY') as "Date", dispatch_id as "Dispatch, vehicletype as "Dispatch Type" … |
| | Is it possible to create a trigger on a synonym on a database Links |
| | i am trying to simulate an alert for transaction being done on a bank account as my project but the person i asked to help me told me that using flexcube all i need is to execute the code below it would create a table OUTMESG which my own code. …  |
| | I cannot find the mistake in the below code, I receive "statement ignored error" at the last line of the first select clause part of the code:[CODE]SELECT * BULK COLLECT INTO l_employees FROM employees;[/CODE] But I am not sure if thats the real problem. Here is my full code [CODE]declare … |
| | can any of you help me by giving the project on library management system using VB6.0 and ORACLE 9i.... please friends... send me to email : <<Email Snipped>> |
| | hi, I have objects called Customer_obj , phonecall_obj , then I have tables of these objects where there is a reference to the customer table inside the phonecall_obj table. I try to pass the customer object in a stored function to search in the phonecall tables about that specific customer … |
| | Hello I am really new to Java/Oracle. I am having NetBean 6.8 IDE for development. jdk1.6.0_17 Where do I start? THANKS advance!!!!!  |
| | hiii i am doing a project using jsp and oracle.... i am stuck on one thing.... in my project i am asking the user some FAQs about symptoms he has.... depending on the answers he gives i want to show him probability of the diseases he may have... but i …  |
| | |
| | what is major differences between sql server and oracle? |
| | |
| | I want to combine the following select statements so I can have 1 export file rather than 2. This code selects student information along with their HomeRoom teacher. [code]SELECT students.last_name, students.first_name, students.grade_level, teachers.last_name, students.student_number FROM students JOIN CC ON students.id = cc.studentid JOIN teachers ON teachers.id = cc.teacherid WHERE (cc.course_number … |
| | I just loaded the 10g client EM on my Windows workstation to connect to our 10g database. Everything works great except I dont see any place where I can edit records. I have to use SQL Plus to edit records but was hoping to use a GUI like I had … |
| | Hello Friends, I have a small challenge, i need to motify a shell script designed to monitor an oracle database. It should notify the DBA when the listener & database is down and also notify when there is any error in the alert log. Note: The sendmail feature should not … |
| | I am trying to implement object inheritance with oracle 10g express. What i have done so far is created some types and subtypes. And some tables based on those types and sub types. So far i have understood that the subtypes inherit the attributes and methods from its super types. … |
| | Does anyone know anything about Oracle Roles & privileges. An application on 9i has multiple roles assigned to each user. I am getting permissions problems, I think because there are conflicting privileges within the roles. EG: Role1 has SELECT, UPDATE on table1. Role2 has SELECT, INSERT on table1. User Default … |
| | Knowing to be one of the most advanced Technology Provider across the Globe, The umbrella of Oracle has made space for JD Edwards, Sun, PeopleSoft, Siebel and many more technologies. You wanting to reach out to the technology users out in the market place does not necessarily require confinement towards … |
| | hello friends, Please help me . Currently i'm building my project using back-end in Oracle but i'm not getting the exact solution. I've idea about nvarchar datatype but it seems that i don't know proper use of it. so experts please show your talent to help me thanks regard |
| | Nipping problems and stakes at its bud is not the end of paving path towards success. If nipping problems forms the initial step of succcess marking, the second step is in formulating the right marketing strategy for the company.  |
| | |
| | Hello, I'm getting from an application log the following query: [CODE]select * from lxRO_4606b095 where lxToLat=:va and lxToId=:vb and lxType in (:vc,:vd,:ve,:vf,:vg,:vh) :va=1174843541 :vb=1959561595 :vc=1183424550 :vd=1183482004 :ve=1182541895 :vf=1182543699 :vg=1182550204 :vh=1182581348[/CODE] the problem is that this does not work in Oracle, there seems to be a problem with variable substitution. Is … |
| | Hi, I know there is an XML/Xpath topic already, but how about a SOA topic? Users can then post questions on Oracle SOA, Netbeans SOA, etc... Thanks, -Ashton.  |
| | kindly please tell me how to connect from java to ms access, sql,oracle and so etc . with example |
| | Hello. I am not getting the right idea to the oracle table in the list box so can anyone please tell me how can i list the oracle sql plus table's column in the listbox. Thanks in Advance. |
| | Having problems with connecting to an Oracle database, getting an error : Unrecognized attribute 'providerName' - Defined in web config : [<add key = "connection" value="Provider=MSDAORA;Data Source=TNSnames definition;Persist Security Info = True;Password=pass;user id =userid;" providerName="System.Data.OleDb"/>] program imports: [Imports System.Data.OracleClient Imports System.Data Imports System.Data.OleDb Imports System.Configuration Imports System.Object] help please...:0)  |
| | Hello every one I am trying to insert text into oracle 10g, which contains ( ‘ ) single quotes. I know its simple , I have tried google. This is the error I get Warning: ociparse() [function.ociparse]: ORA-01756: quoted string not properly terminated in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\qmon\age.php on line … |
| | While retrieving an uploaded file (stored in blob) from oracle database, junk characters are displayed at the start & end of the uploaded content. Also it does not show every line. Part of the code can be found below. Can anyone help or has some different solution?? [B]Upload.aspx.cs (Upload file … |
 | Hi there Can somebody please give me a link to a tutorial regarding materialised views/snapshots (preferably in Oracle) and perhaps some sample scripts too. Thanks in advance. |
| | Hi Actually i want to know the driver name to use for database connection using Oracle XE. |
| | [COLOR="Red"][/COLOR]hi frnds !!! I am an engineering student of 3rd year and i want to make a DBMS project so please suggest some good n unique projects on dbms. I'll be really grateful.Plz help me |
The End.