• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

bind variables

Improve the Performance using Bind Variable in Oracle

October 6, 2019 by techgoeasy Leave a Comment

What is a Bind Variable? -It is a placeholder for a value .It is replaced by actual value when the SQL statement is executed-In PL/SQL it is called a local or global variable. DECLARE l_empl_id DEPT.emp_id%TYPE; BEGIN select first_name  from DEPT  where id = l_empl_id; END; -in SQL*Plus it is a variable variable a number BEGIN […]

Filed Under: Oracle, Oracle Database, Oracle Ebuisness Suite Tagged With: bind variables, What is a Bind Variable

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Oracle tkprof utility
  • What is Skew in Database?
  • how to find file based on size in linux
  • SQL trace, 10046 event in Oracle
  • How to use sed replace string in file

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us