Oracle

any possible merge condition with if else expression in plsql

Kumar MalloluNov 21, 202077510Forum

Hi All, We have installed Oracle 12 c 64 bit in our machine for our project (asp.net website) which is having Oracle Database as Backend. But when we are trying to run our code it is giving below exception SYSTEM.DATA.ORACLECLIENT REQUIRES ORACLE CLIENT SOFTWARE VERSION 8.1.7 OR GREATER We have tried all the possible solutions like Copied System.Data.OracleClient.dll to our bion folder Copied Oracle.DataAccess.dll But still same error coming, Kindly please share your thoughts

Hi, i need to give a GRANTS to some user in a Schema, what script i have to run? Thanks

Hi Friends, I am new to oracle database and my requirements is : Please create a function with commented code to calculate the subtotal which is returned to the calling program. The following particulars to help you with the task: ? The table for the data is BB_Basketitem ? Subtotal column is an aggregated calculated field (quantity * price) based on basket id that is a parameter of the function ? Define a local variable in the function to hold the subtotal calculated (hint: SELECT……….. INTO local variable CREATE OR REPLACE FUNCTION SUBTOTALS RETURN number IS total number(8); BEGIN Select Quantity * Price INTO total from BB_Basketitem where idBasket = 5; RETURN total; END; DECLARE result number(8); BEGIN result := SUBTOTALS(); dbms_output.put_line('Total is' || result); END; Pls. help me in this

Amit Kumar SinghNov 11, 202089710Forum

For example: Grant select on Schema. PkgName to USER; NOTE that there is a Blank Between Schema and Pkg´s name, how is that posible?? Thanks..

Hi All, I need a procedure to split comma sperated values in mysql workbench and insert those values in seperate table

siva nathanOct 19, 20201,19010Forum

Hi All, i have an Excel sheet with multiple columns need to import excel data into different tables using stored procedure my excel column below for ur ref Std Number Std Name Department Activity 1001 kowsic ECE project,sports 1002 sankar EEE sports,research i have an table in mysql side called Studentdata studentdata table columns like below column datatype stdnum int stdaname varchar(100) Department int Activity nvarchar(max) Department column refers department table Id need to write a stored procedure and inset into this table from excel sheet

siva nathanOct 16, 20202,04910Forum

Dear Team, I have a project with backend as Oracle. But, while accessing the ORacle Database from Visual Studio 2017, I am getting the following error - OCIEnvCreate failed with return code -1 but error message text was not available. PLease guide - How do I resolve this ?

How to import export database with in Oracle along with data or without losing data

Procedure Name Start Time End Time Elapsed Time Script1 021219 05:23:34 021219 05:23:38 4 Seconds Script2 021219 05:23:39 021219 05:23:39 0 Second Script3 021219 05:23:40 021219 05:24:00 20 Seconds

Kumar MalloluMar 13, 202085210Forum

Why Oracle Certification is too Important to becoming an Oracle Administrator If Someone having more than 6 years of experience then can he get a good opportunity in the marketing industry? If yes then list out the companies who are hiring with this approach and How?

CREATE OR REPLACE PROCEDURE USPX_TEST ( NAME IN VARCHAR2,cb_results_cursor OUT SYS_REFCURSOR) IS BEGIN OPEN cb_results_cursor FOR SELECT * FROM EMPLOYEES WHERE EMP_NAME = NAME ; END USPX_TEST; Please provide me how to convert this same procedure in postgreSQL. NOTE: we need to return the result in a cursor using out parameter Thanks in advance...

What will be the query of below mentioned question in Oracle ? Display each employee’s last name, hire date, and salary review date, which is the first Monday after six months of service. Label the column REVIEW. Format the dates to appear in the format similar to “Monday, the Thirty-First of July, 2000.”

Vikas Kumar GargFeb 10, 20201,78210Forum

I have input data like example need to convert as decimal Ex : 24:30:02 output as 24.5 Thank you.

Oracle server uses unnamed memory spaces to store data used in implicit cursors. - Ref cursors are used to define a cursor variable, which will point to that memory space and can be used like pointers in SQL ‘S’.

Sridevi KoduruNov 25, 20191,145Interview Question

Every front end technology has paging functionality, what are drawbacks of it and why we use database side paging ? What are pros and cons of database side paging.

Yogesh WaniNov 7, 20191,076Interview Question

Very often, we face the problem of how to import data from files to the database. PL/SQL provides an interesting solution: external tables. In this video, we will learn all about external tables.

Using a partition allows you to divide a large table into smaller portions. This allows us to speed up the execution of many queries. And this is what this lesson will be about.

Oracle is one of the most popular RDBMS (Relational Database Management System). PL/SQL (Procedural Language for SQL) is Oracle procedural extension for SQL. In this tutorial, you will learn the basics of PL/SQL in a few dozen minutes.

Hey, While fetching Datetime, I am getting result as 21/02/2016 but when i assign this value to another Datetime,it's show 21/02/16.20 gets remove. Thanks

Amit Kumar SinghJul 23, 20191,25610Forum

I have table1 and it has child tables, i want to reinsert data into every table. how to write scriept for this.? please help me on that.

I want to restrict my user dont enter password in sequential letters and numbers too,Is there any method in Oracle databse to achieve my this goal? Actually i did all the client requirement related to password security through Oracle Database SP, but i am unable to do this requiremet. is there anyone who help me out ? Thanks in Advance...