Home
Search results “Oracle alter scope both”
How to change Archive Destination in Oracle
 
05:40
How to change Archive Destination in Oracle ======================================== Syantax ============= alter system set log_archive_dest_1='LOCATION=/home/Archive/' scope=both; =============================================== 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: 1138 ANKUSH THAVALI
HOW TO INCREASE DECREASE MEMORY TARGET IN ORACLE 11G
 
04:55
How to increase/decrease memory_target in 11g ====================================================== oracle 10g --sga_target (parameter new in 10g) oracle 11g --memory_target (parameter new in 11g) How to check whether the parameter is static or dynamic? ========================================================= select name, value, issys_modifiable from v$parameter where name like '%&parameter%' ; if issys_modifiable=false --- parameter is static (database bounce required) if issys_modifiable=immediate --- parameter is dynamic (database bounce not required) (note: consider using spfile) sql commands ================ show parameter memory; alter system set memory_target=350m scope=spfile; alter system set memory_max_target=350m scope=spfile;
Views: 5257 Praveen Biyyapu
Upgrade Memory Oracle Database 11g Release 2
 
38:51
Script Upgrade: - ALTER SYSTEM SET MEMORY_MAX_TARGET=8192M SCOPE=SPFILE; - ALTER SYSTEM SET MEMORY_TARGET=7168M SCOPE=BOTH; Edit fstab (Partition Share Memory) at /etc/fstab: none /dev/shm tmpfs defaults,size=8G 0 0 Attention: ======== We are not responsible if your system is damaged or error. This is just a reference that can help you solve the same case. If there is any error, apologize profusely. Website: https://www.lukmanlab.com Facebook: https://www.facebook.com/lukmanlab.fans/ Channel: http://www.youtube.com/channel/UC9EP-uQ7gIDE9eR4Wzg2rIQ Help Please Like, Comment & Subscribe...
Views: 112 Ahmad Lukman Hakim
Habilitar archivelog Oracle
 
07:48
Comandos utilizados: mkdir -p /u01/app/oracle/oradata/CDB1/archivelog select log_mode from v$database; ALTER SYSTEM SET log_archive_format = '%d_%t_%s_%r.arc' SCOPE=SPFILE; %d = ID do BD %s = Número sequencial do log %t = Número da thread %r = ID de resetlogs. Assegura que nomes únicos sejam criados junto à múltiplas encarnações do BD. shutdown immediate; startup mount; alter database archivelog; alter database open; ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/u01/app/oracle/oradata/CDB1/archivelog' SCOPE=BOTH; select log_mode from v$database;
Views: 101 Vídeos Aulas TI
username password NOT Case sensitive in oracle | Ten Minute Code
 
04:28
Below Code SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE scope=both; ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = TRUE scope=both; SELECT username, password_versions FROM dba_users;
Views: 463 Together Oracle
10 Oracle XE Installation in Windows 10
 
09:40
Run SQl Command Line connect sys/[email protected] as sysdba show parameter session show parameter processes alter system reset sessions scope=spfile sid='*'; alter system set processes=400 scope=spfile; Restart the database or windows PC Enter “shutdown immediate” Restart your Windows PC To start the database Click on Start All Programs Oracle Database 11g Express Edition Start Database Right click Run as administrator Run SQl Command Line show parameter session show parameter processes There are two ways. One option is to simply open a command prompt and type tnsping xe It should show that its able to ping the db. Other way is to go to Start All Programs Oracle Database 11g Express Edition Get Started If the following page opens up, that means the database is up 127.0.0.1:8080/apex/ WORKSPACE = INTERNAL USER = ADMIN PASSWORD : manager
Views: 945 Middleware_Tech
Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51)
 
33:08
By watching this video you can easily upgrade EBS 12.2 to 12.2.5. EBS Apps 12.2 upgrade to 12.2.5 with start CD 51 First download code checker 17537119, unzip it on both DB and Apps Step 1A:Apply Consolidated Seed Table Upgrade Patch on run file system Patch 17204589 Follow: sh $ADMIN_SCRIPTS_HOME/adstpall.sh sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes sh $ADMIN_SCRIPTS_HOME/adstrtal.sh step 2D:Check which patches need to apply on DB by using code checker First download code checker 17537119, unzip it on both DB and Apps ./checkDBpatch.sh opatch prereq CheckConflictAgainstOHWithDetail -ph ./ export PATH=$PATH:$ORACLE_HOME/OPatch opatch apply Note: Before apply these patches the Database should be down. 19908836 22540024 22098146 21286665 21321429 21387964 21841318 21864513 21904072 21967332 22496904 Step 3D: Recheck if any patchecs are need to apply on DB by using ETCC. start the database. Step 4A: Run ETCC code checker to know which patches are need to apply in Apss. ./checkMTpatch.sh it suggested below patches: 10.1.2 Patches ================ 22698265 FMW webtier =========== 22288381 FMW oracle_common ================= 9905685 21366277 21628307 WLS === 20780171 22323006 Step 5A: Applied above patches on Apps (Shut down all apps services). Apply 10.1.2 Patches: which opatch /u01/oracle/ebsdb/fs1/EBSapps/10.1.2/OPatch/opatch opatch apply Apply FMW webtier Patches: export ORACLE_HOME=/u01/oracle/ebsdb/fs1/FMW_Home/webtier $ORACLE_HOME/OPatch/opatch apply Apply FMW oracle_common Patches: export ORACLE_HOME=/u01/oracle/ebsdb/fs1/FMW_Home/oracle_common $ORACLE_HOME/OPatch/opatch apply Apply WLS Patches: To Apply Weblogic patches first copy and unzip all patches to /u01/oracle/ebsdb/fs1/FMW_Home/utils/bsu/cache_dir location. p13729611_1036012_Generic.zip p19687084_1036012_Generic.zip p22128205_1036012_Generic.zip p17319481_1036012_Generic.zip p20780171_1036_Generic.zip p22323006_1036_Generic.zip cd $FMW_HOME/utils/bsu ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=EJUW -prod_dir=$FMW_HOME/wlserver_10.3 To Remove conflicts: ./bsu.sh -remove -patchlist=Y5AP -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=BLTG -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=1LRI -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=VKXF -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=2GYW -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=CW9T -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=FCX7 -prod_dir=$FMW_HOME/wlserver_10.3 To Apply Patches: ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=EJUW -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=GK5N -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=N5FK -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=8FBW -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=L34G -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=DI8E -prod_dir=$FMW_HOME/wlserver_10.3 Step 6A: Recheck if any patchecs are need to apply on APPS by using ETCC Step 7A: Bring up and brought down the Application services. Step 8A: Start Admin server and Apply below pathes. Patch 20745242:R12.AD.C.Delta.7 Patch 22123818:R12.AD.C Patch 20784380:R12.TXK.C.Delta.7 Patch 22363475:R12.TXK.C Patch 22495069:R12.TXK.C sh adadminsrvctl.sh start sqlplus "/as sysdba" @adgrants.sql APPS adop phase=apply patches=20745242 hotpatch=yes sqlplus "/as sysdba" @adgrants.sql APPS adop phase=apply patches=22123818 hotpatch=yes adop phase=apply patches=20784380,22363475,22495069 hotpatch=yes merge=yes Step 9D: alter system set optimizer_adaptive_features=false scope=both; Step 10A:Bring down the instance and apply the below patch adop phase=apply apply_mode=downtime patches=19676458 Step 11D: alter system set optimizer_adaptive_features=true scope=both; Step 12A: Start the all apps services by using adstrtal.sh script. Step 13A: adop phase=cleanup Step 14A: adop phase=fs_clone Step 15D: Set the local listener parameter in parameter file. alter system set local_listener='ebsdb' scope=both; Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8 Table Shrinking in Oracle Database : https://www.youtube.com/watch?v=bdockmBDvz8 Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A
Views: 6985 BhagyaRaj Katta
Oracle Upgrade, oracle 10g and oralce 11g to oracle 12c
 
08:28
SAP On Oracle Database Upgrade, From Oracle 10g to 12c Direct upgrade, ================================================= TAKE BACKUP OF EXISITNG DB brbackup -u / -p initGWP-disk-OFF.sap -d disk -t offline -m all -o time INSTALL ORACLE 12 DATA BASE - CHANGE THE HOME DIRECTORY PATH IN ENVIRONEMNT - Not to ADD FULL PERMISSION IN TO ORALCE INSTALLATION USER - TAKE A COPY OF OLD ORACLE & AND NEW ORACLE HOME BEFORE APPLYING PATCHES - TAKE COPY OF NETWORK\ADMIN AND DATABASE FOLDER - DOWNLOADED LATEST OPATCH AND REPLACE OPATCH FOLDER - APPYL NEEDED PATCHES USING OPATCHS - STOP ALL SERVICES ORACLE RELATED FOR APPLYINT PATCHES **PATCHBUNDLE12102P_1702-20012303.zip **PATCHBUNDLE12102P_1704-20012303.zip **P9584028GEN12102P_2-20012303.zip 'EG: B:\Patches\P9584028GEN12102P_2-20012303\9584028 C:\oracle\GWP\12102\OPatch\OPATCH APPLY' 'EG: B:\Patches\PATCHBUNDLE12102P_1702-20012303\25433286 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY' "EG: B:\Patches\PATCHBUNDLE12102P_1704-20012303\25632533 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY" -START SERVICES AFTER APPLYING PATCHES FOR UPGRADE. RUN THE PRE UPGRADE SCRIPT AS FOLLOWS.. PRE UPGRADE SCRIPT WILL PROVIDE YOU WHEN YOU UPDATE PATCHES ================================ OS sqlplus / as sysdba SQL @pre_upgrade_tasks.sql SQL @pre_upgrade_checks_ora.sql SQL @pre_upgrade_checks_sap.sql THEN CREATE RESTORE POINT FOR RECOVERY IF ANY FAILIUR HAPPEND */ ============================================================= /*(ALTER SYSTEM SET db_recovery_file_dest_size='10G G:\oracle\GWP\oraflash' scope=both; ALTER SYSTEM SET db_recovery_file_dest= 'E:\oracle\GWQ\oraflash scope=both';)*/ ------------------------------------------- SQL @grp_create_restore_point.sql SQL @grp_list_restore_point.sql ===TAKE BACKUP OF NETWORK/ADMIN & ORAHOME\DATABASE RUN DUBA from new home (oralce 12c) KEEP DATABSE OPEN FOR UPGRADE. ===================== CREATE RMAN BACKUP DURING THE UPGRADE \Post upgrade steps 1915315 - Database Upgrade Scripts for 12.1.0.2 ====================================================================== After DUB create Listner or check the listner status LSNRCTL/ Go to directory 'post_upgrade' to run the post-upgrade scripts. --SQL @?/rdbms/admin/utlu121s.sql --SQL @?/rdbms/admin/utluiobj.sql --SQL @post_upgrade_tasks.sql Recompile invalid objects --SQL @?/rdbms/admin/utlrp.sql Run post-upgrade checks --SQL @post_upgrade_checks.sql Check whether guaranteed restore point 'GRP_BEFORE_UPGRADE_12102' exists: OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade OS sqlplus / as sysdba --SQL @grp_list_restore_point.sql you need to drop this restore point and set 'COMPATIBLE' to the new value. OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade OS sqlplus / as sysdba --SQL @grp_drop_restore_point.sql OS cd NEW_ORACLE_HOME /sap/ora_upgrade/post_upgrade OS sqlplus / as sysdba --SQL @set_compatible.sql After setting compatible to a new value, 'RESTART THE DATABASE.' Ensure that parameter 'compatible' is set to '12.1.0.2.0' or '12.1.0.2': --SQL SHOW PARAMETER COMPATIBLE SQL show parameter compatible NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ compatible string 12.1.0.2.0 noncdb_compatible boolean FALSE --SQL SELECT VALUE "COMPATIBLE" FROM V$PARAMETER WHERE NAME = 'COMPATIBLE'; Before you start the remaining database post-upgrade tasks you can create a new guaranteed restore point ====================================================== --SQL CREATE RESTORE POINT "'GRP_AFTER_UPGRADE_12102'" GUARANTEE FLASHBACK DATABASE ; --SQL SELECT NAME FROM V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES'; drop V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES'; Check for invalid objects: =========================== --SQL select owner, object_name, object_type from dba_objects where status = 'INVALID'; If the object 'DBMS_METADATA' (package body) is still invalid (Ref: patch 17871192), run utlrp to recompile the package. ====================================================== --SQL @?\rdbms\admin\utlrp.sql --SQL select owner, object_name, object_type from dba_objects where status = 'INVALID'; COPY data from OLDorahome\database\ to new database\ FOLLOWING FILES INIT SID .SAP INIT SID .UTL update the kernel CHEK THE TNS FILE NAME IN NETWORK\ADMIN brconnect -u / -c -f stats -t system_stats brconnect -u / -c -f stats -t oradict_stats brconnect -u / -c -f stats -t all -f collect -p 4 deinstall the 11g /*if needed */{}{}{}{}{}{}{}{}{}{}{}{}{}{}{} ================= sqlplus / as sysdba @sapuprof_profile Insufficent privillege 134592 - Import of SAPDBA role (sapdba_role.sql) ========================== sqlplus /nolog @sapdba_role SAPSR3 --CHANGE PARAMTER ONCE UPGRADE COMPLETE. Visit My Blog:http://wrongcodes.blogspot.com/
Views: 255 SNOOPPY TV
Creating Auxiliary, Clone, Sandbox, Duplicate Database Using RMAN
 
17:32
Duplicating Target Database Using RMAN Auxiliary Database or Creating Auxiliary Database on the Same Server Using RMAN. We have Target Database name as ORCL And we are creating a Auxiliary database with name as AUXDB 1.Check log_mode of Target Database. Target must be in archivelog mode. Other put the database in archivelog mode. shutdown immediate startup mount alter database archivelog; alter database open; 2.Take Whole Hot/Cold Backup of Target Database RMAN backup database plus archivelog; 3.Create Pfile from Target Database Spfile SQL create pfile='C:\ORACLE\PRODUCT\10.2.0\DB_1\Database\initauxdb.ora' from spfile; 4.Open pfile with notepad and replace Ctrl + H all orcl to auxdb SQL host notepad C:\ORACLE\PRODUCT\10.2.0\DB_1\Database\initauxdb.ora 5.On Windows Platform You need to Create a new Instance for auxdb which also creates an password file for the same. SQL host oradim -new -sid auxdb -syspwd admin 6.Create All the folders in Oracle Folder Structures. SQL host mkdir C:\oracle\product\10.2.0\oradata\auxdb SQL host mkdir C:\oracle\product\10.2.0\flash_recovery_area\AUXDB SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\adump SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\bdump SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\cdump SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\dpdump SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\pfile SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\udump 7.Connect to auxdb and startup instance at nomount stage. C:\set ORACLE_SID=auxdb C:\sqlplus / as sysdba SQL startup nomount //Instance started with pfile SQL create spfile from pfile; SQL shut immediate SQL startup nomount //Instance started with spfile now 8.Now set these two parameters to convert your datafiles and logfile names. SQL show parameter convert SQL alter system set db_file_name_convert = 'orcl','auxdb' scope=spfile; SQL alter system set log_file_name_convert = 'orcl','auxdb' scope=spfile; SQL shut immediate SQL startup nomount 9.Now you need to connect Recovery Manager to start the duplicating (cloning) process. C:\set ORACLE_SID=auxdb C:\rman auxiliary / RMAN connect target sys/[email protected] RMAN run allocate auxiliary channel ch1 device type disk; allocate channel ch2 device type disk; duplicate target database to auxdb; 10.If all steps are done correctly you will have a new database clone created successfully.
Views: 2647 Saurabh Joshi
ADF How to Implement Login and set session scope from Model Layer
 
39:39
In this demo , I created a method that accepts username and password from the user and return a Row of user contains all data about this user. the set the session scope "GLOBALS" with values retrived from the row
Views: 2007 Tarek Bakr
Flash App 002: Changing Backing Bean Scope Jdeveloper
 
05:10
When we first created the dynamic region (see video 025), it automatically set the backing bean as a request scope. Changing scope requires changing all expression language references to it.
Views: 1388 Stuart Fleming
21. Design - Task Flow Data Control Scope
 
14:27
The author's recommendation: the ADF Architecture TV channel is a training course to extend customers' knowledge in ADF, it is not a marketing or promotional exercise from Oracle Corporation. If you've arrived on this episode by Googling in, please make sure to look at all of the content on the TV channel rather than taking this episode as a standalone topic. This episode: How do bounded task flows share and keep state separate? In this episode of ADF Architecture TV Chris Muir considers the bounded task flow data control scope option and how it is an important option to consider during the design of your ADF applications. Like to know more? Check out: Watch the previous episode: - Design - Transactions and Data Controls - http://youtu.be/mvH-VWEQQks Watch the next episode: - Design - Task Flow Transaction Options - http://youtu.be/KUbx8Dunp-w Subscribe to the channel: - http://bit.ly/adftvsub See the episode index: - ADF Architecture Square - http://bit.ly/adfarchsquare
Views: 2990 ADF Architecture TV
030 ADF Memory Scopes
 
11:04
ADF Memory scopes are used to store variables in memory. They have certain life-spans based on the type of page and taskflow you are using. In this video, I show the behavior of some of the most common memory scopes.
Views: 1065 Stuart Fleming
How configure oracle 11g In Archivelog Mode & No archvielog Mode On Redhat
 
16:45
The following are the steps required to enable archive log mode on an Oracle 10g or 11g database. Verify the database log mode. [email protected] sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 8 12:02:52 2010 Copyright 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 25 Current log sequence 27 SQL The log mode is No Archive Mode. Note that Archive destination is USE_DB_RECOVERY_FILE_DEST. You can determine the path by looking at the parameter RECOVERY_FILE_DEST. SQL show parameter recovery_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/flash_recovery _area db_recovery_file_dest_size big integer 3852M SQL By default, archive logs will be written to the flash recovery area. If you do not want to write archive logs to the flash recovery area you can set the parameter LOG_ARCHIVE_DEST_n to the location in which you wish to write archive logs. SQL alter system set log_archive_dest_1='LOCATION=/u02/app/oracle/oradata/orcl/arch' scope = both; System altered. SQL archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 25 Current log sequence 27 SQL Now we shutdown the database and bring it backup in mount mode. SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount ORACLE instance started. Total System Global Area 849530880 bytes Fixed Size 1339824 bytes Variable Size 511708752 bytes Database Buffers 331350016 bytes Redo Buffers 5132288 bytes Database mounted. SQL Lastly all that is needed it set archive log mode and open the database. SQL alter database archivelog; Database altered. SQL alter database open; Database altered. SQL archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 25 Next log sequence to archive 27 Current log sequence 27 SQL We can now see that archive log mode is enabled. Notice that Automatic archive is enabled as well. In Oracle 9i an earlier another parameter needed to be set in order to enable automatic archiving. This in no longer the case in 10g and 11g as automatic archiving is enabled when the database is placed in archive log mode. You can switch to the log file to see that an archive is written to archive log location. SQL alter system switch logfile; System altered. SQL host [email protected] ~$ ls /u02/app/oracle/oradata/orcl/arch 1_27_711369564.dbf [email protected] ~$ exit exit SQL The following are the steps required to disable archive log mode on an Oracle 10g or 11g database. Verify the database log mode. [email protected] ~$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 8 12:54:05 2010 Copyright c 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 26 Next log sequence to archive 28 Current log sequence 28 he Database log mode is Archive mode. Next we shut down the database and bring up back up in mount mode. SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount ORACLE instance started. Total System Global Area 849530880 bytes Fixed Size 1339824 bytes Variable Size 511708752 bytes Database Buffers 331350016 bytes Redo Buffers 5132288 bytes Database mounted. SQL All that is left is to disable archive log mode and open the database. SQL alter database noarchivelog; Database altered. SQL alter database open; Database altered. SQL archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 26 Current log sequence 28 SQL
Views: 206 Md Arshad
SQLPLUS: LineSize & PageSize
 
03:49
In this tutorial, you'll learn how to set linesize and pagesize . PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 18633 radhikaravikumar
08 SOA 01 java and orcle XE Installation
 
09:58
After Oracle XE Installation follow the below step : Open SQL Command line : connect sys/[email protected] as sysdba show parameter session show parameter processes alter system reset sessions scope=spfile sid='*'; alter system set processes=400 scope=spfile; Restart DB SOA Installation VERY IMPORTANT NOTE!!!!!!! If you are using Oracle XE as your database, you need to set the RCU_JDBC_TRIM_BLOCKS environment variable to TRUE prior to running RCU. Run Below Command From Terminal : set RCU_JDBC_TRIM_BLOCKS=TRUE echo %RCU_JDBC_TRIM_BLOCKS%
Views: 8 Middleware_Tech
Debugging task flows and memory scope
 
08:31
In this ADF Insider Essentials, you learn how to debug typical errors that occur in ADF applications. Through an example, tips for triaging and debugging an issue using the JDeveloper debugger and the ADF task flow debugger are given.
Views: 2137 ADFInsiderEssentials
LEO March 2016 Oracle Tarot Psychic Astrology Reading
 
20:39
Welcome to my free youtube readings - that I do as a hobby. My tools are both astrology and an oracle that I started to learn at the beginning of 2015. CONTACT ME - I REALLY APPRICIATE ALL FEEDBACK http://vibe.twice.se/contact.html ORACLE DE LA TRIADE Do your own simple reading online with Oracle de la Triade: http://vibe.twice.se/astro-oracle-triade.html Learn more about Oracle de la Triade: http://vibe.twice.se/oracle-triade-card-meanings.html
Views: 1985 Twice
Oracle Forms Training: Master Details with Tab Canvas
 
09:20
Oracle Training in Bangladesh Oracle Developer and Database Training in Bangladesh Oracle Training at Dev Net IT Oracle forms Training Oracle SQL Training Oracle PL SQL Training Oracle BI Training Oracle Web Logic Training Oracle Reports Training for details http://www.devnet-it.com
Views: 15051 devnetbd devnetit
Oracle SOA Suite 12c - Using the SOA Debugger in JDeveloper
 
04:38
This is the third in a 3-part Oracle SOA Suite 12c Developer Productivity Video Series.Work with the SOA Debugger in JDeveloper by learning how to set breakpoints, use the HTTP Analyzer, and debug a project. See the related videos in this series. https://apexapps.oracle.com/pls/apex/f?p=44785:141:108250286674720::NO::: Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
PISCES June 2016 Oracle de la Triade Psychic Tarot Reading
 
12:01
Welcome to my free youtube readings - that I do as a hobby. My tools are both astrology and an oracle that I started to learn at the beginning of 2015. CONTACT ME - I REALLY APPRICIATE ALL FEEDBACK http://vibe.twice.se/contact.html ORACLE DE LA TRIADE Do your own simple reading online with Oracle de la Triade: http://vibe.twice.se/astro-oracle-triade.html Learn more about Oracle de la Triade: http://vibe.twice.se/oracle-triade-card-meanings.html
Views: 1221 Twice
SQL: Delete Vs Truncate Vs Drop
 
08:27
In this tutorial, you'll learn the difference between delete/drop and truncate. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 69362 radhikaravikumar
Enable Archivelog Step by step by Le Anh
 
05:19
Enable Archivelog Step by step by Le Anh with user Oracle step 01: shutdown database shut immediate; step 02: startup nomount; startup nomount; step 02: config prameter: mkdir -p /u01/archivelog alter system set log_archive_start=TRUE SCOPE=SPFILE; System altered. alter system set log_archive_dest_1='LOCATION=/u01/archivelog' scope=spfile; System altered. step 04: Now we mount the database instance: alter database mount; Database altered. Step 05: And finally, we set the database to archive log mode: alter database archivelog; Database altered. Step 06: open database; alter database open; step 07: check archivelog archive log list; switch log ALTER SYSTEM SWITCH LOGFILE; Thanks;
Views: 30 Anh Lê Ngọc
Configuraciones del EPG - (Instalación Oracle APEX 6 de 7)
 
12:49
Este video es parte de la colección de videos del curso "Aprender a Crear una Aplicación Web con Oracle APEX" , puedes acceder al mismo desde el siguiente link: https://www.udemy.com/aprende-a-crear-una-aplicacion-web-con-oracle-apex/ 1) Ingresar al SQL Plus sqlplus / as sysdba 2) Ejecutar script de configuracion PL/SQL Gateway @apex_epg_config.sql C:\ 3) Ejecutar script de actualización directorio virtual de APEX @apxldimg.sql C:\ 4) Desbloquear las siguientes cuentas: ALTER USER anonymous ACCOUNT UNLOCK; ALTER USER xdb ACCOUNT UNLOCK; ALTER USER apex_public_user ACCOUNT UNLOCK; ALTER USER flows_files ACCOUNT UNLOCK; 5) Configurar Parámetros de la Base de Datos para APEX SHOW PARAMETER job_queue_processes ALTER system SET job_queue_processes=20 scope=both; SHOW PARAMETER shared_servers ALTER system SET shared_servers=20 scope=both; 6) Habiliar XML DB HTTP server SELECT DBMS_XDB.GETHTTPPORT FROM dual; EXEC dbms_xdb.sethttpport(8080); Enable remote HTTP connections (optional): EXEC dbms_xdb.setListenerLocalAccess(l_access =[aqui va un signo mayor] FALSE); 7) Habilitar network services (ACL) Conceder acceso a cualquier host para Apex_040200 Ejecutar script del punto "3.4.5.1 Granting Connect Privileges" http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#BABFICIA **** Agradecimiento **** La música es de Jamendo, el track se llama Jingle OWF 2013 por Trancendam, muchas gracias.
Views: 6652 Clarisa Maman Orfali
07 OEM 13C Installation
 
33:20
OEM 13C Installation Package Requirements for Oracle Management Service (OMS) yum install make -y yum install binutils -y yum install gcc -y yum install libaio -y yum install glibc-common -y yum install libstdc -y yum install libXtst -y yum install sysstat -y yum install glibc -y yum install glibc-devel -y yum install glibc-devel -y vi /etc/sysctl.conf kernel.shmmax = 4294967295 net.ipv4.ip_local_port_range = 11000 65000 Database Requirement Set optimizer adaptive features to false alter system set optimizer_adaptive_features=false scope=both sid='*'; Check value using show parameter show parameter optimizer_adaptive_features Restart the Database Unset ORACLE_HOME & ORACLE_SID if you have set them during your Database installation on the same host mkdir -p /u01/app/oracle/product/bip/config mkdir -p /u01/app/oracle/product/bip/cluster chmod 755 em13100_linux64.bin ./em13100_linux64.bin
Views: 911 Middleware_Tech
PL/SQL tutorial 75: PL/SQL Bulk Collect with LIMIT clause in Oracle Database
 
07:37
RebellionRider.com presents the 4th tutorial in Bulk Collect series. Watch and learn how to use Bulk Collect with LIMIT clause to enhance the query performance in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-4 Previous Tutorial ► Bulk Collect with Explicit Cursor https://youtu.be/PSA8HigCcRs ------------------------------------------------------------------------- ►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 http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the 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: 8240 Manish Sharma
Tips and Tricks for Selection Lists in Visual Builder Cloud Service
 
09:57
Improving performance by changing scope, using arrays to get other values from the list.
Views: 823 ShayJDev
OSHO: Oracles, Tarot and Other Divination Tools
 
16:23
OSHO: Oracles, Tarot and Other Divination Tools OSHO ZEN TAROT: http://osho.com/zentarot OSHO TRANSFORMATION TAROT: http://goo.gl/yrcQyX Video: http://.youtube.com/watch?v=zeo6ZJ7WCjY Although Osho was not at all a believer or supporter of future predictions of any kind, he responded to a number of questions regarding oracles, astrology, the i-ching and the tarot. Leaving behind all superstition Osho addresses the real underlying issues of the questions. The Osho Zen Tarot to which Osho gave the name was created not as a tool to predict the future but to understand ourselves -- here-now. In this way it is used today by millions of people in all formats it is available. The OSHO Zen Tarot is available: OSHO Zen Tarot for iPhone : https://goo.gl/lh7DZu OSHO Zen Tarot for Android: https://goo.gl/jmZ0oj OSHO Zen Tarot Print Edition : - US https://goo.gl/jkD6a3 - UK https://goo.gl/dVijha, https://goo.gl/hHPGCa To understand more about OSHO Talks, their context and purpose, see: http://oshotalks.com/AboutOshoTalks.aspx This video is available for translation as part of the 'OSHO TALKS Video Translation Project. Join the project as a translator at: http://www.oshotalks.com OSHO International Foundation: http://www.osho.com Chose playlist in your own language: http://goo.gl/c2Qgk OSHO International Meditation Resort: http://osho.com/visit © OSHO International Foundation OSHO is a registered trademark of OSHO International Foundation
Views: 367687 OSHO International
Scorpio September 2017 RuneScope CHOOSING THE BEST OFFER!
 
24:41
To schedule a 30-minute Skype Consultation, contact me at: [email protected] Your September 2017 Spiritual Guidance Reading from the Goddess Guidance Oracle Cards by Doreen Virtue & your 2017 Mid-Year Check-In RuneScope (covering July-December 2017) can both be found here: https://vimeo.com/ondemand/2017runescopes I have been clairvoyant all of my life, and have been reading for others professionally for 20 years. As in my videos, I use both the Runes and Tarot during private readings, and can usually see 9 to 12 months (sometimes much further) into the future. There is usually time for questions at the end of a private reading. Working with your Spirit Guides, I will deliver the answers and guidance that you need. * Readings are for entertainment purposes only, and should never serve as a replacement for the advice of qualified professionals, such as physicians, psychiatrists, therapists, lawyers, financial advisers, etc. September 2017 Scorpio prediction monthly forecast coaching advice Spiritual Counseling Runes Psychic Horoscopes Tarotscopes Natal Chart Astrology Tarot Clairvoyant Elder Futhark Life Coach
Views: 10790 Rune Scopes
PISCES Weekly October 24 to 30., 2016 Oracle and Astrology Reading
 
12:18
Free psychic oracle reading and astrology forecast for next week of October 24, 2016 for the sign of Pisces. ------------------------------- Welcome to my free YouTube readings - that I do as a hobby. My tools are both astrology and an oracle that I started to learn at the beginning of 2015. CONTACT ME - I REALLY APPRECIATE ALL FEEDBACK http://vibe.twice.se/contact.html ORACLE DE LA TRIADE Do your own simple reading online with Oracle de la Triade: http://vibe.twice.se/astro-oracle-triade.html Learn more about Oracle de la Triade: http://vibe.twice.se/oracle-triade-card-meanings.html
Views: 1902 Twice
SCORPIO Weekly October 17 to 23, 2016 Oracle of Triad and Astrology Reading
 
12:59
Welcome to my free psychic oracle reading and astrology forecast for next week of October 17, 2016 for the sign of Scorpio. --------------- Welcome to my free YouTube readings - that I do as a hobby. My tools are both astrology and an oracle that I started to learn at the beginning of 2015. CONTACT ME - I REALLY APPRECIATE ALL FEEDBACK http://vibe.twice.se/contact.html ORACLE DE LA TRIADE Do your own simple reading online with Oracle de la Triade: http://vibe.twice.se/astro-oracle-triade.html Learn more about Oracle de la Triade: http://vibe.twice.se/oracle-triade-card-meanings.html
Views: 1112 Twice
Saturn in Capricorn 2017-2020 The Rise of the Oppressed
 
21:32
Looking back with great pleasure at the last 3 Saturn transits. Sources for the information in the video: Wikipedia year by year for the years of the Saturn transit, example: 1929 https://en.wikipedia.org/wiki/1929 Welcome to my free YouTube readings - that I do as a hobby. My tools are both astrology and an oracle that I started to learn at the beginning of 2015. CONTACT ME - I REALLY APPRECIATE ALL FEEDBACK http://vibe.twice.se/contact.html ORACLE DE LA TRIADE Do your own simple reading online with Oracle de la Triade: http://vibe.twice.se/astro-oracle-triade.html Learn more about Oracle de la Triade: http://vibe.twice.se/oracle-triade-card-meanings.html
Views: 27860 Twice
leo july 2016 psychic astro scopes by sara perry
 
05:08
Leo Psychic Astro Scope FOR JULY 2016!!! This free psychic and clairvoyant insight applies to the star sign leo. Visit http://www.thesaraperry.co.uk for a private reading using my oracle cubes and tarot cards, numerology readings are also available. Advice on Love, career, money, past life and general well being…. To book a private telephone, skype, written, face to face or audio session go to http://www.saraperrypsychic.co.uk/psychic-readings.html Psychic ‘Skype’ Parties, psychic suppers and corporate events http://www.saraperrypsychic.co.uk/psychic-parties.html Are you interested in changing your life for the better then check out my bootcamps and confidence building workshops on http://www.saraperrypsychic.co.uk/confidence-building-bootcamps---workshops.html Purchase a set of ‘ORACLE CUBES’ http://www.saraperrypsychic.co.uk/oracle-cubes.html Publications http://www.saraperrypsychic.co.uk/books.html Sara Perry a psychic, clairvoyant, Empath, Medium, Reiki Master & NLP Practitioner and has been giving spiritual counsel to the young and older generation for 20 years. She has designed tarot, crystal remedial jewellery and other psychic tools which she uses for readings and as teaching aids for both students and clients. Personal appearances contact [email protected] Media and press contact [email protected] Like the facebook page: https://www.facebook.com/Sara-Perry-Psychic-545977622183955 or tweet: @psychicsarap ♡♡♡ SUBSCRIBE ♡♡♡ to the channel for updates, LIKE and please SHARE!
Views: 606 Sara Perry
Apex - Instalación y ejemplos
 
06:49
En la carpeta apex: sqlplus /nolog conn sys as sysdba @apexins.sql users users temp /i/ alter user anonymous account unlock; alter system set job_queue_processes = 20; alter system set processes =300 scope = spfile; alter system set transactions =370 scope=spfile; alter system set sessions =345 scope=spfile; @apxldimg.sql e:\oraclexe @apxxepwd.sql tupassword
Views: 287 pesjogabonito
SQL: Change User Password
 
02:38
In this tutorial, you'll learn how to change user password in sql plus PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 8683 radhikaravikumar
Taurus May 2018 RuneScope CAREFUL WITH YOUR WORDS!
 
22:47
Your May 2018 Spiritual Guidance Reading from The Faeries’ Oracle by Brian Froud is available on my Vimeo channel here: https://vimeo.com/ondemand/2018runescopes To schedule your 30-minute Skype reading, contact me at: [email protected] I have been clairvoyant all of my life, and have been reading for others professionally for 20 years. Just as in my videos, I use both the Runes and Tarot during private readings, and can usually see 9 months to a year (sometimes much further) into the future. There is also usually ample time for questions if something you want to know isn't covered in the reading. Working with your Spirit Guides, I will deliver the answers and guidance you need. * Readings are for entertainment purposes only, and should never serve as a replacement for the advice of qualified professionals, such as physicians, psychiatrists, therapists, lawyers, financial advisers, etc. May 2018 Taurus prediction monthly forecast coaching advice Spiritual Counseling Runes Psychic Horoscopes Tarotscopes Natal Chart Astrology Tarot Clairvoyant Elder Futhark Life Coach
Views: 4267 Rune Scopes
pisces july 2016 psychic Astro Scope by Sara Perry
 
07:37
pisces Psychic Astro Scope FOR JULY 2016!!! This free psychic and clairvoyant insight applies to the star sign pisces. Visit http://www.thesaraperry.co.uk for a private reading using my oracle cubes and tarot cards, numerology readings are also available. Advice on Love, career, money, past life and general well being…. To book a private telephone, skype, written, face to face or audio session go to http://www.saraperrypsychic.co.uk/psychic-readings.html Psychic ‘Skype’ Parties, psychic suppers and corporate events http://www.saraperrypsychic.co.uk/psychic-parties.html Are you interested in changing your life for the better then check out my bootcamps and confidence building workshops on http://www.saraperrypsychic.co.uk/confidence-building-bootcamps---workshops.html Purchase a set of ‘ORACLE CUBES’ http://www.saraperrypsychic.co.uk/oracle-cubes.html Publications http://www.saraperrypsychic.co.uk/books.html Sara Perry a psychic, clairvoyant, Empath, Medium, Reiki Master & NLP Practitioner and has been giving spiritual counsel to the young and older generation for 20 years. She has designed tarot, crystal remedial jewellery and other psychic tools which she uses for readings and as teaching aids for both students and clients. Personal appearances contact [email protected] Media and press contact [email protected] Like the facebook page: https://www.facebook.com/Sara-Perry-Psychic-545977622183955 or tweet: @psychicsarap ♡♡♡ SUBSCRIBE ♡♡♡ to the channel for updates, LIKE and please SHARE!
Views: 508 Sara Perry
sagittarius july 2016 psychic astro scope by sara perry
 
05:36
sagittarius Psychic Astro Scope FOR JULY 2016!!! This free psychic and clairvoyant insight applies to the star sign sagittarius. Visit http://www.thesaraperry.co.uk for a private reading using my oracle cubes and tarot cards, numerology readings are also available. Advice on Love, career, money, past life and general well being…. To book a private telephone, skype, written, face to face or audio session go to http://www.saraperrypsychic.co.uk/psychic-readings.html Psychic ‘Skype’ Parties, psychic suppers and corporate events http://www.saraperrypsychic.co.uk/psychic-parties.html Are you interested in changing your life for the better then check out my bootcamps and confidence building workshops on http://www.saraperrypsychic.co.uk/confidence-building-bootcamps---workshops.html Purchase a set of ‘ORACLE CUBES’ http://www.saraperrypsychic.co.uk/oracle-cubes.html Publications http://www.saraperrypsychic.co.uk/books.html Sara Perry a psychic, clairvoyant, Empath, Medium, Reiki Master & NLP Practitioner and has been giving spiritual counsel to the young and older generation for 20 years. She has designed tarot, crystal remedial jewellery and other psychic tools which she uses for readings and as teaching aids for both students and clients. Personal appearances contact [email protected] Media and press contact [email protected] Like the facebook page: https://www.facebook.com/Sara-Perry-Psychic-545977622183955 or tweet: @psychicsarap ♡♡♡ SUBSCRIBE ♡♡♡ to the channel for updates, LIKE and please SHARE!
Views: 385 Sara Perry
gemini july 2016 psychic astro scope by sara perry
 
06:15
gemini Psychic Astro Scope FOR JULY 2016!!! This free psychic and clairvoyant insight applies to the star sign gemini Visit http://www.thesaraperry.co.uk for a private reading using my oracle cubes and tarot cards, numerology readings are also available. Advice on Love, career, money, past life and general well being…. To book a private telephone, skype, written, face to face or audio session go to http://www.saraperrypsychic.co.uk/psychic-readings.html Psychic ‘Skype’ Parties, psychic suppers and corporate events http://www.saraperrypsychic.co.uk/psychic-parties.html Are you interested in changing your life for the better then check out my bootcamps and confidence building workshops on http://www.saraperrypsychic.co.uk/confidence-building-bootcamps---workshops.html Purchase a set of ‘ORACLE CUBES’ http://www.saraperrypsychic.co.uk/oracle-cubes.html Publications http://www.saraperrypsychic.co.uk/books.html Sara Perry a psychic, clairvoyant, Empath, Medium, Reiki Master & NLP Practitioner and has been giving spiritual counsel to the young and older generation for 20 years. She has designed tarot, crystal remedial jewellery and other psychic tools which she uses for readings and as teaching aids for both students and clients. Personal appearances contact [email protected] Media and press contact [email protected] Like the facebook page: https://www.facebook.com/Sara-Perry-Psychic-545977622183955 or tweet: @psychicsarap ♡♡♡ SUBSCRIBE ♡♡♡ to the channel for updates, LIKE and please SHARE!
Views: 543 Sara Perry
Capricorn August 2017 RuneScope BIRTH, CREATION, & LOVE!
 
28:55
To schedule a 30-minute Skype Consultation, contact me at: [email protected] Your August 2017 Spiritual Guidance Reading from the Astrological Oracle by Antonella Castelli & 2017 Mid-Year Check-In RuneScope can both be found here: https://vimeo.com/ondemand/2017runescopes I have been clairvoyant all of my life, and have been reading for others professionally for 20 years. As in my videos, I use both the Runes and Tarot during private readings, and can usually see 9 to 12 months (sometimes much further) into the future. There is usually time for questions at the end of a private reading. Working with your Spirit Guides, I will deliver the answers and guidance that you need. * Readings are for entertainment purposes only, and should never serve as a replacement for the advice of qualified professionals, such as physicians, psychiatrists, therapists, lawyers, financial advisers, etc. August 2017 Capricorn prediction monthly forecast coaching advice Spiritual Counseling Runes Psychic Horoscopes Tarotscopes Natal Chart Astrology Tarot Clairvoyant Elder Futhark Life Coach
Views: 5642 Rune Scopes
Recuperacion de un archivo de control Oracle 11g
 
04:23
Log de alertas en SQLPLUS: SET linesize 160 pagesize 200 col RECORD_ID FOR 9999999 head ID col ORIGINATING_TIMESTAMP FOR a20 head DATE col MESSAGE_TEXT FOR a120 head Message SELECT record_id, to_char(originating_timestamp,'DD.MM.YYYY HH24:MI:SS'), message_text FROM x$dbgalertext; Otra consulta interesante para cambiar los archivos de control, ya sea porque falla la ubicación fisica. ALTER SYSTEM SET control_files = ' ', ' ' SCOPE=SPFILE; donde ' ' es donde quiere colocar la nueva ubicacion y se separan los archivos de control por , por ejemplo: ALTER SYSTEM SET control_files = '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/u01/app/oracle/oradata/inacap/control01.ctl', '/u01/app/oracle/oradata/inacap/control02.ctl' SCOPE=SPFILE;
Views: 142 Kevin Gonzalez
Gemini August 2017 RuneScope DEVIL'S IN THE DETAILS!
 
23:09
To schedule a 30-minute Skype Consultation, contact me at: [email protected] Your August 2017 Spiritual Guidance Reading from the Astrological Oracle by Antonella Castelli & 2017 Mid-Year Check-In RuneScope can both be found here: https://vimeo.com/ondemand/2017runescopes I have been clairvoyant all of my life, and have been reading for others professionally for 20 years. As in my videos, I use both the Runes and Tarot during private readings, and can usually see 9 to 12 months (sometimes much further) into the future. There is usually time for questions at the end of a private reading. Working with your Spirit Guides, I will deliver the answers and guidance that you need. * Readings are for entertainment purposes only, and should never serve as a replacement for the advice of qualified professionals, such as physicians, psychiatrists, therapists, lawyers, financial advisers, etc. August 2017 Gemini prediction monthly forecast coaching advice Spiritual Counseling Runes Psychic Horoscopes Tarotscopes Natal Chart Astrology Tarot Clairvoyant Elder Futhark Life Coach
Views: 5484 Rune Scopes
Scorpio October 2017 RuneScope LEAP OF FAITH!
 
22:33
To schedule a 30-minute Skype Consultation, contact me at: [email protected] Your October 2017 Spiritual Guidance Reading from the The Halloween Oracle by Stacey Demarco & your 2017 Mid-Year Check-In RuneScope (covering July-December 2017) can both be found here: https://vimeo.com/ondemand/2017runescopes I have been clairvoyant all of my life, and have been reading for others professionally for 20 years. As in my videos, I use both the Runes and Tarot during private readings, and can usually see 9 to 12 months (sometimes much further) into the future. There is usually time for questions at the end of a private reading. Working with your Spirit Guides, I will deliver the answers and guidance that you need. * Readings are for entertainment purposes only, and should never serve as a replacement for the advice of qualified professionals, such as physicians, psychiatrists, therapists, lawyers, financial advisers, etc. October 2017 Scorpio prediction monthly forecast coaching advice Spiritual Counseling Runes Psychic Horoscopes Tarotscopes Natal Chart Astrology Tarot Clairvoyant Elder Futhark Life Coach
Views: 7989 Rune Scopes
aquarius july 2016 Psychic Astro Scope by Sara Perry
 
06:29
Aquarius Psychic Astro Scope FOR JULY 2016!!! This free psychic and clairvoyant insight applies to the star sign Aquarius. Visit http://www.thesaraperry.co.uk for a private reading using my oracle cubes and tarot cards, numerology readings are also available. Advice on Love, career, money, past life and general well being…. To book a private telephone, skype, written, face to face or audio session go to http://www.saraperrypsychic.co.uk/psychic-readings.html Psychic ‘Skype’ Parties, psychic suppers and corporate events http://www.saraperrypsychic.co.uk/psychic-parties.html Are you interested in changing your life for the better then check out my bootcamps and confidence building workshops on http://www.saraperrypsychic.co.uk/confidence-building-bootcamps---workshops.html Purchase a set of ‘ORACLE CUBES’ http://www.saraperrypsychic.co.uk/oracle-cubes.html Publications http://www.saraperrypsychic.co.uk/books.html Sara Perry a psychic, clairvoyant, Empath, Medium, Reiki Master & NLP Practitioner and has been giving spiritual counsel to the young and older generation for 20 years. She has designed tarot, crystal remedial jewellery and other psychic tools which she uses for readings and as teaching aids for both students and clients. Personal appearances contact [email protected] Media and press contact [email protected] Like the facebook page: https://www.facebook.com/Sara-Perry-Psychic-545977622183955 or tweet: @psychicsarap ♡♡♡ SUBSCRIBE ♡♡♡ to the channel for updates, LIKE and please SHARE!
Views: 485 Sara Perry
aries july 2016  psychic astro scope by sara perry
 
07:55
Aries Psychic Astro Scope FOR JULY 2016!!! This free psychic and clairvoyant insight applies to the star sign Aries Visit http://www.thesaraperry.co.uk for a private reading using my oracle cubes and tarot cards, numerology readings are also available. Advice on Love, career, money, past life and general well being…. To book a private telephone, skype, written, face to face or audio session go to http://www.saraperrypsychic.co.uk/psychic-readings.html Psychic ‘Skype’ Parties, psychic suppers and corporate events http://www.saraperrypsychic.co.uk/psychic-parties.html Are you interested in changing your life for the better then check out my bootcamps and confidence building workshops on http://www.saraperrypsychic.co.uk/confidence-building-bootcamps---workshops.html Purchase a set of ‘ORACLE CUBES’ http://www.saraperrypsychic.co.uk/oracle-cubes.html Publications http://www.saraperrypsychic.co.uk/books.html Sara Perry a psychic, clairvoyant, Empath, Medium, Reiki Master & NLP Practitioner and has been giving spiritual counsel to the young and older generation for 20 years. She has designed tarot, crystal remedial jewellery and other psychic tools which she uses for readings and as teaching aids for both students and clients. Personal appearances contact [email protected] Media and press contact [email protected] Like the facebook page: https://www.facebook.com/Sara-Perry-Psychic-545977622183955 or tweet: @psychicsarap ♡♡♡ SUBSCRIBE ♡♡♡ to the channel for updates, LIKE and please SHARE!
Views: 406 Sara Perry
Aquarius August 2016 Psychic Astro Scopes With Sara Perry
 
07:44
Aquarius Psychic Astro Scope FOR August 2016!!! This free psychic and clairvoyant insight applies to the star sign Aquarius. Visit http://www.thesaraperry.co.uk for a private reading using my oracle cubes and tarot cards, numerology readings are also available. Advice on Love, career, money, past life and general well being…. To book a private telephone, skype, written, face to face or audio session go to http://www.saraperrypsychic.co.uk/psy... all information given places you under no obligation to take action based on the guidance given.Advice on ill health should not take the place of conventional medicine, please consult your General Practitioner. By booking a reading you are confirming that you have read and understood the above statement and terms and conditions. Psychic ‘Skype’ Parties, psychic suppers and corporate events http://www.saraperrypsychic.co.uk/psy... Are you interested in changing your life for the better then check out my bootcamps and confidence building workshops on http://www.saraperrypsychic.co.uk/con... Purchase a set of ‘ORACLE CUBES’ http://www.saraperrypsychic.co.uk/ora... Publications http://www.saraperrypsychic.co.uk/boo... Sara Perry a psychic, clairvoyant, Empath, Medium, Reiki Master & NLP Practitioner and has been giving spiritual counsel to the young and older generation for 20 years. She has designed tarot, crystal remedial jewellery and other psychic tools which she uses for readings and as teaching aids for both students and clients. Like the facebook page: https://www.facebook.com/Sara-Perry-P... or tweet: @psychicsarap ♡♡♡ SUBSCRIBE ♡♡♡ to the channel for updates, LIKE and please
Views: 597 Sara Perry
scorpio july 2016 astro psychic scope by sara perry
 
06:01
scorpio Psychic Astro Scope FOR JULY 2016!!! This free psychic and clairvoyant insight applies to the star sign scorpio. Visit http://www.thesaraperry.co.uk for a private reading using my oracle cubes and tarot cards, numerology readings are also available. Advice on Love, career, money, past life and general well being…. To book a private telephone, skype, written, face to face or audio session go to http://www.saraperrypsychic.co.uk/psychic-readings.html Psychic ‘Skype’ Parties, psychic suppers and corporate events http://www.saraperrypsychic.co.uk/psychic-parties.html Are you interested in changing your life for the better then check out my bootcamps and confidence building workshops on http://www.saraperrypsychic.co.uk/confidence-building-bootcamps---workshops.html Purchase a set of ‘ORACLE CUBES’ http://www.saraperrypsychic.co.uk/oracle-cubes.html Publications http://www.saraperrypsychic.co.uk/books.html Sara Perry a psychic, clairvoyant, Empath, Medium, Reiki Master & NLP Practitioner and has been giving spiritual counsel to the young and older generation for 20 years. She has designed tarot, crystal remedial jewellery and other psychic tools which she uses for readings and as teaching aids for both students and clients. Personal appearances contact [email protected] Media and press contact [email protected] Like the facebook page: https://www.facebook.com/Sara-Perry-Psychic-545977622183955 or tweet: @psychicsarap ♡♡♡ SUBSCRIBE ♡♡♡ to the channel for updates, LIKE and please SHARE!
Views: 512 Sara Perry
capricorn july 2016 psychic astro scope by sara perry
 
04:45
capricorn Psychic Astro Scope FOR JULY 2016!!! This free psychic and clairvoyant insight applies to the star sign capricorn. Visit http://www.thesaraperry.co.uk for a private reading using my oracle cubes and tarot cards, numerology readings are also available. Advice on Love, career, money, past life and general well being…. To book a private telephone, skype, written, face to face or audio session go to http://www.saraperrypsychic.co.uk/psychic-readings.html Psychic ‘Skype’ Parties, psychic suppers and corporate events http://www.saraperrypsychic.co.uk/psychic-parties.html Are you interested in changing your life for the better then check out my bootcamps and confidence building workshops on http://www.saraperrypsychic.co.uk/confidence-building-bootcamps---workshops.html Purchase a set of ‘ORACLE CUBES’ http://www.saraperrypsychic.co.uk/oracle-cubes.html Publications http://www.saraperrypsychic.co.uk/books.html Sara Perry a psychic, clairvoyant, Empath, Medium, Reiki Master & NLP Practitioner and has been giving spiritual counsel to the young and older generation for 20 years. She has designed tarot, crystal remedial jewellery and other psychic tools which she uses for readings and as teaching aids for both students and clients. Personal appearances contact [email protected] Media and press contact [email protected] Like the facebook page: https://www.facebook.com/Sara-Perry-Psychic-545977622183955 or tweet: @psychicsarap ♡♡♡ SUBSCRIBE ♡♡♡ to the channel for updates, LIKE and please SHARE!
Views: 501 Sara Perry
taurus july 2016 psychic astro scope with sara perry
 
07:00
Taurus Psychic Astro Scope FOR JULY 2016!!! This free psychic and clairvoyant insight applies to the star sign Taurus. Visit http://www.thesaraperry.co.uk for a private reading using my oracle cubes and tarot cards, numerology readings are also available. Advice on Love, career, money, past life and general well being…. To book a private telephone, skype, written, face to face or audio session go to http://www.saraperrypsychic.co.uk/psychic-readings.html Psychic ‘Skype’ Parties, psychic suppers and corporate events http://www.saraperrypsychic.co.uk/psychic-parties.html Are you interested in changing your life for the better then check out my bootcamps and confidence building workshops on http://www.saraperrypsychic.co.uk/confidence-building-bootcamps---workshops.html Purchase a set of ‘ORACLE CUBES’ http://www.saraperrypsychic.co.uk/oracle-cubes.html Publications http://www.saraperrypsychic.co.uk/books.html Sara Perry a psychic, clairvoyant, Empath, Medium, Reiki Master & NLP Practitioner and has been giving spiritual counsel to the young and older generation for 20 years. She has designed tarot, crystal remedial jewellery and other psychic tools which she uses for readings and as teaching aids for both students and clients. Personal appearances contact [email protected] Media and press contact [email protected] Like the facebook page: https://www.facebook.com/Sara-Perry-Psychic-545977622183955 or tweet: @psychicsarap ♡♡♡ SUBSCRIBE ♡♡♡ to the channel for updates, LIKE and please SHARE!
Views: 452 Sara Perry
Visual C# 2010 -  Variable Scope
 
06:47
In this video I take a look at the scope of a variable at three different locations. The first is the nested level scope where the variable is created within a conditional block of code like an if-statement. The second scope is the method level scope where I created a variable within a method and can use it both in the method and conditions within that method. The third scope was the class level scope where I created a variable that could be used by all methods within the class. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 3773 Lecture Snippets