Home
Search results “Set oracle parameters”
Why are Kernel parameters critical for Oracle Database
 
16:53
Learn more about Kernel parameters with a case study. It's awesome to see how SHMMAX parameter effects a process on UNIX. Liked it? Subscribe to our channel now !!! Look at the complete blog at www.orskl.com Need training on Oracle DBA? WhatsApp to +919951696808 Training content is at www.orskl.com
Views: 4365 OrSkl Academy
Oracle Reports | How To Set User Parameters-Bind Parameters | Bangla R-17
 
16:48
Oracle Reports | How To Set User Parameters-Bind Parameters | Bangla R-17 To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will know About Bind Parameters in Oracle Reports. You also learn How To Use Bind Parameters in Oracle Reports. Parameters: A parameter is a variable whose value can be set at runtime. Parameters passed the values. Parameters enable you to develop dynamic report documents that produce report output depending on the parameter value that you enter at run time. Types of Parameter: 1.System parameters 2.User define parameters User define parameters : A user define parameter is a Data Model object that you create to hold a value that users can change at run time. The parameter default data type is CHARACTER. Types of User Define Parameters: 1. Bind Parameter 2. Lexical Parameter Bind Parameter: Bind parameter is used to pass a single value at runtime. It also used to replace a single value or expression in the following clauses: WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, START WITH. It is a mandatory parameter. It is associated with ‘:’ symbol To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 82 OracleDB Solutions
CHANGING THE CHARACTER SET TO AL32UTF8
 
02:55
By using these steps you can change the oracle database character set to AL32UTF8
Views: 27225 venkatesh sankala
Oracle Apps Training Value Sets 1
 
16:12
For more videos and documents check us at www.erpwebtutor.com
Views: 24953 ERPWebTutor
How to set the value of optimizer_adaptive_features parameter in Oracle DB 12c under Oracle EBS?
 
02:15
+ Course Name = Oracle E-Business Suite 12.2.7 Installation on Oracle Linux 7.5 + Course Link = http://aclnz.com/component/guru/guruPrograms/3-oracle-apps-dba/75-ebsonoel75 + Instructor = Kabeer Khan, Ex-Oracle New Zealand + Website = www.aclnz.com Key Words Oracle E-Business Suite Release 12.2.0 Installation Oracle E-Business Suite Release 12.2.7 Installation Oracle E-Business Suite Release 12.2.0 Installation in Cloud Server Oracle E-Business Suite Release 12.2.7 Installation in Cloud Server Oracle E-Business Suite Release 12i Installation Oracle E-Business Suite Installation Oracle E-Business Suite Upgrade from Release 12.2.0 to 12.2.7 Oracle EBS Installation Oracle EBS Release 12.2.0 Installation Oracle EBS Release 12.2.7 Installation Oracle Apps DBA Oracle Apps DBA Training Oracle Applications DBA Oracle EBS Installation in Virtualbox Oracle E-Business Suite Release 12.2.7 Installation in Virtualbox VM Oracle Linux 7.5 Installation Oracle Linux 7.5 Installation in Virtualbox VM Oracle Linux 7.5 Installation for Oracle EBS Oracle Linux 7.5 Installation for Oracle E-Business Suite optimizer_adaptive_features parameter optimizer_adaptive_features Oracle Database 12c init.ora
Views: 18 aclnz
Oracle - Understanding the tnsnames.ora and listener.ora files
 
12:46
Oracle - Understanding the tnsnames.ora and listener.ora files
Views: 178988 Chris Ostrowski
Oracle JDeveloper - Introducing Parameters Using Refactoring
 
05:19
http://jdeveloperzerotopro.com This tutorial explains how to introduce parameters in JDeveloper using refactoring.
Views: 5460 HandsonERP
قواعد البيانات 7 (Oracle Parameter Files (Oracle DBA 11g Tutorial
 
20:19
Oracle DBA 11g Tutorial parameter files (pfile) (init.ora) server parameter file (spfile) Parameter Values difference between spfile and pfile
Views: 274 Ahmed Ybat
How to set initialization parameters through @WebInitParam annotation in Java Servlets?
 
07:01
CLICK TO DOWNLOAD COMPLETE SOURCE CODE - http://www.hubberspot.com *********************************************** Do Watch Video in High Quality ... ***********************************************
Views: 368 Dinesh Varyani
Oracle DBA Justin - How to set sqlplus variables and settings to be persistent
 
09:43
Oracle DBA Justin - How to set sqlplus variables and settings to be persistent
Views: 3665 jbleistein11
Dynamic Power BI reports using Parameters
 
12:21
In this video, Patrick shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. This uses M Functions within Power Query and a second source that has the key values to pull. Then using a gateway to enable refresh. LET'S CONNECT! Guy in a Cube -- https://guyinacube.com -- http://twitter.com/guyinacube -- http://www.facebook.com/guyinacube -- Snapchat - guyinacube -- https://www.instagram.com/guyinacube/ ***Gear*** Check out my Tools page - https://guyinacube.com/tools/
Views: 68393 Guy in a Cube
Oracle Reports | How To Set User Parameters-Lexical Parameters | Bangla R-18
 
21:24
Oracle Reports | How To Set User Parameters-Lexical Parameters | Bangla R-18 To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will learn how to set lexical parameters in oracle reports. To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 51 OracleDB Solutions
How to set bash profile for ORACLE HOME environment
 
02:26
Bash profile for Oracle Home
Views: 4412 oracleora
how to install greek character set in oracle
 
01:17
Oracle character set for viewing end writing other language character. Right Click on my computer }Advance system setting }advance } Environment Variables Click on System variable on New TAB Variable name : NLS_LANG Variable Value : GREEK_GREECE.EL8MSWIN1253 Variable name : NLS_NUMERIC_CHARACTERS Variable Value : .,
Views: 37 R G IT Solutions
How to view parameters in an Oracle Database
 
01:06
Details how to use sqlplus either as "sysdba" or as a database user to query database parameters.
Views: 602 Michael Wilson
Beyond Excel: Parameterized Query
 
03:28
Create a Parameterized Query in Excel without Add-ins, Macros, or Formulas
Views: 64821 Craig Hatmaker
4 POS system parameters set IPCR004S - Semalt
 
00:27
Visit us - https://semalt.com/?ref=y #system, #pos, #parameters, #set, #aep_system, #system_sei, #raag_mishra_tilang_set, #ishqbaaz_set, #messenger_set, #subscribe_set, #investnow_set, #set_rules, #set_gc, #setmenu_set pos system parameters pos system parameters in r12 alter system set parameters iphone 4 pos system shift 4 pos system set system profile parameters sap alter system set underscore parameters alter system set parameters oracle alter system set hidden parameters set parameters parameters set httpclient 4 set query parameters pos system machine pos system parameters system system parameters system-parameters system pos pos system pos-system pdq 4 station pos system oracle alter system set underscore parameters pos material pos system meridian tn parameters pos wiha system 4 set openbravo pos report parameters netware set parameters set-mailboxserver parameters set up parameters cmd set parameters set reportviewer parameters set printer parameters gurobi set parameters httpservletrequest set parameters msdeploy set parameters oracle set parameters set quantization parameters set querydef parameters set sqlcommand parameters set command parameters set sysctl parameters xtrareports set parameters set-calendarprocessing parameters set subreport parameters gdb set parameters reportviewerwebpart set parameters set pppoe parameters sql set parameters dtexec.exe parameters set batch set parameters set-azurestaticvnetip parameters set-clientaccessserver parameters set parameters sqldatasource set asm parameters sqlcommand set parameters sqlplus set parameters set-mailcontact parameters set crystalreportsource parameters ssrs set parameters set deletecommand parameters dtexec.exe parameters /set crystalreportviewer set parameters set parameters oracle sqldatasource set parameters sqlplus parameters set bcdedit /set parameters set cookie parameters set parameters response.sendredirect set-cddrive parameters set time parameters httpurlconnection set parameters kettle set parameters pagereference set parameters reportdocument set parameters set of parameters set-adaccountpassword parameters set pid parameters jsp set parameters reportviewer set parameters set jvm parameters openttd set parameters reportclientdocument set parameters set get parameters set msconfig parameters set parameters sql set rman parameters urlconnection set parameters parameters to set set-contact parameters pandemie set parameters android parameters set set connection parameters set notes.ini parameters dtexec parameters /set dimroth set parameters set-alias parameters set-mailbox parameters set parameters successful powershell parameters set set parameters mssql set the parameters cmake set parameters mdutil parameters set set kernel parameters vim set parameters set-csclientpolicy parameters set-qaduser parameters set mask parameters to set parameters objectdatasource set parameters set parameters reportviewer roslaunch set parameters reportexecutionservice set parameters sqldataadapter set parameters doctrine set parameters set nls parameters set parameters azure set-user parameters getmethod set parameters set objectdatasource parameters set search parameters set-aduser parameters hibernatetemplate set parameters profibus set parameters set-msoluserpassword parameters set-wmiinstance parameters sql parameters set xsltprocessor set parameters rman set parameters set vm parameters set parameters sqlplus set post parameters set runtime parameters dos parameters set set-managementroleentry parameters set-msoluserlicense parameters symfony set parameters picture parameters set postmethod set parameters dos set parameters javascript set parameters stty set parameters set report parameters set serial parameters set aduser parameters 4-pos 4 pos pos-4 pos 4 system 3 pos system set window pos set windows pos bpc system parameters sar system parameters system parameters windows system parameters ax tosnuc system parameters oracle system parameters system-parameters cdr pv system parameters system design parameters ecdsa system parameters system call parameters system parameters wiki set cursor pos system parameters definition etc system parameters alter system parameters system of parameters cdr system parameters system parameters sap set mouse pos unix system parameters lorenz system parameters ar system parameters ap system parameters system reliability parameters sp_send_dbmail system parameters system gain parameters pos icon set pos set up
Views: 1 2987 ng
SSIS "Execute SQL Task" - stored procedure with input parameters, output parameters & return value.
 
15:57
Demonstration of using SSIS Execute SQL Task to call a stored procedure to set SSIS variables from the stored procedure output parameter values and return value. No result set involved. Examples cover both OLEDB and ADO.NET.
Views: 12529 Steden Videos
ORACLE WORLD - How to display and set Sqlplus runtime options
 
10:23
Hello friends in this video we learn about How to display and set Sqlplus run time options in oracle database and its very simple and beneficial.
Views: 773 Oracle World
HOW TO DISPLAY AND SET SQLPLUS RUN TIME OPTIONS IN ORACLE
 
05:03
HOW TO DISPLAY AND SET SQLPLUS RUN TIME OPTIONS =============================================== SHOW ALL show feedback; show heading; show timing; show time; set feedback off; set heading off; set timing off; set time off; set feedback on; set heading on; set timing on; set time on;
Views: 449 Praveen Biyyapu
Oracle PL/SQL Tutorials | Set Commands in SQL*Plus:SQL*Plus Settings | by Mr.Vaman Deshmukh
 
13:25
Oracle PL/SQL Tutorials | Set Commands in SQL*Plus:SQL*Plus Settings | by Mr.Vaman Deshmukh ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ #OraclePLSQLTutorials #SQL*PlusSettingsTutorials #PLSQLTutorials -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/
Send datatable as parameter to stored procedure
 
09:27
how to pass datatable to stored procedure in c#.net pass datatable to stored procedure in sql server 2008 In this video we will discuss how to send datatable as parameter to stored procedure. This is continuation to Part 99. Please watch Part 99 from SQL Server tutorial before proceeding. In Part 99, we discussed creating a stored procedure that accepts a table as a parameter. In this video we will discuss how to pass a datatable from a web application to the SQL Server stored procedure. Here is what we want to do. 1. Design a webform to insert 5 employees at a time into the database table. 2. When "Insert Employees" button is clicked, retrieve the from data into a datatabe and then pass the datatable as a parameter to the stored procedure. 3. The stored procedure will then insert all the rows into the Employees table in the database. WebForm1.aspx.cs code using System; using System.Configuration; using System.Data; using System.Data.SqlClient; namespace Demo { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) {} private DataTable GetEmployeeData() { DataTable dt = new DataTable(); dt.Columns.Add("Id"); dt.Columns.Add("Name"); dt.Columns.Add("Gender"); dt.Rows.Add(txtId1.Text, txtName1.Text, txtGender1.Text); dt.Rows.Add(txtId2.Text, txtName2.Text, txtGender2.Text); dt.Rows.Add(txtId3.Text, txtName3.Text, txtGender3.Text); dt.Rows.Add(txtId4.Text, txtName4.Text, txtGender4.Text); dt.Rows.Add(txtId5.Text, txtName5.Text, txtGender5.Text); return dt; } protected void btnInsert_Click(object sender, EventArgs e) { string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spInsertEmployees", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter paramTVP = new SqlParameter() { ParameterName = "@EmpTableType", Value = GetEmployeeData() }; cmd.Parameters.Add(paramTVP); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } protected void btnFillDummyData_Click(object sender, EventArgs e) { txtId1.Text = "1"; txtId2.Text = "2"; txtId3.Text = "3"; txtId4.Text = "4"; txtId5.Text = "5"; txtName1.Text = "John"; txtName2.Text = "Mike"; txtName3.Text = "Sara"; txtName4.Text = "Pam"; txtName5.Text = "Todd"; txtGender1.Text = "Male"; txtGender2.Text = "Male"; txtGender3.Text = "Female"; txtGender4.Text = "Female"; txtGender5.Text = "Male"; } } Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/send-datatable-as-parameter-to-stored.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/send-datatable-as-parameter-to-stored_18.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 49191 kudvenkat
How to install oracle 12c on Linux
 
20:53
Learn ow to install the latest release for oracle database i.e 12C. watch the step by step installation in the above video. Click the below link for all the commands and steps http://techlair.info/2015/11/08/oracle12cinstall/ Step 1 - Edit Host Files - /etc/hosts 127.0.0.1 localhost.localdomain localhost 192.168.0.210 oracle_12C.localdomain oracle_12C Step 2 - Edit Kernel Parameters /etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 sysctl -p - apply changes Step 3 - Edit Limits file - etc/security/limits.conf oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 Step 4 - Install dependencies yum install binutils -y yum install compat-libcap1 -y yum install compat-libstdc++-33 -y yum install compat-libstdc++-33.i686 -y yum install gcc -y yum install gcc-c++ -y yum install glibc -y yum install glibc.i686 -y yum install glibc-devel -y yum install glibc-devel.i686 -y yum install ksh -y yum install libgcc -y yum install libgcc.i686 -y yum install libstdc++ -y yum install libstdc++.i686 -y yum install libstdc++-devel -y yum install libstdc++-devel.i686 -y yum install libaio -y yum install libaio.i686 -y yum install libaio-devel -y yum install libaio-devel.i686 -y yum install libXext -y yum install libXext.i686 -y yum install libXtst -y yum install libXtst.i686 -y yum install libX11 -y yum install libX11.i686 -y yum install libXau -y yum install libXau.i686 -y yum install libxcb -y yum install libxcb.i686 -y yum install libXi -y yum install libXi.i686 -y yum install make -y yum install sysstat -y yum install unixODBC -y yum install unixODBC-devel -y Step 5 - Add Groups and Users groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper useradd -u 54321 -g oinstall -G dba,oper oracle passwd oracle Step 6 - /etc/security/limits.d/90-nproc.conf # Change this * soft nproc 1024 # To this * - nproc 16384 Step 7 - Set SELINUX SELINUX=permissive run the command after edit setenforce Permissive Step 8 - Stop Firewall # service iptables stop # chkconfig iptables off Step 9 - Create directories for oracle Installation mkdir -p /oracle/product/12.1.0/db_1 chown -R oracle:oinstall /oracle chmod -R 775 /oracle Step 10 - xhost + Step 11 - Edit bash profile for oracle user /home/oracle/.bash_profile # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=oracle_12C.localdomain export ORACLE_UNQNAME=db1 export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1 export ORACLE_SID=db1 export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib Step - 12 Extract Installation Files unzip linuxamd64_12c_database_1of2.zip unzip linuxamd64_12c_database_2of2.zip Step - 13 Start the Oracle Universal Installer ./runInstaller Post Installation dit the "/etc/oratab" file setting the restart flag for each instance to 'Y' cdb1:/u01/app/oracle/product/12.1.0/db_1:Y Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 124933 TechLair
SSRS Set Default Date in Report Parameter
 
02:46
SQL Server Reporting Services How to set the Default Parameters in a Report for DateTime
Views: 552 CKWTech LLC
PL/SQL tutorial 6: Bind Variable in PL/SQL By Manish Sharma RebellionRider.com
 
07:56
Watch and learn what are bind variables in PL/SQL how to declare or create them using Variable command, Initialize them using Execute (exec)command and different ways of displaying current values of a bind variable for example using AutoPrint parameter. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/bind-variable Previous Tutorial ► Constants in PL/SQL https://youtu.be/r1ypg7WH4GY ►User Variables :https://youtu.be/2MNmodawvnE ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 81848 Manish Sharma
Create Dynamic Query Parameters in Power BI Desktop  - Power BI Tips & Tricks #47
 
09:11
Create Dynamic Query Parameters, filter your reports with them and create a template using Power BI. Links mentioned in the video: Chris Webb blog: https://blog.crossjoin.co.uk/2016/08/30/data-driven-power-bi-desktop-parameters-using-list-queries/ Rio Summer Olympics Report: https://www.youtube.com/watch?v=tZXY9RZwd3U Download the sample report: https://gofile.me/2kEOD/PaRdrp3aG Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: https://curbal.com/product/sponsor-me Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB #POWERBITIPS #CURBAL #POWERBI #MVP ► Linkedin: https://goo.gl/3VW6Ky
Views: 33809 Curbal
Oracle BI Publisher Data Model Editor
 
09:09
Oracle BI Publisher Data Model Editor Overview Demo
Views: 41897 bipublisher
Oracle DBA Justin - How to set an Oracle database to readonly # 1 of 2
 
17:13
How to set an Oracle database to readonly
Views: 3367 jbleistein11
SQL Server Programming Part 2 - Stored Procedure Parameters
 
20:48
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - Stored Procedures are extremely useful tools in SQL Server, and they become even more powerful when you use parameters to pass information to them. This video teaches you how to define a list of parameters for a stored procedure and how to call a parameterised procedure and pass information to it. You'll also learn how to create optional parameters with default values, how to handle NULLs passed to a procedure and, finally, how to use your procedure in other applications such as Reporting Services. You can read a written version of this tutorial here: https://www.wiseowl.co.uk/blog/s263/parameters.htm You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 156966 WiseOwlTutorials
Dynamic sql table name variable
 
11:59
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable_20.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss how to pass table name dynamically for stored procedure in sql server. This is one of the sql questions that is very commonly asked. I have a web page with a textbox. When I enter a table name in the textbox and when I click "Load Data" button, we want to retrieve data from that respective table and display it on the page. Copy the SQL Script to create the tables from my blog using the link below http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Create the following stored procedure. Notice we are passing table name as a parameter to the stored prcoedure. In the body of the stored procedure we are concatenating strings to build our dynamic sql statement. In our previous videos we discussed that this open doors for SQL injection. Create procedure spDynamicTableName @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from ' + @TableName Execute sp_executesql @sql End So the obvious question that comes to our mind is, why are we not creating parameterised sql statement instead. The answers is we can't. SQL Server does not allow table names and column names to be passed as parameters. Notice in the example below, we are creating a parameterised query with @TabName as a parameter. When we execute the following code, the procedure gets created successfully. Create procedure spDynamicTableName1 @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from @TabName' Execute sp_executesql @sql, N'@TabName nvarchar(100)', @TabName = @TableName End But when we try to execute it we get an error - Must declare the table variable "@TabName" Execute spDynamicTableName1 N'Countries' Add a Web Page to the project that we have been working with in our previous video. Name it "DynamicTableName.aspx". Copy and paste the HTML from my blog using the link below http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Copy and paste the code from my blog in the code-behind page http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html At this point, run the application and type the following text in the "Table Name" textbox and click "Load Data" button. Notice "SalesDB" database is dropped. Our application is prone to SQL injection as we have implemented dynamic sql in our stored procedure by concatenating strings instead of using parameters. Employees; Drop database SalesDB One way to prevent SQL injection in this case is by using SQL Server built-in function - QUOTENAME(). We will discuss QUOTENAME() function in detail in our next video. For now understand that by default, this function wraps that string that is passed to it in a pair of brackets. SELECT QUOTENAME('Employees') returns [Employees] Modify the stored procedure to use QUOTENAME() function as shown below. Alter procedure spDynamicTableName @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from ' + QUOTENAME(@TableName) Execute sp_executesql @sql End At this point, type the following text in the "Table Name" textbox and click "Load Data" button. Notice you will see a message - Invalid object name 'Employees; Drop database SalesDB'. Also "SalesDB" database is not dropped. Employees; Drop database SalesDB The entire text in "Table Name" textbox is wrapped in a pair of brackets by the QUOTENAME function and is treated as table name. Since we do have a table with the specified name, we get the error - Invalid object name.
Views: 19526 kudvenkat
HOW TO EDIT VALUE SET ORACLE E-BUSINESS SUITE
 
04:21
HOW TO EDIT VALUE SET ORACLE E-BUSINESS SUITE
Views: 1122 Mohamed Mostafa
Oracle Database11g tutorials 13 || SQL substr function / SQL substring function
 
06:34
link of SQL substr blog : http://www.rebellionrider.com/SQL-substr-function.htm SQL substr function SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ---------------------------------------------------------------------------- As the name suggests SQL Substr function will return substring from a given source string. Let's see the Syntax Substr (source_string, start_pos, Substr_length) As we can see SQL substr function takes 3 parameters. First one is Source string from which you want to extract the segment. Second parameter is Starting position for sub string from the Source string. And the third parameter is Substr_length which is the length for the substring. First two parameters are mandatory to specify while third one is optional. So we can say. SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. First parameter source string can be of any data type CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB whereas both start_pos, Substr_length parameters must be number data type. The returning result of SQL Substr function is of same data type of source string. Let's see an example of SQL Substr function. SELECT substr('www.RebellionRider.com',5,14) FROM dual; Here in this query url of my website www.RebellionRider.com is our source string with the total length of 22 characters, Now, I want to extract the name of my website that is, RebellionRider. So if you count the total length of the name of the website, it is 14. That's why I have specified 14 as my third parameter of SQL Substr function which is substr_length. Also the name of the website RebellionRider is starting from 5th position therefore I have specified 5 at second parameter of SQL substr function which is strt_pos or starting position. Execute it. Here is our result RebellionRider When starting position is larger than the length of source string. In this case SQL Substr function will return NULL as a result. Let's do an example. SELECT substr('www.RebellionRider.com',23,14) FROM dual; As you can see here I have specified 23 at starting position and the total length of our source string is 22 characters Let's execute And the result is Null. Second scenario When the Substr_length is greater than source string In this case the segment return is the substring from starting position to the end of the string. For example SELECT substr('www.RebellionRider.com',5,23) FROM dual; Our starting position is at 5 means at the first R of RebellionRider and length of substring is set to 23 which is greater than the length of source string that is 22. Execute. As you can see we get a substring from first R of RebellionRider till the end of the source String. Third scenario When you supply numeric or arithmetic expression or a DATE instead of character as Source string to SQL Substr function In this scenario If you have supplied a numeric string instead of character as source string, the oracle engine casts them as a character when they occur as parameter to SQL Substr function. And if you have supplied Arithmetic expression or a DATE then The Oracle engine first solves or evaluates the Arithmetic expression or the DATE Then casts them as a character. Means if you have arithmetic expression in your source string then oracle will first solve it and then change or say cast the value of its result into character. Let's see some example. SELECT substr(50000-7,2,4) FROM dual; Oracle first evaluates the arithmetic expression that is 50000-7 equals to 49993. And then oracle engine casts this result 49993 into a character string. Means 49993 will be a 5 characters string. Starting position of substring is 2, that means from the first 9 of 49993 We specified the length of substring is 4 so we must get 9993 as our result. Let's check execute
Views: 76770 Manish Sharma
Should I set CPU_COUNT?
 
02:44
blog: https://connor-mcdonald.com Should I be setting the CPU_COUNT parameter for my database? A summary from the recent AskTOM Office Hours session. Subscribe for regular videos on Oracle technology! CPU, Cores, Sockets: https://www.youtube.com/watch?v=5nRheRXTMEc whitepaper: http://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf music: kevin mcleod (incomptech.com)
Views: 300 Connor McDonald
Oracle EMPTY_BLOB Function
 
01:58
https://www.databasestar.com/oracle-lob-functions/ The Oracle EMPTY_BLOB function is used to initialise a LOB column to an empty value. You can use it in an INSERT statement, an UPDATE statement, or with a variable in PL/SQL. The syntax of the EMPTY_BLOB function is: EMPTY_BLOB That’s it - no parameters. Why would you set a BLOB value to empty? It means you have initialised it but not given it a value. It’s good to know this function exists if you ever need to use it. For more information about the Oracle EMPTY_BLOB function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-lob-functions/
Views: 51 Database Star
Oracle Jdeveloper12c ADF  - 1) how to set and get Value
 
06:42
How to set and get Value using button Click Visit my Blog for more tutorials ... http://parasshahjdeveloper12c.blogspot.in/
Views: 2401 Paras Shah
Crystal Reports Tip: Creating Dynamic Parameters
 
13:51
How to create a dynamic parameter and examine the attributes of a parameter
Views: 118734 SymphonyCorp
Flexfield Value Set Security in Oracle R12 - Part-2
 
10:03
New feature Oracle eBusiness Suite R12.2 - Flexfield Value Set Security - Part-2 (Role Access to Selective Value Sets)
Views: 4797 Suhas Vaze
Stored procedure output parameters or return values   Part 20
 
16:45
In this video we will 1. Understand what are stored procedure return values 2. Difference between stored procedure return values and output parameters 3. When to use output parameters over return values Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedure-output-parameters-or.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-20-stored-procedure-output.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 261543 kudvenkat
How to Set ORACLE_HOME & ORACLE_SID on Windows Server
 
07:19
How to Set ORACLE_HOME & ORACLE_SID on Windows Server ==================================================== C: Set ORACLE_HOME=C:\Oracle\product\11.2.0 Set ORACLE_HOME=DBNAME Set PATH=C:\Oracle\product\11.2.0\bin ================================================= Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 4134 ANKUSH THAVALI
Using the Set Operators in Oracle SQL
 
07:27
The usage of the following operators in Oracle SQL are presented in this video: - MINUS operator - INTERSECT operator - UNION operator
Views: 83 MrFphunter
Oracle E business Suite Value Set with table validation
 
08:13
Oracle E business Suite Value Set with table validation
Views: 50 Mahmoud Yasin
How to Oracle 11gR2 Installation On RHEL-5
 
04:47
ORACLE INSTALLATION FOR RHEL 5:- Set KERNAL PARAMETER:- vi /etc/sysctl.conf kernel.shmmni = 4096 semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default=4194304 net.core.wmem_default=262144 net.core.rmem_max = 16777216 net.core.wmem_max = 16777216 net.ipv4.ipfrag_high_thresh=524288 net.ipv4.ipfrag_low_thresh=393216 net.ipv4.tcp_rmem=4096 524288 16777216 net.ipv4.tcp_wmem=4096 524288 16777216 net.ipv4.tcp_timestamps=0 net.ipv4.tcp_sack=0 net.ipv4.tcp_window_scaling=1 net.core.optmem_max=524287 net.core.netdev_max_backlog=2500 sunrpc.tcp_slot_table_entries=128 sunrpc.udp_slot_table_entries=128 net.ipv4.tcp_mem=16384 16384 16384 fs.aio-max-nr =1048576 fs.file-max=6815744 fs.suid_dumpable =1 kernel.shmmax =536870912 Refreshing Kernal Parameter:- /sbin/sysctl -p SECURITY LIMITS SETTING:- vi /etc/security/limits.conf * soft nproc 2047 * hard nproc 16384 * soft nofile 4096 * hard nofile 65536 * soft stack 10240 PACKAGE INSTALLATION:- rpm -Uvih binutils-2*`uname -p`* rpm -Uvih compat-libstdc++-33*`uname -p`* rpm -Uvih compat-libstdc++-33*i386* rpm -Uvih elfutils-libelf-0*`uname -p`* rpm -Uvih elfutils-libelf-devel-0*`uname -p`* rpm -Uvih gcc-4*`uname -p`* rpm -Uvih gcc-c++-4*`uname -p`* rpm -Uvih glibc-2*`uname -p`* rpm -Uvih glibc-2*i686* rpm -Uvih glibc-common-2*`uname -p`* rpm -Uvih glibc-devel-2*`uname -p`* rpm -Uvih glibc-devel-2*i386* rpm -Uvih glibc-headers-2*`uname -p`* rpm -Uvih ksh-20*`uname -p`* rpm -Uvih libaio-0*`uname -p`* rpm -Uvih libaio-0*i386* rpm -Uvih libaio-devel-0*`uname -p`* rpm -Uvih libaio-devel-0*i386* rpm -Uvih libgcc-4*`uname -p`* rpm -Uvih libgcc-4*i386* rpm -Uvih libstdc++-4*`uname -p`* rpm -Uvih libstdc++-4*i386* rpm -Uvih libstdc++-devel-4*`uname -p`* rpm -Uvih make-3*`uname -p`* rpm -Uvih numactl-devel-0*`uname -p`* rpm -Uvih sysstat-7*`uname -p`* rpm -Uvih unixODBC-2*`uname -p`* rpm -Uvih unixODBC-2*i386* rpm -Uvih unixODBC-devel-2*`uname -p`* rpm -Uvih unixODBC-devel-2*i386* rpm -Uvh binutils-2.* rpm -Uvh elfutils-libelf-0.* rpm -Uvh glibc-2.* rpm -Uvh glibc-common-2.* rpm -Uvh libaio-0.* rpm -Uvh libgcc-4.* rpm -Uvh libstdc++-4.* rpm -Uvh make-3.* rpm -Uvh compat-libstdc++-33* rpm -Uvh elfutils-libelf-devel-* rpm -Uvh glibc-headers* rpm -Uvh glibc-devel-2.* rpm -Uvh libgomp* rpm -Uvh gcc-4.* rpm -Uvh gcc-c++-4.* rpm -Uvh libaio-devel-0.* rpm -Uvh libstdc++-devel-4.* rpm -Uvh unixODBC-2.* rpm -Uvh unixODBC-devel-2.* rpm -Uvh sysstat-7.* Users Set up:- groupadd oinstall groupadd dba groupadd oper groupadd asmadmin useradd -g oinstall -G dba,oper,asmadmin oracle passwd oracle Directories Set Up:- mkdir -p /u01/app/oracle/product/11.2.0.4/db_1/-------------oracle home mkdir -p /u01/app/oracle---------------------------------------------oracle base mkdir -p /u01/app/oraInventory---------------global inventory chown -R oracle:oinstall /u01 chmod -R 775 /u01 For Copying Oracle DB software In Oracle User:- mkdir /u01/software cp -r /run/media/root /* /u01/software/ [[email protected] software]$ ./runInstaller
Views: 194 ALOK SRIVASTAVA
Oracle DBA Justin - How to set the current session's schema.
 
15:38
How to set the current session's schema
Views: 2593 jbleistein11
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 227962 The Bad Tutorials
Oracle COVAR_SAMP Function
 
02:05
https://www.databasestar.com/oracle-variance-functions/ The Oracle COVAR_SAMP function calculates the covariance of a set of number pairs. If you know what a covariance is, then this function would be useful to you. I haven’t used it a lot though. This function is similar to the COVAR_POP and CORR functions, and it can also be used as an aggregate or analytic function. The syntax of the COVAR_SAMP function is: COVAR_SAMP ( expression1, expression2 ) If using it as an aggregate function, the parameters of the COVAR_SAMP function are: - expression1 (mandatory): The first set of numbers to use in the calculation. - expression2 (mandatory): The second set of numbers to use in the calculation. These parameters are numeric data types, and the return value is the same as the parameters. If you use COVAR_SAMP as an analytic function, the syntax is: COVAR_SAMP (expression1, expression2) OVER (analytic_clause) The analytic_clause is added here, which is common for analytic queries. For more information about the Oracle COVAR_SAMP function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-variance-functions/
Views: 13 Database Star
REQUEST SET in Oracle Apps (No Audio)
 
04:33
REQUEST SET in Oracle Apps
Views: 2240 kranti kumar