Working with Oracle

• Topics

  Started by

  Posts

  Last post

• BETWEEN DATETIME STATEMENT NOT WORKING

  I am using the follow segment in my query, but it is only running the query by date :- (to_date(PRO…

  FraserGus

  2 replies

  6 months ago

  By: Ant-Green

• BETWEEN DATETIME STATEMENT NOT WORKING

  I am using the below segment in my query :- to_date(PROCESS_DATE, 'dd/mm/yyyy hh24:mi:ss')) BETWEEN…

  FraserGus

  1 replies

  6 months ago

  By: ratbak

• BETWEEN DATETIME STATEMENT NOT WORKING

  I am using the below segment in my query :- to_date(PROCESS_DATE, 'dd/mm/yyyy hh24:mi:ss')) BETWEEN…

  FraserGus

  1 replies

  6 months ago

  By: ratbak

• Help needed in ORACLE Group by

  Hello, working in Oracle Database 19c Enterprise Edition. Below is my sample data with Sample( ID, …

  KGJ-Dev

  2 replies

  1 year, 1 month ago

  By: KGJ-Dev

• Dates about sql ORACLE

  I have the following Oracle sql script, I only need all the records from yesterday. and fch_date &g…

  antoine_mc1

  1 replies

  1 year, 4 months ago

  By: ratbak

• Dates about sql ORACLE

  I have the following Oracle sql script, I only need all the records from yesterday. and fch_date &g…

  antoine_mc1

  1 replies

  1 year, 4 months ago

  By: frederico_fonseca

• Log shipping or Sychornization for Oracle vs SQL server

  I may click twice, delete this duplicated one This topic was modified 1 year, 11 months ago…

  sqlfriend

  1 replies

  1 year, 11 months ago

  By: sqlfriend

• Log shipping or Sychornization for Oracle vs SQL server

  I would like to ask someone working on both Oracle and SQL server. For oracle, we have a script on …

  sqlfriend

  2 replies

  1 year, 11 months ago

  By: sqlfriend

• Is each serializable schedule view serializable?

  We are aware that conflict serializability is a valid subset of view serializability in DBMS Schedu…

  Piyushbhatt

  1 replies

  2 years, 6 months ago

  By: Piyushbhatt

• backup database in SQL Server VS Oracle

  I would like to know the difference of full back up between Oracle and SQL server. In SQL server, f…

  sqlfriend

  4 replies

  2 years, 11 months ago

  By: sqlfriend

• SQL Server to Oracle

  (Apologies if this has been asked before- I did have a look around, and I couldn't see anything.) I…

  Beatrix Kiddo

  11 replies

  3 years, 8 months ago

  By: anuradha122

• Sp_help for Oracle?

  I'm building a set of SQL Server views that use OPENQUERY to run queries against an Oracle server. …

  g.britton

  10 replies

  4 years, 3 months ago

  By: MarieWalker

• difference if statement in oracle vs SQL server

  I would like to know the difference of usage and syntax of if statement between T-SQL vs PL-SQL. I …

  sqlfriend

  1 replies

  4 years, 4 months ago

  By: Jeff Moden

• Oracle Linked server randomly failing from sql agent job

  I have a number of jobs that fail because of a linked server message. Executed as user: Domain\User…

  jshurak

  2 replies

  4 years, 4 months ago

  By: Stephan Neethling

• Tabularize Oracle Results

  Hi All, I haven't posted here in years so that means I'm a bit rusted. This time around I have…

  kabaari

  6 replies

  4 years, 5 months ago

  By: CeciliaSams