Oracle Questions
Grant Permission from one schema to other schema
Comments: 8
I have oracle db where it has tow schema;s A and B. i need to copy all the tables from A to B with the data. CREATE TABLE B.INPUTS AS (SELECT * FROM A.INPUTS WHERE 1=2);...
Need to convert the columns to row
Comments: 19
Hi Experts, -------------------------------------------------------------------------- SELECT TO_CHAR(d, 'Dd...
Need to have previous 3 days data.. using SELECT stat…
Comments: 8
Hi Experts, I have a requirement to have data for the employees, who are absent for last 3 consecutive days. For this.. one of the experts suggested the below query. There is a s...
Need to select last three working days data
Comments: 10
Hi Experts, I used the below query(given by one of your experts) data for employees who are absent for last three days. (SELECT TS.empcode FROM xxaqs_time_sheet_temp t...
inserting data into orcale table from a gridview control
Comments: 14
Hi Experts, could u guide me thru this pls: 1)items are displayed on a gridview control say 10 records 2)user clicks on inserts so that ALL items are imported into an oracle table ...
PLS-00363: expression 'OUT_ERR_MSG' cannot…
Comments: 11
Hi Experts, just looked at this code please there is an error on the "out_err_cd := -1; line " am just trying to implement custom errors ==================...
displaying custom errors in oracle
Comments: 6
Hi Experts, how do i display just 'Anonymous Number already exists' and not the full oracle message when a duplicate number is inserted raise_application_error (-20002,'Anon...
raise application error in oracle
Comments: 3
Hi Experts, how would i use raise application error in this code
how can i add one more primary key to atable if i have alrea…
Comments: 4
hi all, i am having atable which is having 5 cloumns on it and there 2 primary keys are there which is composite primary key with 2 columns . so i need to add one more column for this comosite ...
Using Decode
Comments: 3
Hi Experts, How do i code this senario.... If column has is null then display 'unknown', else display the actual number using decode? DECODE (t3.pd_passportnumber,...
ORA-02068 and ORA-00600 Errors, in Reports 6i
Comments: 7
Hi Experts, I'm getting the error when compiling the below code in one of the formula column of Reports 6i: Already in the main query I have the query with EMPMST@TKEEPDBLINK, and it...
SQL Update - text + column + text + column
Comments: 5
I really need a quick resolution to this sql update issue. We have requestid and checksum columns in a table row with another column that needs to be updated with a download link such as: "http:/...
Find table exists in database and if yes then check if field e…
Comments: 16
Hi, Need to check if table exists in database if yes then check if field exists in the table.Need one query to perform both . At the moment I have 2 queries : SQL = "SELECT TNAME ...
SP written in Oracle 10g showing compilation error in 9i
Comments: 8
We have written following SP in Oracle 10g and working fine but when we complie it on 9i its showing compilation errors.
Problem in a big query with SUM
Comments: 13
Hi.. This totals QUERY only gives a value different from 0 when it has at least one value in "ae_1". I am not beeing able to solve this problem. Can anyone please help me!? ...
ORACLE SCRIPT or Query for data set
Comments: 21
I have data as below in a Oracle table.Here for CHQSTREND colum value 1 means this is first cheque book in cheque book ,all records with 0 are the following chqleaves and the last leaf will have valu...
left join
Comments: 3
Hi I have a table receipt with field BANKER_ID then table BANKER WITH BANKER_ID, BANK_ID Then table BANK WITH BANK_ID, NAME From table receipt I need to check banker...
Invoice Number
Comments: 5
Hi, I am writing C# multi user windows application I want to generate invoice numbers based on financial year. Say 201011-1,201011-2 etc., when two users are operating si...
simple sql
Comments: 25
I have an oracle table which has following fields: acct_nbr sales_amt Now I want to add a row_id kind of a field to my table, so that when I send out sales_amt , I can just send row_...
Oracle trace - Locating which tables data goes into
Comments: 10
Hi, A client has a system where they receive reports from 40 or so locations with various data and they enter this into a 3rd party software that stores its data in Oracle. The reports, howev...
how to manually add a user to a group using Oracle Portal …
Comments: 3
Gentlemen and Ladies: I'm running Oracle Portal 9i (Windows 2003 server), and I'm unable to add users to a group the usual way (through the portal GUI, because of a JAVA error)...
Oracle Query
Comments: 7
Hi, I have a table with strucutre as follows STOCKTRANSFER_ID NUMBER(20), QUANTITY NUMBER(20,3), VALUATIONRATE NUMBER(20,3), VAL...
Oracle Query Help
Comments: 2
Hi The following query returns 2 rows. But I need output in single row. Can you pls help SELECT stocktransfer.stocktransfer_id,STORE.description "storefrom", stocktransfer....
Connect Oracle dataase through VB6
Comments: 5
I'm using VB6 and trying to connecto to Oracle database so I build an connection on the main Module like below Public con As New Connection con.Open "Provider=MSDASQL.1;Persis...
Stay Connected
Oracle Around the Web
- The latest Oracle news, tips, and tricks
- Oracle Unveils Netra SPARC T3 Servers
- Oracle fixes 21 flaws in Java SE, Java for Business
- Obama’s Silicon Valley “Tech Supper”
The latest Oracle news, tips, and tricks
Oracle Unveils Netra SPARC T3 Servers
New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...
Oracle fixes 21 flaws in Java SE, Java for Business
Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...
Obama’s Silicon Valley “Tech Supper”
Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...
Featured Oracle Experts
Testimonials
What users are saying about our experts
"The Oracle gurus provide answers, solutions and valuable workarounds"
User: schwertner
"Wow! Excellent, valuable explanation. Hats off to you"
User: aseshu70
"Solution worked fantastic and performs excellent! Thanks heaps"
User: klausbrandlhuber
Top Experts
Know a thing or two about Oracle? Join our team of experts today.