Sign Up

Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.

Sign Up Here

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here

Sorry, you do not have permission to add post.

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Oraask Logo Oraask Logo
Sign InSign Up

Oraask

  • Write
    • Add A New Post
    • Ask A Question

Oraask Navigation

Search
Ask A Question

Mobile menu

Close
  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials
Home/query

Oraask Latest Questions

Question
Olivier
  • 0
OlivierExplorer
Asked: January 6, 2018In: JavaScript

How can I get query string values in JavaScript?

  • 0

Is there a plugin-less way of retrieving query string values via jQuery (or without)? If so, how? If not, is there a plugin which can do so?

javascriptquerystring
0
  • 0 0 Answers
  • 357 Views
  • 0 Followers
Answer
Question
Chandra
  • 1
ChandraExplorer
Asked: October 31, 2017In: Oracle E-Business Suite

how can i get PO Revision History details – oracle EBS R12?

  • 1

hello guys, please help me to get the po change history for revision details when we compare current po with original po? thanks in advance.

ebs archivingfricew componentsgetpooracle ebs historyoracle ebs version historyoracle riceoracle rice componentsoracle ricewpo archive tables oracle appspo change historypo change history query in oracle appspo change history table in oracle appspo historypo history table in oracle appspo revisionpo revision table in oracle appspo_distributions_archive_allpo_headers_archive_allpo_line_locations_archive_allpo_lines_archive_allqueryrice componentricewricew oraclesqlsupply chainwhat is ricew
1
  • 1 1 Answer
  • 9k Views
  • 0 Followers
Answer
Question
Maran
  • 0
Maran
Asked: July 19, 2017In: Oracle SQL

Which one do better performance NOT IN vs NOT EXISTS ?

  • 0

Hello, Which of these queries is the do better performance NOT IN vs NOT EXISTS? and please give me an clear example if possible. thanks

querysql
1
  • 1 1 Answer
  • 424 Views
  • 0 Followers
Answer
Question
Sam
  • 0
Sam
Asked: July 19, 2017In: Oracle SQL

How to select a random row in SQL& MySQL?

  • 0

Hi I want to select a random row in SQL& MySQL?

How toMySQLqueryrowsql
1
  • 1 1 Answer
  • 370 Views
  • 0 Followers
Answer
Question
matheo
  • 0
matheoExplorer
Asked: July 14, 2017In: Oracle Applications DBA

Would you use flashback query to synchronize two schemas as of a certain point in time?

  • 0

We have an application which requires switching between two identical schemas with many tables on a daily basis. Flashback query is used to guarantee data consistency, to make sure we get 100% identical copy of the first schema as of ...

dbaflashbackqueryschemassynchronize
1
  • 1 1 Answer
  • 542 Views
  • 0 Followers
Answer
Question
matheo
  • 0
matheoExplorer
Asked: July 14, 2017In: Oracle SQL

How to order by number inside of character for a query like ’25 AB’ ,’30 MT’ ?

  • 0

Hi, I have set of values and I want to order by as follows : we scan left to right . for example for values like '25 AB' ,'30 MT'. 25 comes before 30. [code] create table test_table(COL1 varchar2(240)); insert into test_table values ('50000'); insert into test_table ...

How toorder byquerysql
1
  • 1 1 Answer
  • 744 Views
  • 0 Followers
Answer
Question
Mina
  • 0
Mina
Asked: July 12, 2017In: Oracle Applications DBA

Can you provide me query to get specific report in EBS R12?

  • 0

Hi, I need Query to get detailes for a specific report Like (stauts , start date , End Date , who's run ? ,...) in EBS R12?

oraceloraclequeryreports
1
  • 1 1 Answer
  • 786 Views
  • 0 Followers
Answer
Question
Jone
  • 0
JoneExplorer
Asked: April 30, 2017In: Oracle SQL

How to remove duplicate rows by where condition ?

  • 0

I have a test_table with the following data : [code] select * from test_table; [/code] Number Name 1 AA 1 DD 2 QQ 3 WW 4 EE

queryremove duplicate valuesselectsql
1
  • 1 1 Answer
  • 527 Views
  • 0 Followers
Answer
Question
Jone
  • 0
JoneExplorer
Asked: April 13, 2017In: Oracle SQL

Using between on sysdate instead of TRUNC

  • 0

Hi , I have the below query where am using TRUNC on the column2 filed which is increasing the performance delay. so need to avoid the TRUNC on this check and need to use BETWEEN operator. Here SYSTEMDATE is the currentdateandtime. So how can ...

betweenoraclequerysqltrunc
1
  • 1 1 Answer
  • 556 Views
  • 0 Followers
Answer
Question
oracle user
  • 0
oracle userExplorer
Asked: April 7, 2017In: Oracle SQL

need query to display ‘job’ & their counts & then display the no. of distinct ‘dept no’ under each ‘job’ & their counts ?

  • 0

hello experts, what i want is :  query to display 'job' & their counts & then display the no. of distinct 'dept no' under each 'job' & their counts ? consider i have these dataset : SQL> select * from dept; DEPTNO DNAME LOC ---------- -------------- ...

departmentsemployeesoraclequerysql
1
  • 1 1 Answer
  • 855 Views
  • 0 Followers
Answer
1 2

Sidebar

Adv 250x250

Explore

  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials

Footer

Oraask

About

Oraask is a website for developers and software engineers who want to learn new skills, share their knowledge, and solve their coding problems. Oraask provides free content on various programming languages and topics, such as Oracle, Python, Java, etc. Oraask also allows users to ask questions and get answers from other members of the community.

About Us

  • About Us
  • Contact Us

Legal Stuff

  • Privacy Policy
  • Terms & Conditions

Follow

Oraask is licensed under CC BY-NC-SA 4.0Oraask CopyrightOraask CopyrightOraask CopyrightOraask Copyright

© 2019 Oraask. All Rights Reserved
With Love by Oraask.