If i can set nls_date_format using (i.e)
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS'
How can i get the value of this parameter once it has been assigned or other session v...
Hi Experts,
I have the error above.
Here is the sp
CREATE OR REPLACE PROCEDURE get_All_User_sp(crs OUT types_pck.refCursor) AS
BEGIN
OPEN crs FOR
SELECT user_id AS "User ID"...
I have created a user for the developers on the database server to run processes to import into the database.
However, when they try to run sqlplus the hit error message.
I know it is caused...
I have installed Oracle 8i Database in to a Win2000 Server and installed SQL Navigator 4 to a WinXP Client. When I tried to connect to the database it gave following error (using SQL Navigator...
Hello Everyone,
Please disregard the version i stated earlier it is in fact Oracle 10.2 that i am using
I'd like to thank everyone before hand for any assistance provided. I am trying to ...
hi experts
pls give me a shortcut way to get date differece in hours and minutes.
say i have two fields date1,date2
but date2-date1 results in days.
which i have to convert in hours
...
Hey guys,
I have a date stored in a column in Oracle in DATE format. When I look at the data through a select statement it returns
mm/dd/yyyy hh:mm:ss am(pm)
I'm a SQL Server guy an...
I have the following select
select count(*)
from SLOG, BRPS
where SLOG.task like 'QPRO%'
and SLOG.bpdate = BRPS.PREVBRANPRCDATE
and SLOG.BR = BRPS.BR ;
Now, I want to dele...
how do i do a left function in oracle..
stra='abcderrrrrr'
left([stra],5) =abcde(I would do it this way in vba but inoracle how do i do it
also how do it do multiple if consitions in...
I just install the database from the scratch and select the most common installation instructions. It creates a database by default. Now I make a user and import data into just one table from ...
Hi there
My background is in SQL Server, I decided to learn dba tasks about Oracle.
Having problems similarly with Install plus creating a database and managing a database created.
If...
I'm developing an application using VB and oracle.As I know, we can use mid () function in MySql query. but I tried to apply it in my vb project, but got error ORA-00904 which stated 'invalid...
Apologies if this sounds a little remedial but as a Java developer I dont often have cause to write my own stored procedures and those that I have written have not been on Oracle.
Basicall...
Hey folks,
Running into a little SQL translation problem here...usually work in SQL Server
What is the correct Oracle statement for SQL below?
SELECT Right(USER_ADDR_NO,4) AS the_Righ...
Hi all!
I have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect.
Thanks!!
I hava the following update query:
UPDATE CUSTOMER_TRANSACTIONS CTC
SET CTC.PERIODID = '2005-2006', CTC.PROCESSID = '200612'
FROM CUSTOMER_TRANSACTIONS_20070716 CTO
WHERE CTO.PERIODID ...
I have a dynamic table name and need to run query against that table. The Following should be understandable by people, but not oracle :)
create_table_name := 'CONFIGMASTER_' || TO_CH...
hi all
how can i call procedure fro sql plus when it has return parameters
Is it possible to restore from a backup set where the set is in a
different disk location from where it was originally created.
For example:
replace script test_full_recovery {
alloca...
Hi,
I need a very quick help.. Iam having a DOS batch file from which I am connecting to oracle to execute a sql script. I connect using sqlplus. Now I want to limit the number of attempts ...
I've just installed Oracle 10g Express on my home computer but when I try to go to the Database Home Page, I get this error: "The requested URL could not be retireved: http://127.0.0.1:8080/...
Hi,
I have very huge table ( 150 fields and 35 Million records), every month that table will grow up to 20 Gig.
Users will be running reports against this table with date range. I u...
I encountered a problem with connecting to the Oracle databse. Here is the description of the problem.
Backgroud : I am using Win2K advance server and Oracle 8i Server. To avoid version confl...
I have a remote database. I can ping the host but if I use tnsping80 I receive "TNS-12535:TNS:operation timed out"
I know that:
1. TNSPING80 never connects with the network listener.
2. T...
folks
how do i convert the datepart function in sql server to oracle
i.e
SELECT datepart(year, SYSDATE)
, datepart(month,SYSDATE)
all help will do
r
