How to design leave management system database design?
when a create a connection string using provider oraoledb.oracle.1 and user id is sys . Then i can't connect to data source,its give me the error as(connection to sys should be as sysdba). can...
Hi EE,
a) what does this work flow do:
DBA
DATA IMPORT/EXPORT/
SQL LOADER WIZARD
Is the above how you would export the contents o...
Dear expert,
I have 2 columns in time_sheet table
SHIFT_IN TIME_IN
'09:00:00 AM' '09:30:00AM'
BOTH OF VARCHAR2(10);
How i can find out the diff between time_in...
hi, i have an ora-1033 error message, any idea?
Hi gurus,
I've overloaded procedure. It is throwing following error. Your helping hand required. Thanx --Victor
PLS-00323: subprogram or cursor 'START_SP' is declared in a package speci...
Dear Experts -
I've a problem with the LPAD in thie SQL. It works in seconds if I do not do the LPAD.
select xref.tid cust_num
from rel_ent bre,
rel br,
...
Which a System table provides the the last Compile date of a package, package body , function and procedure in Oracle?
Please advise on how can i send email from oracle procedure. I have a requiremnt in which i need to send an alert email if count does not match. I never used email in procedure before.
Please...
How can I change the below varchar2 (500)
"CHARVALUE" column so "> 0" works on and
it skips all the non-numeric errors ?
There are 100+ records and only 80
of them can be converted to...
Hi,
I was referring to this example
SELECT employee_id, last_name, manager_id, LEVEL
FROM employees
CONNECT BY PRIOR employee_id = manager_id;
Assuming we have only employee id an...
I have a "mytable" table in Oracle.
CREATE TABLE mytable
(
MYCOL1 NUMBER NOT NULL,
MYCOL2 CHAR(3) NOT NULL
)
The mytable has the following r...
In Oracle, how can I concatenate multiple results returned from a single-field select statement into a comma-separated string?
I am trying to use in in a subquery so in case a subquery return...
Hi EE,
a) In a recent post, mr. joltcola gave me a link to download TOAD freeware
http://www.toadsoft.com/lic_agree.html
b) anyone on EE using TOAD freeware? If yes, do you have t...
The form that I am working on has a key block Swamajr_Key_Block followed by the first database block, Swbmajr further down the list. When I enter all the values into the text items in the key ...
I'm trying to spool a select statement to which returns a list of SSNs meeting a certain criteria. When this runs, there are 16 spaces placed after each SSN. In order for me to use the spool h...
I have a function that has code like this:
select case
when sysdate > trunc(sysdate) + 12/24 then trunc(sysdate)
else trunc(sysdate -1)
end
from dual
It returns yesterday's date ...
Hi Experts,
This is very urgent!!!
I need to write a PL/SQL procedure to compare the data between the two tables. If I found the record mismatch then I need to write to the other table say...
emp table has c1, c2, c3, c4...c10 columns. I like to query all_tab_columns table and build a string like: my_string = ' select c1, c2, c3, c4 , c5, c6, c7, c8, c9, c10 from emp';
P...
Hi all - we keep having a problem with an application. Our developer has not put any validations in our date fields, therefore we are getting bad data for our reports. (well, the reports wil...
We have new policy in our company, we need to know whenever any one delete the ORACLE database logs and record the operation. So we know by who & when the logs were deleted.
What would be better
a) to use triggers or
b) to put the logic into Java code?
I'm working on Java app and now I need to decide how to perform updates ... I was asked to use triggers and ...
the database table is shown below, the choice can only be 2, school CTDS or school Entity ID.
I've attached the database as an excel table to make it easier for you guys to see
How can I get the below to work,
extracting all 20, 31, 25, and
41 records ?
** SQLCODE db screenshot and
sample tables attached
select *
from gml_roitem ROI
where ROI.LOC_N...
Experts,
I need to send instructions to a remote office on how to change the SID. The incorrect SID was used in the installation. What are the steps to change the SID on a Windows 200...
