Forums Page 88
-
Need help with basic sql
Hi, I am using oracle 10g, and having some small doubts related to sql , here goes the situation I have a Transaction table , which contains…
-
Cursor statement failed with errors
Following statement failed with the errors. cursor proj_cursor1 is (select projectID from dsqa.table1 where projectID = any(select projectID from…
-
Revoking alter any table from a schema
Hi All, i am working in Oracle 10g. my requirement is to revoke all kind of DDL operations(except creating procedure etc) from a schema or user. for…
-
Consuming third party Payment Gateway API from Procedure.
Hi All, First of all i would like to thank all the people of the oracle forum for providing very good solutions. Here is my query. We are…
-
query help
Hi experts. i have a table rep2 like this PROD_COD ACCT_NO DUE_DAYS BALANCE LIMIT 1 1 101 15 100 200 2 1 102 17 150 200 3 1 103 32 500 1000 4 2 201…
-
Execure stored procedure on a timer
Can someone tell me an easier way to execute a stored procedure on a timer? I am using Oracle 10g R2 DB on windows 2003 server. I have a batch file…
- Advertisement
-
Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Oracle…
-
how to populate a drop down box
Hi buddies! PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar) is begin DOWNLOAD_REPORT_HEADER(report_name); htp.p('<div id="content">')…
-
SQL query not working well
Hi, I made a small table with 5 rows and want to make them an sql consult using rownum so I'm running select * from mytable where rownum = 1; and it…
-
Data storage spaces in varchar2
Trying to understand what's happening. I am selecting a value from a table that is defined as char(16) and placing in a new table defined as…
-
Find current logon time
Hi, in my sql script i want to query and find out the logon time of the current session. If i connect to the gv$session table, i have to pass other…
-
Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thought I could use the ASCII function, but SELECT…
-
please help me in this update statment
hi every one if I have table and this data in it id name 10 john 10 ibraham 10 edward 10 kerry now I want this update only the last row that update…
-
help with multi-update
Now sure how to ask this really.... 10g database if that matters. I have a customer that accidently changed 742 records incorrectly. I'm being asked…
- Advertisement
-
max function question
Hi All Ihave a table that holds shipment numbers and dates like this select * from ship_tab; ship_num date_ship 1 09-SEP-09 2 17-SEP-09 3 25-SEP-09 i…
-
please help me in this update statment
hi every one if I have table and this data in it id name 10 john 10 ibraham 10 edward 10 kerry now I want this update only the last row that update…
-
help with multi-update
Now sure how to ask this really.... 10g database if that matters. I have a customer that accidently changed 742 records incorrectly. I'm being asked…
-
Splitting Attributes
SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part", substr(I_NAME, INSTR(I_NAME,'O')+1) "Second part" FROM Enrollment WHERE I_NAME…
-
Combining refCursors and Summing
Given the following DDL: CREATE TABLE FOODSALESTEST ("WEEKNBR" NUMBER, "STOREID" NUMBER NOT NULL, "GUESTS" NUMBER NOT NULL, "TACOSALES" NUMBER NOT…
-
Problem with a select distinct
I have a problema with a select distinct, I have the next sql: select distinct a,b,c,d from (select a,b,c,d,e,f...from table where ...) The subselect…