true

Find the best tutors and institutes for Oracle PL/SQL

Find Best Oracle PL/SQL

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

Oracle PL/SQL Updates

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

Lesson Posted on 30/06/2017 IT Courses/Oracle Training/Oracle PL/SQL

How To Create The Java Souce In Oracle PLSQL?

Murali Krishna

Having 13+ years of experience in oracle plsql,unix,informatica ,Core java,JDBC,JSP,Servlets and JAVA script.

Requirement: How to find the list of files in specified directory? Step1 : First find the JDK Install or not in the oracle, to find jdk version please run the below sql. SELECT dbms_java.get_ojvm_property(PROPSTRING=>'java.version') FROM dual Step2: Once get the output above then only we can create... read more

Requirement: How to find the list of files in specified directory?

Step1 : First find the JDK Install or not in the oracle, to find jdk version please run the below sql.

SELECT  dbms_java.get_ojvm_property(PROPSTRING=>'java.version') FROM dual

Step2: Once get the output above then only we can create the java source. If the output is diaplyed then perform the below task

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "list_of_files" AS

import java.io.File;

public class list_of_files {

public static String getFileList(String idir)

// public static void main(String[] args)
{
//System.out.println("testing");

File aDirectory = new File(idir);
File[] filesInDir = aDirectory.listFiles();
String result = "";
for ( int i=0; i<filesInDir.length; i++ )
{
if ( filesInDir[i].isFile()
&& !filesInDir[i].isHidden() )
{
result = result + "," +filesInDir[i].getName();
System.out.println("result="+result);

}
}
return result;
}

}

--------------------------------

Compile the above code.

3. create or replace function test_fun(p_dir varchar2) return varchar2
AS LANGUAGE JAVA NAME
'list_of_files.getFileList(java.lang.String) return String';

----------------

Compile the above code

4.select test_fun('c:\jars') from dual;

 run the above sql command.

 

 

 

 

 

 

read less
Comments
Dislike Bookmark

Answered on 17/03/2017 IT Courses/Oracle Training/Oracle PL/SQL

Manoj Kumar Vishwakarma

DBA Trainer

In computer science, ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties of database transactions. In the context of databases, a sequence of database operations that satisfies the ACID properties and, thus, can be perceived as single logical operation on the data is called a... read more
In computer science, ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties of database transactions. In the context of databases, a sequence of database operations that satisfies the ACID properties and, thus, can be perceived as single logical operation on the data is called a transaction. read less
Answers 15 Comments
Dislike Bookmark

Lesson Posted on 22/02/2017 IT Courses/Oracle Training/Oracle PL/SQL

How To Return a Result Set from a Stored Procedure

Sagar Sahoo

I am currently working as Oracle PL/SQL Developer and designated as IT Analyst. I am having experience...

One of the easiest ways to tackle such Real Time scenarios is through use of Oracle Defined "SYS_REFCURSOR" or "REF CURSOR". We can create a Procedure with an out parameter of Type SYS_REFCURSOR and in the execution block we can open a cursor variable of same type as SYS_REFCURSOR for the required Select... read more

One of the easiest ways to tackle such Real Time scenarios is through use of Oracle Defined "SYS_REFCURSOR" or "REF CURSOR".

We can create a Procedure with an out parameter of Type SYS_REFCURSOR and in the execution block we can open a cursor variable of same type as SYS_REFCURSOR for the required Select Query.

I will update this with a sample Code shortly.

Till then Cheers and Enjoy!!

read less
Comments
Dislike Bookmark

Looking for Oracle PL/SQL

Find best Oracle PL/SQL in your locality on UrbanPro.

FIND NOW

Lesson Posted on 13/02/2017 IT Courses/Java IT Courses/Oracle Training/Oracle PL/SQL IT Courses/Unix Shell Scripting Training

Amazon written test for experience

Suresh

I have more than four years of professional experience in development and maintenance in Hadoop and Hadoop...

For the below written test answer I defined with "*" at the end of the options NULL is the same as 0 for integer the same as blank for character * the same as 0 for integer and blank for character the same as 0 for integer and blank for character The basic function of ____________ is... read more

For the below written test answer I defined with "*" at the end of the options 

NULL is

  • the same as 0 for integer
  • the same as blank for character       *
  • the same as 0 for integer and blank for character
  • the same as 0 for integer and blank for character

The basic function of ____________ is to search for files(or other units of text) that contain a pattern.

  • awk  *
  • search
  • cat
  • cmp

  What will be the output of the program?

class SSBool

{

    public static void main(String [] args)

    {

        boolean b1 = true;

        boolean b2 = false;

        boolean b3 = true;

        if ( b1 & b2 | b2 & b3 | b2 ) /* Line 8 */

            System.out.print("ok ");

        if ( b1 & b2 | b2 & b3 | b2 | b1 ) /*Line 10*/

            System.out.println("dokey");

    }

}

 

  • ok
  • dokey  *
  • No output is produced
  • Compilation error

  What does the literal “$?” mean in Shell script?

  • Exit status of the previous command executed
  • Exit status of the last command executed   *
  • Exit status of the first command executed
  • Exit status of the last command failed

  If 10 bulls can plough 20 identical fields in 3 days working 10 hours a day, then in how many days can 30 bulls plough 32 same identical fields working 8 hours a day?

  • 2  *
  • 4
  • 8
  • 10

 What will be the output of the following query? SELECT DECODE(TRANSLATE('A','1234567890','1111111111'),'1','YES', 'NO' ) from DUAL;

  • NO  *
  • YES
  • 1234567890
  • 1111111111

Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE. The SQL statement prints? SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM Employee);

  • 10
  • 9  *
  • 1
  • 0

  What is the output of the following program?

x = 3; y = 5; z = 10;

if [( $x -eq 3 ) -a ( $y -eq 5 -o  $z -eq 10 )]

then

    echo $x

else

    echo $y

fi

 

  • 1
  • 3
  • 5
  • Error  *

A train running at the speed of 60 km/hr crosses a pole in 9 seconds. What is the length of the train?

  • 120 metres
  • 180 metres
  • 324 metres
  • 150 metres  *

Predict output of the following program

 

#include

typedef struct film{

    int size;

    int pixel;

    float price;

}xyz,pqr;

 

struct film *jadu(){

    static xyz one={231,12,900.0},*p=&one;

    return p;

}

 

int main(){

    pqr *ptr;

    ptr=jadu();

    printf("%d",ptr->pixel);

    return 0;

}

 

  • 231
  • 12  *
  • 900.0
  • Compilation error

What will be the output of the following query? SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '*'),'','TROUBLE') FROM DUAL;

  • ATHEN
  • **ATHEN
  • ATHEN***
  • None of the above  *

 

How will you list all the files within a directory including hidden files aka (.) dot files?

  • ls –a   *
  • ls –h
  • ls –q
  • ls –t

How to make any script file executable?

  • $chmod 655 *.sh
  • $chmod 765 *.sh
  • $chmod 755 *.sh  *
  • $chmod 754 *.sh

How to find current running processes in Unix server?

  • $ ps –ef *
  • $ ds –ef
  • $ du –ef
  • $ ls –ef

Bottom of Form

 

The least significant bit of the binary number, which is equivalent to any odd decimal number is

  • 0
  • 1   *
  • 1 or 0
  • None

Which OSI layer is responsible for Encryption and Decryption?

  • A) Network Layer   *
  • A) Network Layer
  • C) Data Link Layer
  • D) Presentation Layer

Which of the following memories has the shortest access time?

  • Cache memory *
  • . Magnetic Bubble memory
  • Magnetic core memory
  • RAM

Expand the following abbreviation – USB?

  • a) Universal sequence bit
  • b) Universal serial bus *
  • c) Universal sequence byte
  • d) Unique serial bit

How many times printf() will be executed in the below mentioned program? main() { int i; for (i = 0; i < 4; i++) fork(); printf(“my pid = %d\n”, getpid()); }

  • 4
  • 8
  • 16  *
  • 32

 

 What will be the output of the below program?

 

#include

int main(){

int far *p=(int *)0X70230000;

int far *q=(int *)0XB0210000;

int near *x,near*y;

x=(int near *)p;

y=(int near *)q;

if(x==y)

printf("Both pointer are equal");

else

printf("Both pointer are not equal");

 

    return 0;

}

 

  • Both pointers are equal
  • Both pointer are not equal
  • Segmentation fault
  • Compilation error  *

What is the difference between linux file system and windows file system?

  • A) Under Linux, the various partitions are detected at boot and assigned a drive letter whereas Under windows, unless you mount a partition or a device, the system does not know of the existence of that partition or device. *
  • B) Under Windows, the various partitions are detected at boot and assigned a drive letter whereas Under Linux, unless you mount a partition or a device, the system does not know of the existence of that partition or device
  • C) Under Windows, the various partitions are detected at reboot and assigned a drive letter whereas Under Linux, unless you mount a partition or a device, the system does not know of the existence of that partition or device
  • D) Under Windows, the various partitions are detected at reboot and assigned a drive letter whereas Under Linux, you mount a partition or a deviceBottom of Form

A bitwise operation 'f' has an interesting characteristic, such that, if f(a,b) = c, it always turns out to be the case that f(b,a) = c; f(a,c) = b; f(c,a) = b; f(b,c) = a; f(c,b) = a.

  1. a) Which of these functions could 'f' possibly be?
  • f(a,b) = a XOR b  *
  • f(a,b) = a + b
  • f(a,b) = a - b
  • f(a,b) = a * b

the following crontab file entry

0 17 * * 1,2,3,4,5 /usr/sbin/ckbupscd >/dev/console 2>1

The above entry says to run /usr.. at what time

  • 17 mins pass midnight
  • 5 pm on weekday of each month *
  • Midnight on the 17 day of each month
  • On the 17 day of each month at 1,2,3,4 and 5 pm

 

 How would you sort a file called shopping on column 3?

  • A) Sort –n 3 shopping
  • B) Sort –K 3 shopping *
  • C) Sort –c 3 shopping 
  • D) Sort –c3 shopping

What is the output of following program?

 

#include

void print(int n, int j)

{

   if (j >= n)

      return;

   if (n-j > 0 && n-j >= j)

       printf("%d %d\n", j, n-j);

   print(n, j+1);

}

 int main()

{

    int n = 8;

    print(n, 1);

}

 

  • 1 7 2 6 3 5 4 4 4 4   *
  • 1 7 2 6 3 5 4 4
  • 1 7 2 6 3 5
  • 1 2 3 4 5 6 7 8

 What is 2NF in normalization?

  • A) if the domain of each attribute contains only atomic (indivisible) values, and the value of each attribute contains only a single value from that domain.[
  • if all the attributes in a table are determined only by the candidate keys of that table and not by any non-prime attributes
  • If no non-prime attribute is dependent on any proper subset of any candidate key of the table  *
  • D) None of above

A train running at the speed of 60 km/hr crosses a pole in 9 seconds. What is the length of the train?

  • 120 metres
  • 180 metres
  • 324 metres
  • 150 metres  *

 Predict the output of the following program

 

#include

usingnamespacestd;

intmain()

{

    constchar* p = "12345";

    constchar**q = &p;

    *q = "abcde";

    constchar*s = ++p;

    p = "XYZWVU";

    cout << *++s;

    return0;

}

 

  • a
  • c
  • b
  • D) Garbage value  *

 Predict output of the following program

 

#include

using namespace std;

class Test

{

protected:

    int x;

public:

    Test (int i):x(i) { }

    void fun() const  { cout << "fun() const " << endl; }

    void fun()        { cout << "fun() " << endl;     }

};

 

int main()

{

    Test t1 (10);

    const Test t2 (20);

    t1.fun();

    t2.fun();

    return 0;

}

 

  • Compilation error
  • fun() fun()
  • fun() const fun()
  • fun() fun() const  *

 

   What does the following query find?

 

(SELECT DISTINCT r.sid

FROM boats b, reserves r

WHERE b.bid = r.bid

AND b.color = 'red')

MINUS

 (SELECT DISTINCT r.sid

FROM boats b, reserves r

WHERE b.bid = r.bid

AND b.color = 'green');

 

  • Find the sailor IDs of all sailors who have reserved red boats but not green boats
  • Find the sailor IDs of atleast one sailor who have reserved red boats but not green boats  *
  • Find the sailor IDs of at most one sailor who have reserved red boats but not green boats
  • None of the above

 

 

 Size of IPv6 address is

  • 4 bytes
  • 8 bytes
  • 6 bytes
  • 16 bytes  *

What is the probability of getting a sum 9 from two throws of a dice?

  • 1/6
  • 1/8
  • 1/9  *
  • 1/12

What will be output of following program?

 

#include

int main(){

static int a=25;

void cdecl conv1() ;

void pascal conv2();

conv1(a);

conv2(a);

return 0;

}

void cdecl conv1(int a,int b){

printf("%d %d",a,b);

}

void pascal conv2(int a,int b){

printf("\n%d %d",a,b);

}

 

  • 25 0 0 25
  • 25 25
  • Error will occur   *
  • 25 -99999999 -99999999 25

Which command puts a script to sleep untill a signal is received?

  • sleep
  • suspend   *
  • disown
  • break

 

read less
Comments
Dislike Bookmark

Lesson Posted on 21/12/2016 IT Courses/Oracle Training/Oracle PL/SQL IT Courses/PL/SQL IT Courses/Database Training +1 IT Courses/Oracle Training/Oracle Database less

Common mistake even experienced programmers make in Plsql.

Gavi Yatnalli

It's going to be a multidimensional experience when you attend the classes. Take a chance and enjoy the ride.

Hope, you are aware of Procedures in Plsql. Let us discuss one simple thing which we should always remember while writing the datatype of a parameter for a procedure or a function. Eg: Create or replace procedure proc1 (Name IN Varchar2(10)) AS. What's wrong in this? Any guesses? You should never... read more

Hope, you are aware of Procedures in Plsql. Let us discuss one simple thing which we should always remember while writing the datatype of a parameter for a procedure or a function.

Eg: Create or replace procedure proc1 (Name IN Varchar2(10)) AS.

What's wrong in this? Any guesses?

You should never write Varchar2(10) or Number(2) etc for parameters while creating procedure or function. It's an error.

Just write it like,

Create or replace procedure proc1 (Name IN Varchar2, Sal Number)  AS.

Even for the return type of a function.

Inside the declaration section of procedure or function or anonymous block, you should mention the size as Varchar2(20) or Number(3) or so. Otherwise, default size would be assumed depending on the type.

read less
Comments
Dislike Bookmark

Answered on 20/12/2016 IT Courses/Oracle Training/Oracle PL/SQL

Manoj Kumar Vishwakarma

DBA Trainer

Its depend in your choice. But MS SQL more prefer compare to Oracle.
Answers 15 Comments
Dislike Bookmark

Answered on 06/09/2016 IT Courses/Oracle Training/Oracle PL/SQL

Manoj Kumar Vishwakarma

DBA Trainer

it will great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL effectively. If you re brand new to PL/SQL, then you ll want to take some time to get familiar with the language.
Answers 29 Comments
Dislike Bookmark

Answered on 30/08/2016 IT Courses/Oracle Training/Oracle PL/SQL

Manoj Kumar Vishwakarma

DBA Trainer

Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). First... read more
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). First Normal Form (1NF) Second Normal Form (2NF) Third Normal Form (3NF) Boyce Code Normal Form (BCNF) Fourth Normal Form (4NF) read less
Answers 10 Comments
Dislike Bookmark

Answered on 23/04/2016 IT Courses/PL/SQL IT Courses/Oracle Training/Oracle PL/SQL IT Courses/SQL Programming

What is the cost of SQL - PL/SQL training in an institute?

Surya R.

Oracle Certified Trainer

Offline means they will charge around 4k. . If you required online they will charge from 15k to 20k in hyderabad.
Answers 1 Comments
Dislike Bookmark

Looking for Oracle PL/SQL

Find best Oracle PL/SQL in your locality on UrbanPro.

FIND NOW

Answered on 16/02/2016 IT Courses/Oracle Training/Oracle PL/SQL

Manoj Kumar Vishwakarma

DBA Trainer

It depends in your Interest.
Answers 8 Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best Oracle PL/SQL in India. Post Your Requirement today and get connected.

Overview

Lessons 16

Total Shares  

+ Follow 20,105 Followers

Top Contributors

Connect with Expert Tutors & Institutes for Oracle PL/SQL

x

Ask a Question

Please enter your Question

Please select a Tag

X

Looking for Oracle PL/SQL Classes?

Find best tutors for Oracle PL/SQL Classes by posting a requirement.

  • Post a learning requirement
  • Get customized responses
  • Compare and select the best

Looking for Oracle PL/SQL Classes?

Find best Oracle PL/SQL Classes in your locality on UrbanPro

Post your learning requirement

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more